Actual System Load

SPP's realized system-wide demand in MW at five-minute resolution, the actual-load counterpart to the short-term and mid-term load forecasts.

Load data SPP market

Open in Data Ask the agent

One row per: event_time x baa; 5-minute cadence
Evidence: Observed market data; Published observations from the named source
Time basis: Point-in-time records; UTC · event_time

Overview

Note that the feed republishes the same event_time on successive polls with a fresh ingested_at, so a read should collapse repeats on ingested_at before use.

Query contract: Preserve one canonical row per (event_time, baa) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, baa.

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.SPP MCP API reference
HTTP endpoint: POST /api/v1/datasets/spp_load_actual_5m/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

5 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`baa`	`LowCardinality(String)`
`actual_mw`	`Nullable(Float64)`
`gmt_interval`	`Nullable(String)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	baa	actual_mw	gmt_interval	ingested_at
2026-11-04 01:50:00.000000	SWPW	2994	11/04/2026 01:50:00	2026-11-04 01:53:55.792458
2026-11-04 01:50:00.000000	SPP	32427	11/04/2026 01:50:00	2026-11-04 01:53:55.792458
2026-11-04 01:45:00.000000	SWPW	2993	11/04/2026 01:45:00	2026-11-04 01:53:55.792458
2026-11-04 01:45:00.000000	SPP	32550	11/04/2026 01:45:00	2026-11-04 01:53:55.792458
2026-11-04 01:45:00.000000	SWPW	2993	11/04/2026 01:45:00	2026-11-04 01:48:46.521884
2026-11-04 01:45:00.000000	SPP	32550	11/04/2026 01:45:00	2026-11-04 01:48:46.521884
2026-11-04 01:40:00.000000	SWPW	2992	11/04/2026 01:40:00	2026-11-04 01:53:55.792458
2026-11-04 01:40:00.000000	SPP	32565	11/04/2026 01:40:00	2026-11-04 01:53:55.792458
2026-11-04 01:40:00.000000	SWPW	2992	11/04/2026 01:40:00	2026-11-04 01:48:46.521884
2026-11-04 01:40:00.000000	SPP	32565	11/04/2026 01:40:00	2026-11-04 01:48:46.521884
2026-11-04 01:35:00.000000	SWPW	2997	11/04/2026 01:35:00	2026-11-04 01:53:55.792458
2026-11-04 01:35:00.000000	SPP	32569	11/04/2026 01:35:00	2026-11-04 01:53:55.792458
2026-11-04 01:35:00.000000	SWPW	2997	11/04/2026 01:35:00	2026-11-04 01:48:46.521884
2026-11-04 01:35:00.000000	SPP	32569	11/04/2026 01:35:00	2026-11-04 01:48:46.521884
2026-11-04 01:30:00.000000	SWPW	3005	11/04/2026 01:30:00	2026-11-04 01:53:55.792458
2026-11-04 01:30:00.000000	SPP	32678	11/04/2026 01:30:00	2026-11-04 01:53:55.792458
2026-11-04 01:30:00.000000	SWPW	3005	11/04/2026 01:30:00	2026-11-04 01:48:46.521884
2026-11-04 01:30:00.000000	SPP	32678	11/04/2026 01:30:00	2026-11-04 01:48:46.521884
2026-11-04 01:25:00.000000	SWPW	3003	11/04/2026 01:25:00	2026-11-04 01:53:55.792458
2026-11-04 01:25:00.000000	SPP	32748	11/04/2026 01:25:00	2026-11-04 01:53:55.792458
2026-11-04 01:25:00.000000	SWPW	3003	11/04/2026 01:25:00	2026-11-04 01:48:46.521884
2026-11-04 01:25:00.000000	SPP	32748	11/04/2026 01:25:00	2026-11-04 01:48:46.521884
2026-11-04 01:20:00.000000	SWPW	3001	11/04/2026 01:20:00	2026-11-04 01:53:55.792458
2026-11-04 01:20:00.000000	SPP	32805	11/04/2026 01:20:00	2026-11-04 01:53:55.792458
2026-11-04 01:20:00.000000	SWPW	3001	11/04/2026 01:20:00	2026-11-04 01:48:46.521884

Coverage

Complete: 99.9%
Gap days: 2
Days with data: 3,593

Show coverage history

Coverage: 99.9%Days with data: 3,593Gaps: 2

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Related data

Related load data
Dataset	Description
Mid-Term Load Forecast (MTLF)SPP · Hourly, out ~7 days	SPP's mid-term load forecast in MW, running roughly seven days ahead, carried alongside the realized actual for the same interval so forecast error can be computed within the table. Bitemporal: each row records the delivery interval and the vintage the forecast was published at, retaining every successive forecast for a given hour.
Short-Term Load Forecast (STLF)SPP · 5-minute, frequent vintages	SPP's short-term load forecast in MW. Bitemporal: each row carries both the delivery interval (event_time) and the vintage the forecast was issued at (publish_time), so successive forecasts for the same interval are retained rather than overwritten. That makes the table usable for forecast-error and forecast-convergence analysis, not only for the latest view.
SPP Hourly Actual LoadSPP · hourly	Actual hourly electricity demand in SPP, one row per hour and balancing area: event_time, baa ('SPP' for the RTO East footprint, 'SWPW' for RTO West from 2026-04), system_mw and source. 140k rows, 2011-01 to now. Two feeds build it and `source` says which: 'zonal_hourly' rows (2011 to 2016, plus fallback hours later) are the sum of 17 load-zone columns (okge_mw, wfec_mw, wr_mw, waue_mw, les_mw, ede_mw, seci_mw, kacy_mw, mps_mw, csws_mw, sprm_mw, indn_mw, sps_mw, oppd_mw, kcpl_mw, nppd_mw, grda_mw); 'system_5m' rows (2017 on) average SPP's complete five-minute actuals and carry no zones.
SPP Load ForecastSPP · reissued per vintage; two products at different resolutions	SPP's demand forecast in long form: issued_at (when SPP published it), event_time (the hour or interval being forecast), horizon, baa (SPP East or SWPW West), and forecast_mw. History reaches 2017, with named East/West footprints available around the 2026 expansion; older blank BAA rows have unknown footprint. Targets run out to seven days ahead. The horizon column separates SPP's two published products: 'short_term' (STLF, five-minute targets) and 'mid_term' (MTLF, hourly targets out seven days). They are different forecasts at different resolutions and must never be mixed in one series. Issue time and target time are separate columns, so this table supports both 'what does SPP expect' and 'what did SPP expect N hours out'.