IESO Intertie Prices

LMPs at Ontario's intertie zones with neighbouring markets.

Prices data IESO market

Query with the agent

Native record

market run x intertie 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

LMPs at Ontario's intertie zones with neighbouring markets.

Query contract

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

intertie_nameLowCardinality(String)

lmpNullable(Float64)

congestionNullable(Float64)

lossNullable(Float64)

publish_timeNullable(DateTime64(6, 'UTC'))

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	market_run	intertie_name	lmp	congestion	loss	publish_time	ingested_at
2026-10-12 04:00:00.000000	da_hourly	WC.PRAIRERANGES_MISI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.RAPIDDESISLE_PQDZ:LMP	44.53	∅	2.05	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.QUYON_PQQC:LMP	42.48	∅	∅	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.PAUGAN_PQPC:LMP	43.84	∅	1.36	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.OUTAOUAIS_PQAT:LMP	45	∅	2.52	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.MASSON_PQHA:LMP	44.34	∅	1.86	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.MACLAREN_PQDA:LMP	43.75	∅	1.27	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.KIPAWA_PQHZ:LMP	44.67	∅	2.19	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.BRYSON_PQXY:LMP	43.48	∅	1	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	PQ.BEAUHARNOIS_PQBE:LMP	42.23	∅	-0.25	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	NY.ROSETON_NYSI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MN.INTFALLS_MNSI:LMP	42.06	∅	-0.42	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MI.LUDINGTON_MISI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MD.CALVERTCLIFF_NYSI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MD.CALVERTCLIFF_MISI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MB.WHITESHELL_MBSI:LMP	41.44	∅	-1.04	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	MB.SEVENSISTERS_MBSK:LMP	41.44	∅	-1.04	∅	2026-10-10 17:35:10.380034
2026-10-12 04:00:00.000000	da_hourly	EC.MARITIMES_NYSI:LMP	41.08	∅	-1.4	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	WC.PRAIRERANGES_MISI:LMP	49.1	∅	-2.55	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.RAPIDDESISLE_PQDZ:LMP	54.43	∅	2.78	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.QUYON_PQQC:LMP	51.65	∅	∅	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.PAUGAN_PQPC:LMP	53.2	∅	1.54	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.OUTAOUAIS_PQAT:LMP	54.32	∅	2.66	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.MASSON_PQHA:LMP	53.75	∅	2.1	∅	2026-10-10 17:35:10.380034
2026-10-12 03:00:00.000000	da_hourly	PQ.MACLAREN_PQDA:LMP	52.98	∅	1.32	∅	2026-10-10 17:35:10.380034

Coverage

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

Related prices data

Related prices data
Dataset	Description
IESO HOEP (pre-2025 market)IESO · hourly, ended 2025-04-30	The Hourly Ontario Energy Price and its pre-dispatch projections, with the old market's operating-reserve prices, from 2002 to the market renewal on 2025-05-01.
IESO Nodal LMPsIESO · five-minute real-time; hourly day-ahead and pre-dispatch	Locational marginal prices at every IESO pricing location in each market run, with loss and congestion components. About a thousand locations; none has a verified map position here.
IESO Ontario Zonal PriceIESO · five-minute real-time; hourly day-ahead and pre-dispatch	The Ontario zonal price, the load-weighted price Ontario's non-dispatchable load pays, in each market run, with loss and congestion components. Ontario's reference price.
IESO Virtual Zone PricesIESO · five-minute real-time; hourly day-ahead	Prices in IESO's virtual transaction zones, where virtual bids and offers settle.