IESO logo

IESO Operating Reserve Prices

Operating-reserve prices by product (10S ten-minute synchronized, 10N ten-minute non-synchronized, 30R thirty-minute) and location in each market run.

Native record
market run x reserve class x location x interval
five-minute real-time; hourly day-ahead publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · event_time

Overview

Operating-reserve prices by product (10S ten-minute synchronized, 10N ten-minute non-synchronized, 30R thirty-minute) and location in each market run.

Query contract

Preserve one canonical row per (event_time, market_run, or_class, location) before aggregating.

Analysis rules

  • Filter one market_run: 'rt_5min' (real-time, five-minute), 'da_hourly' (day-ahead market) or 'predispatch_hourly' (pre-dispatch projection). Never mix runs, and never take max(event_time) without one: day-ahead rows reach into tomorrow.
  • 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.
  • Prices are Canadian dollars per MWh. Never add, rank or average them with US-dollar prices without a dated exchange rate, and say which rate was used.

Access

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

Schema6

Column
Type
event_timeDateTime64(6, 'UTC')
market_runLowCardinality(String)
or_classLowCardinality(String)
locationLowCardinality(String)
lmpNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timemarket_runor_classlocationlmpingested_at
2026-10-12 04:00:00.000000da_hourly30RZURICH-LT.AG_T10.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYOUNGDAVIDSN-LT.TT_LF_DRA0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYOUNGDAVIDSN-LT.TT260.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYORKCGS-LT.G20.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYORKCGS-LT.G10.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYORKBESS-LT.BATT_TG0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYORKBESS-LT.BATT_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RYELLOWFALLS-LT.AG_T10.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWOODSTOCK-LT_WOOD0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWOODROFFE-LT.TT13_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWOODBRIDGE-LT_VAUG0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWONDERLAND-LT.LFBY0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWOLVERTON-LT.TT_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWOLFEISLAND-LT.AG_T10.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWINSTON-LT.T1_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWINONA-LT.T1_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWINGHAM-LT.LFBY0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWINDSORSF-LT.AG_T10.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILTSHIRE-LT.TT1_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILSON-LT.LFJQ0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILSON-LT.LFEZ0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILMOT-LT.LF1110.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILIAMS-LT.TT_LF0.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWILHAVEN-LT.T120.092026-10-10 17:35:30.802469
2026-10-12 04:00:00.000000da_hourly30RWHITERIVER-LT.TT_LF0.092026-10-10 17:35:30.802469

Coverage

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