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

Query with the agent

Native record

event_time

5-minute publication 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) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

SPP MCP API reference

HTTP endpoint

POST /api/v1/datasets/spp_load_actual_5m/query

Schema5

Column

Type

event_timeDateTime64(6, 'UTC')

baaLowCardinality(String)

actual_mwNullable(Float64)

gmt_intervalNullable(String)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	baa	actual_mw	gmt_interval	ingested_at
2026-09-19 20:55:00.000000	SWPW	3012	09/19/2026 20:55:00	2026-09-19 21:03:51.821921
2026-09-19 20:55:00.000000	SPP	47755	09/19/2026 20:55:00	2026-09-19 21:03:51.821921
2026-09-19 20:50:00.000000	SWPW	3006	09/19/2026 20:50:00	2026-09-19 21:03:51.821921
2026-09-19 20:50:00.000000	SPP	47689	09/19/2026 20:50:00	2026-09-19 21:03:51.821921
2026-09-19 20:45:00.000000	SWPW	3001	09/19/2026 20:45:00	2026-09-19 21:03:51.821921
2026-09-19 20:45:00.000000	SPP	47669	09/19/2026 20:45:00	2026-09-19 21:03:51.821921
2026-09-19 20:40:00.000000	SWPW	2990	09/19/2026 20:40:00	2026-09-19 21:03:51.821921
2026-09-19 20:40:00.000000	SPP	47657	09/19/2026 20:40:00	2026-09-19 21:03:51.821921
2026-09-19 20:35:00.000000	SWPW	2975	09/19/2026 20:35:00	2026-09-19 21:03:51.821921
2026-09-19 20:35:00.000000	SPP	47623	09/19/2026 20:35:00	2026-09-19 21:03:51.821921
2026-09-19 20:30:00.000000	SWPW	2983	09/19/2026 20:30:00	2026-09-19 21:03:51.821921
2026-09-19 20:30:00.000000	SPP	47488	09/19/2026 20:30:00	2026-09-19 21:03:51.821921
2026-09-19 20:25:00.000000	SWPW	2966	09/19/2026 20:25:00	2026-09-19 21:03:51.821921
2026-09-19 20:25:00.000000	SPP	47394	09/19/2026 20:25:00	2026-09-19 21:03:51.821921
2026-09-19 20:20:00.000000	SWPW	2963	09/19/2026 20:20:00	2026-09-19 21:03:51.821921
2026-09-19 20:20:00.000000	SPP	47251	09/19/2026 20:20:00	2026-09-19 21:03:51.821921
2026-09-19 20:15:00.000000	SWPW	2955	09/19/2026 20:15:00	2026-09-19 21:03:51.821921
2026-09-19 20:15:00.000000	SPP	47198	09/19/2026 20:15:00	2026-09-19 21:03:51.821921
2026-09-19 20:10:00.000000	SWPW	2952	09/19/2026 20:10:00	2026-09-19 21:03:51.821921
2026-09-19 20:10:00.000000	SPP	47084	09/19/2026 20:10:00	2026-09-19 21:03:51.821921
2026-09-19 20:05:00.000000	SWPW	2945	09/19/2026 20:05:00	2026-09-19 21:03:51.821921
2026-09-19 20:05:00.000000	SPP	46995	09/19/2026 20:05:00	2026-09-19 21:03:51.821921
2026-09-19 20:00:00.000000	SWPW	2941	09/19/2026 20:00:00	2026-09-19 21:03:51.821921
2026-09-19 20:00:00.000000	SPP	46892	09/19/2026 20:00:00	2026-09-19 21:03:51.821921
2026-09-19 19:55:00.000000	SWPW	2952	09/19/2026 19:55:00	2026-09-19 21:03:51.821921

Coverage

90.7% complete331 gap days3,218 days with data

Show coverage history

Coverage: 90.7%Days with data: 3,218Gaps: 331

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Related load 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 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, and forecast_mw. 535,105 rows since 2026-05-20, out to seven days ahead. The horizon column separates SPP's two published products: 'short_term' (STLF, 24,599 vintages, five-minute targets out a few hours) and 'mid_term' (MTLF, 2,188 vintages, 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'.
7-Day Load ForecastPJM · hourly (7-day horizon)	PJM's seven-day-ahead hourly load forecast by forecast area, refreshed through the day. Rows are keyed by target time (event_time) with the issue time in evaluated_at_utc; take the latest vintage per target hour via an argMax over evaluated_at_utc. Forecast areas match the very-short-term feed (utility names, RTO_COMBINED for the system total). This is the table for tomorrow's peak and the week-ahead demand outlook. Source: PJM Market Data.