Ask the Grid
Create free workspace
IESO logo

IESO Constraint Shadow Prices (real-time)

Shadow prices of binding transmission constraints, by IESO's constraint id and name.

Congestion & Constraints dataIESO market
Query with the agent
Native record
constraint x 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

Shadow prices of binding transmission constraints, by IESO's constraint id and name.

Query contract

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

Schema5

Column
Type
event_timeDateTime64(6, 'UTC')
constraint_idLowCardinality(String)
constraint_nameNullable(String)
shadow_priceNullable(Float64)
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeconstraint_idconstraint_nameshadow_priceingested_at
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSO02026-10-10 17:35:26.301238
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 04:00:00.000000BASE CASE 0 NW.T2.MMWmBASE CASE 0 NW.T2.MMWm02026-10-10 17:35:26.301238
2026-10-05 04:00:00.000000BASE CASE 0 NW.T1.MMWmBASE CASE 0 NW.T1.MMWm02026-10-10 17:35:26.301238
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSO02026-10-10 17:30:29.564592
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSO02026-10-10 17:30:29.564592
2026-10-05 04:00:00.000000BASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSO02026-10-10 17:30:29.564592
2026-10-05 04:00:00.000000BASE CASE 0 NW.T2.MMWmBASE CASE 0 NW.T2.MMWm02026-10-10 17:30:29.564592
2026-10-05 04:00:00.000000BASE CASE 0 NW.T1.MMWmBASE CASE 0 NW.T1.MMWm02026-10-10 17:30:29.564592
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSO02026-10-10 17:35:26.301238
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 03:55:00.000000BASE CASE 0 NW.T2.MMWmBASE CASE 0 NW.T2.MMWm02026-10-10 17:35:26.301238
2026-10-05 03:55:00.000000BASE CASE 0 NW.T1.MMWmBASE CASE 0 NW.T1.MMWm02026-10-10 17:35:26.301238
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSO02026-10-10 17:30:29.564592
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSO02026-10-10 17:30:29.564592
2026-10-05 03:55:00.000000BASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSO02026-10-10 17:30:29.564592
2026-10-05 03:55:00.000000BASE CASE 0 NW.T2.MMWmBASE CASE 0 NW.T2.MMWm02026-10-10 17:30:29.564592
2026-10-05 03:55:00.000000BASE CASE 0 NW.T1.MMWmBASE CASE 0 NW.T1.MMWm02026-10-10 17:30:29.564592
2026-10-05 03:50:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 03:50:00.000000BASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSOBASE CASE 0 S-FETT.TAB6_N582L_24K.EQ3_DSO02026-10-10 17:35:26.301238
2026-10-05 03:50:00.000000BASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSOBASE CASE 0 S-FETT.TAB1_AIS_24K.EQ4_DSO02026-10-10 17:35:26.301238
2026-10-05 03:50:00.000000BASE CASE 0 NW.T2.MMWmBASE CASE 0 NW.T2.MMWm02026-10-10 17:35:26.301238
2026-10-05 03:50:00.000000BASE CASE 0 NW.T1.MMWmBASE CASE 0 NW.T1.MMWm02026-10-10 17:35:26.301238

Coverage

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