IESO logo

IESO Demand by Region (hourly)

Hourly Ontario demand and demand in each of IESO's ten demand regions (Toronto, Ottawa, Essa and the rest), since 2003.

Native record
hour
daily, for the previous day publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Hourly Ontario demand and demand in each of IESO's ten demand regions (Toronto, Ottawa, Essa and the rest), since 2003.

Query contract

Preserve one canonical row per (event_time) before aggregating.

Analysis rules

  • Rows repeat across polls: dedupe with argMax(value, ingested_at) per key.

Interpretation

  • event_time marks the END of the interval or hour. IESO delivers on EST all year, but this mirror's event_time was built on Toronto wall time, so between the second Sunday of March and the first Sunday of November it is one hour early. The delivery end is event_time + toIntervalSecond(timeZoneOffset(toTimeZone(event_time, 'America/Toronto')) + 18000); rows in the spring-forward hour cannot be placed. Toronto civil time is for display only.
  • Demand regions are not price zones. Published a day late: the latest hours are yesterday's.

Access

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

Schema15

Column
Type
event_timeDateTime64(6, 'UTC')
ontario_demandNullable(Float64)
northwestNullable(Float64)
northeastNullable(Float64)
ottawaNullable(Float64)
eastNullable(Float64)
torontoNullable(Float64)
essaNullable(Float64)
bruceNullable(Float64)
southwestNullable(Float64)
niagaraNullable(Float64)
westNullable(Float64)
zones_totalNullable(Float64)
diffNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeontario_demandnorthwestnortheastottawaeasttorontoessabrucesouthwestniagarawestzones_totaldiffingested_at
2026-10-10 04:00:00.00000013886396133584480748739327728395181494141142282026-10-10 17:10:33.785263
2026-10-10 04:00:00.00000013886396133584480748739327728395181494141142282026-10-10 16:10:33.239365
2026-10-10 03:00:00.00000014511412141090085851669947529695471543148733622026-10-10 17:10:33.785263
2026-10-10 03:00:00.00000014511412141090085851669947529695471543148733622026-10-10 16:10:33.239365
2026-10-10 02:00:00.000000152974141398961925542210597830815111629154781812026-10-10 17:10:33.785263
2026-10-10 02:00:00.000000152974141398961925542210597830815111629154781812026-10-10 16:10:33.239365
2026-10-10 01:00:00.0000001609143813691024984577611298232765551714163452542026-10-10 17:10:33.785263
2026-10-10 01:00:00.0000001609143813691024984577611298232765551714163452542026-10-10 16:10:33.239365
2026-10-10 00:00:00.00000016567443131210631024596211778633555781764167631962026-10-10 17:10:33.785263
2026-10-10 00:00:00.00000016567443131210631024596211778633555781764167631962026-10-10 16:10:33.239365
2026-10-09 23:00:00.00000016722435126010641031604811899233275761835168591362026-10-10 17:10:33.785263
2026-10-09 23:00:00.00000016722435126010641031604811899233275761835168591362026-10-10 16:10:33.239365
2026-10-09 22:00:00.0000001665542712601053101059571127933289564191716696412026-10-10 17:10:33.785263
2026-10-09 22:00:00.0000001665542712601053101059571127933289564191716696412026-10-10 16:10:33.239365
2026-10-09 21:00:00.000000164644261224104590359901029873263563194916480162026-10-10 17:10:33.785263
2026-10-09 21:00:00.000000164644261224104590359901029873263563194916480162026-10-10 16:10:33.239365
2026-10-09 20:00:00.0000001590441411929867215976894833168554187315860-442026-10-10 17:10:33.785263
2026-10-09 20:00:00.0000001590441411929867215976894833168554187315860-442026-10-10 16:10:33.239365
2026-10-09 19:00:00.00000016048408116410037155936801743326552177815757-2912026-10-10 17:10:33.785263
2026-10-09 19:00:00.00000016048408116410037155936801743326552177815757-2912026-10-10 16:10:33.239365
2026-10-09 18:00:00.000000155794101153101469159987896634285631728158402612026-10-10 17:10:33.785263
2026-10-09 18:00:00.000000155794101153101469159987896634285631728158402612026-10-10 16:10:33.239365
2026-10-09 17:00:00.0000001570141311729885276073841773320571166915652-482026-10-10 17:10:33.785263
2026-10-09 17:00:00.0000001570141311729885276073841773320571166915652-482026-10-10 16:10:33.239365
2026-10-09 16:00:00.0000001566041312739505126039843683352557163315642-192026-10-10 17:10:33.785263

Coverage

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