IESO logo

IESO Real-Time Totals

IESO's real-time market totals: Ontario demand (ontario_load), market total load, total energy and losses, scheduled-off dispatchable load and the three reserve totals, with the report's flag.

Native record
five-minute interval
five-minute publication cadence
Evidence
Observed market data
Published observations from the named source
Time basis
Point-in-time records
UTC · event_time

Overview

Observed only: no Ontario demand forecast is in the data, so a forecast peak or forecast demand cannot be answered from it.

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.
  • ontario_load is Ontario demand; market_total_load adds exports and dispatchable load and is a different quantity.

Access

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

Schema11

Column
Type
event_timeDateTime64(6, 'UTC')
total_energyNullable(Float64)
total_lossNullable(Float64)
market_total_loadNullable(Float64)
total_dispatchable_load_scheduled_offNullable(Float64)
total_10sNullable(Float64)
total_10nNullable(Float64)
total_30rNullable(Float64)
ontario_loadNullable(Float64)
flagNullable(String)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timetotal_energytotal_lossmarket_total_loadtotal_dispatchable_load_scheduled_offtotal_10stotal_10ntotal_30rontario_loadflagingested_at
2026-10-10 16:35:00.00000016169340.115828.9114.4236973.3208.714342.4DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:30:00.00000016285.9350.915934.9114.4236973.3208.714459.6DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:30:00.00000016285.9350.915934.9114.4236973.3208.714459.6DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:25:00.00000016242.2350.215892114.4236981.8200.214412.5DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:25:00.00000016242.2350.215892114.4236981.8200.214412.5DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:25:00.00000016242.2350.215892114.4236981.8200.214412.5DSO-RD2026-10-10 17:25:18.728056
2026-10-10 16:20:00.00000016309.3352.315957114.42361041.7140.314481.3DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:20:00.00000016309.3352.315957114.42361041.7140.314481.3DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:20:00.00000016309.3352.315957114.42361041.7140.314481.3DSO-RD2026-10-10 17:25:18.728056
2026-10-10 16:20:00.00000016309.3352.315957114.42361041.7140.314481.3DSO-RD2026-10-10 17:20:19.916946
2026-10-10 16:15:00.00000016383.9347.716036.2114.42361037.8144.214557.9DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:15:00.00000016383.9347.716036.2114.42361037.8144.214557.9DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:15:00.00000016383.9347.716036.2114.42361037.8144.214557.9DSO-RD2026-10-10 17:25:18.728056
2026-10-10 16:15:00.00000016383.9347.716036.2114.42361037.8144.214557.9DSO-RD2026-10-10 17:20:19.916946
2026-10-10 16:10:00.00000016265.4346.915918.6114.42361032.5149.514440.9DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:10:00.00000016265.4346.915918.6114.42361032.5149.514440.9DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:10:00.00000016265.4346.915918.6114.42361032.5149.514440.9DSO-RD2026-10-10 17:25:18.728056
2026-10-10 16:10:00.00000016265.4346.915918.6114.42361032.5149.514440.9DSO-RD2026-10-10 17:20:19.916946
2026-10-10 16:05:00.00000016210.1346.615863.6114.4236103514714391.1DSO-RD2026-10-10 17:35:17.017798
2026-10-10 16:05:00.00000016210.1346.615863.6114.4236103514714391.1DSO-RD2026-10-10 17:30:21.926768
2026-10-10 16:05:00.00000016210.1346.615863.6114.4236103514714391.1DSO-RD2026-10-10 17:25:18.728056
2026-10-10 16:05:00.00000016210.1346.615863.6114.4236103514714391.1DSO-RD2026-10-10 17:20:19.916946
2026-10-10 16:00:00.00000016140.5347.215793.2359.42361082.299.814424.2DSO-RD2026-10-10 17:00:23.192248
2026-10-10 15:55:00.00000016145.2349.115796.1323.92361057.2124.814529.3DSO-RD2026-10-10 17:00:23.192248
2026-10-10 15:50:00.00000016083.5348.315735.2399.42361043.2138.814462DSO-RD2026-10-10 17:00:23.192248

Coverage

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