IESO logo

IESO Virtual Zone Prices

Prices in IESO's virtual transaction zones, where virtual bids and offers settle.

Native record
market run x virtual zone 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

Prices in IESO's virtual transaction zones, where virtual bids and offers settle.

Query contract

Preserve one canonical row per (event_time, market_run, zone_name) 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.

Schema8

Column
Type
event_timeDateTime64(6, 'UTC')
market_runLowCardinality(String)
zone_nameLowCardinality(String)
lmpNullable(Float64)
congestionNullable(Float64)
lossNullable(Float64)
publish_timeNullable(DateTime64(6, 'UTC'))
ingested_atDateTime64(6, 'UTC')

Sample data

event_timemarket_runzone_namelmpcongestionlosspublish_timeingested_at
2026-10-11 04:00:00.000000predispatch_hourlyWEST:HUB30.58-0.67-0.83∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyTORONTO:HUB32.100.02∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlySOUTHWEST:HUB31.08-0.67-0.33∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyOTTAWA:HUB33.5801.5∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyNORTHWEST:HUB27.74-4.01-0.34∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyNORTHEAST:HUB33.501.42∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyNIAGARA:HUB30.17-0.34-1.57∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyESSA:HUB32.7900.71∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyEAST:HUB32.9300.84∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyWEST:HUB33.54-7.63-0.79∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyTORONTO:HUB4200.04∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlySOUTHWEST:HUB33.93-7.62-0.41∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyOTTAWA:HUB43.8901.93∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyNORTHWEST:HUB40.810-1.15∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyNORTHEAST:HUB43.5301.57∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyNIAGARA:HUB36.85-3.81-1.29∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyESSA:HUB42.6900.73∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000da_hourlyEAST:HUB43.0901.13∅2026-10-10 17:35:19.543734
2026-10-11 04:00:00.000000predispatch_hourlyWEST:HUB30.58-0.67-0.83∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlyTORONTO:HUB32.100.02∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlySOUTHWEST:HUB31.08-0.67-0.33∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlyOTTAWA:HUB33.5801.5∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlyNORTHWEST:HUB27.74-4.01-0.34∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlyNORTHEAST:HUB33.501.42∅2026-10-10 17:30:26.910031
2026-10-11 04:00:00.000000predispatch_hourlyNIAGARA:HUB30.17-0.34-1.57∅2026-10-10 17:30:26.910031

Coverage

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