The practice of hydraulic fracturing, an unconventional oil and gas extraction method, has increased significantly in North America. This study presents the temporal dynamics of hydraulically fractured wells and water use from a two-year (2013 and 2014) case study of 432 wells in Northwestern Alberta, Canada. The number of hydraulically fractured wells was greater in all but two months in 2014 compared to 2013. Water consumption not only depended on the number of wells, but also on the type of rock formation, how deep and how many stages were required to fracture the targeted formation. The average water consumption per well was 3,671 m3. The majority (52%) of total water consumption occurred during low flow periods. We recommend monitoring nearby water sources to develop sustainable water resources management plans for hydraulic fracturing to minimise substantial negative impacts on water sources during low flow periods.