AESO Asset List

AESO's registry of market assets: asset code, name, pool participant, operating status and asset type (source, sink and others), including retired assets.

Infrastructure data AESO market

Query with the agent

Native record

asset x daily snapshot

daily snapshot publication cadence

Evidence

Reference data

Stable context used to interpret other datasets

Time basis

Point-in-time records

UTC · event_time

Overview

AESO's registry of market assets: asset code, name, pool participant, operating status and asset type (source, sink and others), including retired assets.

Query contract

Preserve one canonical row per (event_time, asset_id) before aggregating.

Analysis rules

Read the latest event_time; never sum across snapshots.

Interpretation

Includes retired and non-generating assets: filter operating_status and asset_type.

Access

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

Schema7

Column

Type

event_timeDateTime64(6, 'UTC')

asset_idLowCardinality(String)

asset_nameNullable(String)

pool_participant_idNullable(String)

operating_statusNullable(String)

asset_typeNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	asset_id	asset_name	pool_participant_id	operating_status	asset_type	ingested_at
2026-10-10 00:00:00.000000	YR1U	YR1U YREA SR#1	YREA	Retired	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	YNG1	YNG1 Youngstown Solar	PACE	Active	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO2E	XO2E XOEC Retail #11	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1X	XO1X XOEC Retail #3	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1W	XO1W XOEC Retail #8	XOEC	Retired	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1U	XO1U XOEC Retail #4	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1R	XO1R XOEC Retail #7	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1P	XO1P XOEC Retail #10	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1L	XO1L XOEC Retail #5	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1F	XO1F XOEC Retail #9	XOEC	Retired	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1E	XO1E XOEC Retail #2	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1C	XO1C XOEC Retail #6	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	XO1A	XO1A XOEC Retail #1	XOEC	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WWTP	WWTP CGP Wastewater	CGP	Retired	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WWD2	WWD2 Weldwood 30MW Steam Turb.	WFML	Retired	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WWD1	WWD1 Weldwood	MOHI	Active	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WWD-	WWD- WWDC FM Sell	WWDC	Retired	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WWD+	WWD+ WWDC FM Buy	WWDC	Retired	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WW1U	WW1U WWDC SR#1	WWDC	Retired	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WTX-	WTX- WTX FM Sell	WTX	Active	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WTX+	WTX+ WTX FM Buy	WTX	Active	SINK	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WTS	WTS UTH13916	VQW	Active	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WTRN	WTRN Waterton	TAC2	Active	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WST2	WST2 Westlock excess	DVPP	Retired	SOURCE	2026-10-10 08:00:53.378130
2026-10-10 00:00:00.000000	WST1	WST1 Westlock	DAPP	Active	SOURCE	2026-10-10 08:00:53.378130

Coverage

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

Related infrastructure data

Related infrastructure data
Dataset	Description
Alberta (AESO) Price LocationsAESO · slow-moving dimension, refreshed every 6 hours	Every Alberta (AESO) location that carries a price, as three columns: location_id, name, and kind. 1 rows — system (1). This is the dimension the Alberta (AESO) price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For Alberta, the one location_id is SYSTEM: the pool price (aeso.pool_price) and system marginal price (aeso.system_marginal_price) are system-wide and carry no location column. Alberta has no nodal, zonal or hub prices; do not look for one. Generating assets are identified by AESO asset code in aeso.unit_status and aeso.asset_list, not here. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
Advanced MetersEIA · annual (report year)	EIA-861 advanced metering: AMR, AMI and other meter counts, AMI energy served and customer access, by utility and customer class. Advanced_Meters, one row per utility, state, balancing authority and customer class. customer_class is residential, commercial, industrial, transportation (direct_connected in the distributed generation tables) or EIA's own total, so summing classes without excluding total counts everything twice. event_time is 1 January of the report year. release is final or early_release: EIA posts an early release of a year in August and replaces it with the final file in the autumn, and the mirror keeps the newest row per key. A key cell EIA leaves blank is '' or 0, and duplicate_index numbers rows that still share a key, in workbook order.
Baja California (CENACE) Price LocationsBCA · slow-moving dimension, refreshed every 6 hours	Every Baja California (CENACE) location that carries a price, as three columns: location_id, name, and kind. 4 rows — zone (4). This is the dimension the Baja California (CENACE) price, and where applicable constraint, tables join to, and it is the one place a location's type is decided: resolve "which hubs exist", "is this a zone or a node", or "give me the readable name for this id" here rather than inferring a type from a name prefix. For Baja California, location_id is CENACE's load zone (TIJUANA, MEXICALI, ENSENADA, SANLUIS) and joins cenace.zonal_prices.load_zone; name is the city it is named for. CENACE prices Baja California by load zone only; there are no nodes or hubs in this dimension. The same three columns exist for every market, so the equivalent question in another ISO is the same query against that ISO's table.
Baja Grid Footprint (OpenStreetMap)OpenStreetMap · weekly snapshot	The administrative boundaries that make up the Baja California control area's footprint: Baja California and San Luis Rio Colorado, Sonora.