AESO Hourly Pool Price

Alberta's hourly pool price, the settlement price for energy, with the 30-day rolling average AESO publishes beside it.

Prices data AESO market

Query with the agent

Native record

hour

hourly, settled after the hour publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Interval-start records

UTC · event_time

Overview

Alberta's reference price for an hour.

Query contract

Preserve one canonical row per (event_time) before aggregating.

Analysis rules

The mirror keeps receipts: pick the latest non-null value per hour, argMaxIf(value, ingested_at, value IS NOT NULL). An hour still in progress has no value yet, which is not a missing hour.

Interpretation

event_time is the START of the hour (hour beginning), in UTC. Alberta civil time is America/Edmonton.
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.

Schema4

Column

Type

event_timeDateTime64(6, 'UTC')

pool_price_cadNullable(Float64)

rolling_30day_avgNullable(Float64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	pool_price_cad	rolling_30day_avg	ingested_at
2026-10-10 19:00:00.000000	∅	∅	2026-10-10 17:05:16.537336
2026-10-10 19:00:00.000000	∅	∅	2026-10-10 17:05:13.258244
2026-10-10 18:00:00.000000	∅	∅	2026-10-10 17:05:16.537336
2026-10-10 18:00:00.000000	∅	∅	2026-10-10 17:05:13.258244
2026-10-10 18:00:00.000000	∅	∅	2026-10-10 16:05:16.871141
2026-10-10 17:00:00.000000	∅	∅	2026-10-10 17:05:16.537336
2026-10-10 17:00:00.000000	∅	∅	2026-10-10 17:05:13.258244
2026-10-10 17:00:00.000000	∅	∅	2026-10-10 16:05:16.871141
2026-10-10 16:00:00.000000	∅	∅	2026-10-10 17:05:16.537336
2026-10-10 16:00:00.000000	∅	∅	2026-10-10 17:05:13.258244
2026-10-10 16:00:00.000000	∅	∅	2026-10-10 16:05:16.871141
2026-10-10 15:00:00.000000	14.4	39.2	2026-10-10 17:05:16.537336
2026-10-10 15:00:00.000000	14.4	39.2	2026-10-10 17:05:13.258244
2026-10-10 15:00:00.000000	∅	∅	2026-10-10 16:05:16.871141
2026-10-10 14:00:00.000000	12.03	39.2	2026-10-10 17:05:16.537336
2026-10-10 14:00:00.000000	12.03	39.2	2026-10-10 17:05:13.258244
2026-10-10 14:00:00.000000	12.03	39.2	2026-10-10 16:05:16.871141
2026-10-10 13:00:00.000000	11.13	39.2	2026-10-10 17:05:16.537336
2026-10-10 13:00:00.000000	11.13	39.2	2026-10-10 17:05:13.258244
2026-10-10 13:00:00.000000	11.13	39.2	2026-10-10 16:05:16.871141
2026-10-10 12:00:00.000000	10.82	39.19	2026-10-10 17:05:16.537336
2026-10-10 12:00:00.000000	10.82	39.19	2026-10-10 17:05:13.258244
2026-10-10 12:00:00.000000	10.82	39.19	2026-10-10 16:05:16.871141
2026-10-10 11:00:00.000000	11.81	39.18	2026-10-10 17:05:16.537336
2026-10-10 11:00:00.000000	11.81	39.18	2026-10-10 17:05:13.258244

Coverage

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

Related prices data

Related prices data
Dataset	Description
AESO Daily Average Pool PriceAESO · daily	AESO's daily average, on-peak and off-peak pool price for each Alberta day.
AESO Pool Price ForecastAESO · as AESO updates it; retrieved every 15 minutes	AESO's own forecast of the hourly pool price. A forecast, not a day-ahead market: Alberta clears no day-ahead energy market.
AESO System Marginal PriceAESO · each price change, restated every hour	Alberta's system marginal price: the price of the last energy block dispatched, with the volume at that price. A step series: each row holds from its event_time until the next row. Alberta has one system price; there are no nodal or zonal prices and no day-ahead market.
AMSISONE · ISO-NE source publication	ISO-NE's published AMS source feed. This catalog page exposes the physical schema, coverage, and latest source rows without inventing a normalized grain for publisher-shaped snapshot fields. Use the documented key and event time when comparing revisions or vintages.