Ask the Grid
Create free workspace
Hydro-Québec logo

Québec Electricity Demand (history)

Hydro-Québec's archive of hourly average Québec demand from 2019 through the end of 2024.

Load dataHydro-Québec market
Query with the agent
Native record
hour
hourly, 2019 through 2024 publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Hydro-Québec's archive of hourly average Québec demand from 2019 through the end of 2024.

Query contract

Preserve one canonical row per (event_time) before aggregating.

Analysis rules

  • Dedupe with argMax(moyenne_mw, ingested_at) per event_time.
  • For 'compared with last year' or 'is this high for the season', compare against the same local date and hour across 2019–2024 here (toTimeZone(event_time, 'America/Toronto')), say which years, and give the range rather than refusing.

Interpretation

  • event_time is the UTC instant HQ stamps the value with. Québec civil time is America/Toronto.
  • HQ's open data has no demand between this archive's end and the start of the live capture; never interpolate across that gap.

Access

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema9

Column
Type
datasetidString
recordidString
record_timestampNullable(String)
snapshot_atDateTime64(6, 'UTC')
event_timeNullable(DateTime64(6, 'UTC'))
source_record_jsonString
dateNullable(String)
moyenne_mwNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

datasetidrecordidrecord_timestampsnapshot_atevent_timesource_record_jsondatemoyenne_mwingested_at
historique-demande-electricite-quebec09127260f4065dfda6a11077a9250b9a4f85ddd72026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 05:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"09127260f4065dfda6a11077a9250b9a4f85ddd7","fields":{"date":"2025-01-01T05:00:00Z","moyenne_mw":21598.78},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T05:00:00Z21598.782026-10-09 01:07:53.414323
historique-demande-electricite-quebeccc0a8ba714db78182da9fd9922a488b0781615602026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 04:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"cc0a8ba714db78182da9fd9922a488b078161560","fields":{"date":"2025-01-01T04:00:00Z","moyenne_mw":21855.44},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T04:00:00Z21855.442026-10-09 01:07:55.617216
historique-demande-electricite-quebecdf0c61dd8dccabe951eea5d0b879b57634b2512a2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 03:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"df0c61dd8dccabe951eea5d0b879b57634b2512a","fields":{"date":"2025-01-01T03:00:00Z","moyenne_mw":22496.22},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T03:00:00Z22496.222026-10-09 01:08:16.019773
historique-demande-electricite-quebec93fbd64cb000e29e138da973365363eda16c85462026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 02:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"93fbd64cb000e29e138da973365363eda16c8546","fields":{"date":"2025-01-01T02:00:00Z","moyenne_mw":22969.59},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T02:00:00Z22969.592026-10-09 01:07:55.617216
historique-demande-electricite-quebeccf441a3538cbe4801202953ee8d05922b1bf0f612026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 01:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"cf441a3538cbe4801202953ee8d05922b1bf0f61","fields":{"date":"2025-01-01T01:00:00Z","moyenne_mw":23592.59},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T01:00:00Z23592.592026-10-09 01:07:55.617216
historique-demande-electricite-quebec7f9abb3811a375b1c1430eb8e3015a9797c2664d2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532025-01-01 00:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"7f9abb3811a375b1c1430eb8e3015a9797c2664d","fields":{"date":"2025-01-01T00:00:00Z","moyenne_mw":24404.29},"record_timestamp":"2026-06-05T22:03:26.163Z"}2025-01-01T00:00:00Z24404.292026-10-09 01:08:16.019773
historique-demande-electricite-quebec6b33fbbb1b750f74401ceb697a9ade5c613219e02026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 23:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"6b33fbbb1b750f74401ceb697a9ade5c613219e0","fields":{"date":"2024-12-31T23:00:00Z","moyenne_mw":24945.3},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T23:00:00Z24945.32026-10-09 01:08:16.019773
historique-demande-electricite-quebec7d7d6626639ce99915e3cbf6830c26e84cfe05822026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 22:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"7d7d6626639ce99915e3cbf6830c26e84cfe0582","fields":{"date":"2024-12-31T22:00:00Z","moyenne_mw":24785.91},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T22:00:00Z24785.912026-10-09 01:07:55.617216
historique-demande-electricite-quebecc5f0da8289798bac3319f3ed4ec1f408fc23388e2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 21:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"c5f0da8289798bac3319f3ed4ec1f408fc23388e","fields":{"date":"2024-12-31T21:00:00Z","moyenne_mw":23794.95},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T21:00:00Z23794.952026-10-09 01:08:16.019773
historique-demande-electricite-quebecd84893ddd990c0ffe48dc8d56ff48405e9aeacd72026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 20:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"d84893ddd990c0ffe48dc8d56ff48405e9aeacd7","fields":{"date":"2024-12-31T20:00:00Z","moyenne_mw":23535.9},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T20:00:00Z23535.92026-10-09 01:07:53.414323
historique-demande-electricite-quebecea226e471b0b798d1d071c206ca65b17196de98d2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 19:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"ea226e471b0b798d1d071c206ca65b17196de98d","fields":{"date":"2024-12-31T19:00:00Z","moyenne_mw":23533.55},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T19:00:00Z23533.552026-10-09 01:08:16.019773
historique-demande-electricite-quebec5ab651d2dd998ae3a271883651f40441929a33032026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 18:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"5ab651d2dd998ae3a271883651f40441929a3303","fields":{"date":"2024-12-31T18:00:00Z","moyenne_mw":23996.3},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T18:00:00Z23996.32026-10-09 01:07:53.414323
historique-demande-electricite-quebec7f58e761330a85dad38844ddf734c264180dad842026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 17:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"7f58e761330a85dad38844ddf734c264180dad84","fields":{"date":"2024-12-31T17:00:00Z","moyenne_mw":24376.58},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T17:00:00Z24376.582026-10-09 01:07:55.617216
historique-demande-electricite-quebecfacfe204780dc23a28d50ff81e9889256bbcc4522026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 16:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"facfe204780dc23a28d50ff81e9889256bbcc452","fields":{"date":"2024-12-31T16:00:00Z","moyenne_mw":24435.98},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T16:00:00Z24435.982026-10-09 01:07:55.617216
historique-demande-electricite-quebec11b9c9eda8ebe30ce3ca268a947485908be8e7182026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 15:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"11b9c9eda8ebe30ce3ca268a947485908be8e718","fields":{"date":"2024-12-31T15:00:00Z","moyenne_mw":24252.24},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T15:00:00Z24252.242026-10-09 01:07:55.617216
historique-demande-electricite-quebec4cc5719c6d92f4cc50282069fe6808f6f4611db52026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 14:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"4cc5719c6d92f4cc50282069fe6808f6f4611db5","fields":{"date":"2024-12-31T14:00:00Z","moyenne_mw":23844.25},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T14:00:00Z23844.252026-10-09 01:08:16.019773
historique-demande-electricite-quebec4fa2e96235f8b52e510fc3722e12d8d2194c8b662026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 13:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"4fa2e96235f8b52e510fc3722e12d8d2194c8b66","fields":{"date":"2024-12-31T13:00:00Z","moyenne_mw":23265.49},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T13:00:00Z23265.492026-10-09 01:08:16.019773
historique-demande-electricite-quebec9e24062c3fd5135ef874c346ef192fbff2e6f16c2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 12:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"9e24062c3fd5135ef874c346ef192fbff2e6f16c","fields":{"date":"2024-12-31T12:00:00Z","moyenne_mw":22658.41},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T12:00:00Z22658.412026-10-09 01:07:55.617216
historique-demande-electricite-quebecf8463e0df2c86da5e80bafce84d1edf957745e582026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 11:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"f8463e0df2c86da5e80bafce84d1edf957745e58","fields":{"date":"2024-12-31T11:00:00Z","moyenne_mw":21831.17},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T11:00:00Z21831.172026-10-09 01:07:53.414323
historique-demande-electricite-quebec4b917d54978c67525f7bb5d049cdb0cdad800d192026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 10:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"4b917d54978c67525f7bb5d049cdb0cdad800d19","fields":{"date":"2024-12-31T10:00:00Z","moyenne_mw":21133.3},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T10:00:00Z21133.32026-10-09 01:07:55.617216
historique-demande-electricite-quebec92179f055f8422615880db8932ef2765809a53c12026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 09:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"92179f055f8422615880db8932ef2765809a53c1","fields":{"date":"2024-12-31T09:00:00Z","moyenne_mw":20863.6},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T09:00:00Z20863.62026-10-09 01:07:53.414323
historique-demande-electricite-quebecda24de7b3be58aff2038a16a4e71c2737a0287fc2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 08:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"da24de7b3be58aff2038a16a4e71c2737a0287fc","fields":{"date":"2024-12-31T08:00:00Z","moyenne_mw":20734.78},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T08:00:00Z20734.782026-10-09 01:08:16.019773
historique-demande-electricite-quebecf8f6e86d17836a753a5aeef4c1085de8452163ca2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 07:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"f8f6e86d17836a753a5aeef4c1085de8452163ca","fields":{"date":"2024-12-31T07:00:00Z","moyenne_mw":20757.75},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T07:00:00Z20757.752026-10-09 01:07:55.617216
historique-demande-electricite-quebeca0aff87098b1f736652c5893fc651bfb30edbaa12026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 06:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"a0aff87098b1f736652c5893fc651bfb30edbaa1","fields":{"date":"2024-12-31T06:00:00Z","moyenne_mw":20992.8},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T06:00:00Z20992.82026-10-09 01:08:16.019773
historique-demande-electricite-quebec529029efddb54e32d3196d0e9dcb29307f97222c2026-06-05T22:03:26.163Z2026-10-09 01:07:49.9891532024-12-31 05:00:00.000000{"datasetid":"historique-demande-electricite-quebec","recordid":"529029efddb54e32d3196d0e9dcb29307f97222c","fields":{"date":"2024-12-31T05:00:00Z","moyenne_mw":21473.15},"record_timestamp":"2026-06-05T22:03:26.163Z"}2024-12-31T05:00:00Z21473.152026-10-09 01:07:53.414323

Coverage

No time-indexed data — coverage isn’t applicable to this dataset.