SPP Real-Time Prices

SPP real-time locational marginal prices, one row per interval and location.

Prices data SPP market

Query with the agent

Native record

location x kind x 5-minute

5-minute publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Interval-start records

UTC · event_time

Overview

Check measured time coverage separately for settlement and bus prices. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are bus (10,457), node (1,983) and hub (2); location_id joins atg.spp_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's real-time price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.

Query contract

One row is already the canonical price for (event_time, location_id, kind) — the refresh collapsed the source's revisions. Select the interval and the locations you need; do not de-duplicate again.

Analysis rules

Prices are intensive. Averaging across intervals gives a simple (unweighted) average price, which is not a settlement or load-weighted price; say which one you computed. Never sum prices across intervals or locations.
Do not add price_usd_mwh to its own components — they decompose it, they do not extend it.

Related analysis

resolving a location's readable name and type · join on location_id, and on kind where both carry it
day-ahead versus real-time basis at one location · aggregate real-time intervals to the delivery hour before comparing with the hourly day-ahead price

Interpretation

Real-time history begins 2025-01-01, which is much shorter than SPP's day-ahead history (2017-01). A real-time-versus-day-ahead comparison is only possible over the overlap; say so rather than silently comparing different windows.
A price difference between two locations is a basis. It is evidence that they separated, not evidence of which facility bound; that needs the congestion component or the constraints table.

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_prices_rt/query

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')

location_idLowCardinality(String)

kindLowCardinality(String)

price_usd_mwhNullable(Float64)

energy_usd_mwhNullable(Float64)

congestion_usd_mwhNullable(Float64)

loss_usd_mwhNullable(Float64)

Sample data

event_time	location_id	kind	price_usd_mwh	energy_usd_mwh	loss_usd_mwh
2026-10-13 19:45:00.000000	WACMWINDYGAPLDMPE	bus	19.5348	19.3245	0.2103
2026-10-13 19:45:00.000000	WACMWINDTALKUNCROSNGTR_WIND	bus	19.2399	19.3244	-0.0845
2026-10-13 19:45:00.000000	WACMWINDTALKLDCROSS_TRAIL	bus	19.2399	19.3244	-0.0845
2026-10-13 19:45:00.000000	WACMWINDRIVRLDWINDRIVR	bus	19.2197	19.3244	-0.1047
2026-10-13 19:45:00.000000	WACMWILSONTSLDT1	bus	18.8648	19.3244	-0.4596
2026-10-13 19:45:00.000000	WACMWILSONTSLDHIDEOUT	bus	18.8648	19.3244	-0.4596
2026-10-13 19:45:00.000000	WACMWILLSCRKUNPIKE_SOLAR	bus	19.1153	19.3245	-0.2092
2026-10-13 19:45:00.000000	WACMWILLSCRKUNPALMERSOLAR	bus	19.1153	19.3245	-0.2092
2026-10-13 19:45:00.000000	WACMWILLSCRKLDPIKE_SOL_SS	bus	19.1153	19.3245	-0.2092
2026-10-13 19:45:00.000000	WACMWILLSCRKLDPALM_SOL_SS	bus	19.1153	19.3245	-0.2092
2026-10-13 19:45:00.000000	WACMWILFORKUNWILL_FORK	bus	19.5387	19.3244	0.2143
2026-10-13 19:45:00.000000	WACMWILFORKLDWILL_FORK_LD	bus	19.5387	19.3244	0.2143
2026-10-13 19:45:00.000000	WACMWILDCATLDWILDCAT_LAP	bus	19.3705	19.3244	0.0461
2026-10-13 19:45:00.000000	WACMWILDCATLDWILDCAT	bus	19.3705	19.3244	0.0461
2026-10-13 19:45:00.000000	WACMWILDCATLDMEAW_MORRIL	bus	19.3705	19.3244	0.0461
2026-10-13 19:45:00.000000	WACMWILDCATLDMEAN_MORRIL	bus	19.3705	19.3244	0.0461
2026-10-13 19:45:00.000000	WACMWIGGINSLDWIGGINS_LAP	bus	19.6602	19.3244	0.3358
2026-10-13 19:45:00.000000	WACMWIGGINSLDWIGGINS	bus	19.6602	19.3244	0.3358
2026-10-13 19:45:00.000000	WACMWGRANDVWLDT1	bus	18.4967	19.3244	-0.8277
2026-10-13 19:45:00.000000	WACMWHITNERDLDKODAK_3	bus	19.544	19.3244	0.2196
2026-10-13 19:45:00.000000	WACMWHITNERDLDKODAK_2_LAP	bus	19.544	19.3244	0.2196
2026-10-13 19:45:00.000000	WACMWHITNERDLDKODAK_2	bus	19.544	19.3244	0.2196
2026-10-13 19:45:00.000000	WACMWHITNERDLDKODAK_3_LAP	bus	19.544	19.3244	0.2196
2026-10-13 19:45:00.000000	WACMWHARRSBRLDWACM_TSPM	bus	19.3283	19.3244	0.0039
2026-10-13 19:45:00.000000	WACMWG_PUMPSLDNCWCD_SS	bus	19.5283	19.3244	0.2039

Coverage

Showing the last 357 days of a 651-day history (Jan 1, 2025 → Oct 13, 2026). This dataset holds 1.82B rows — too many to count day by day on every visit — so the calendar and the figures below cover the window from Oct 22, 2025.

100.0% complete0 gap days357 days with data

Show coverage history

Coverage: 100.0%Days with data: 357Gaps: 0

2026

2025

gaplessmore

Related prices data

Related prices data
Dataset	Description
Day-Ahead Bus LMPSPP · source publication	Cleared hourly day-ahead bus prices and MEC/MCC/MLC components, preserving BAA and the native GMT interval end. The DA bus archive exists separately from settlement-location LMP. A component does not identify the causing constraint. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
Day-ahead market-clearing reportSPP · day publication	SPP's Day-ahead market-clearing report. Each row preserves a publisher record, workbook row, or report document with its source member and row index. Source timestamps, units, geographic scope, and revision qualifiers are retained in record_json; event_time is collection time; completed_at is when the entire document became available.
Locational Marginal Prices by BusSPP · 5-minute (RTBM)	Real-time locational marginal prices at the individual electrical bus, with total LMP and its marginal energy, congestion, and loss components. This is SPP's finest-grained public price view, well below the settlement-location tier, and is the table to use when a question concerns a specific bus rather than a settlement point. Real-time only: SPP publishes no day-ahead equivalent at bus granularity on this feed.
Locational Marginal Prices by Settlement LocationSPP · 5-minute (RTBM) and hourly (Day-Ahead)	Locational marginal prices for SPP settlement locations, carrying total LMP and its marginal energy (mec), congestion (mcc), and loss (mlc) components. Covers both the five-minute real-time balancing market and the hourly day-ahead market, distinguished by market_run ('rt_5min' and 'da_hourly'). Around 1,600 settlement locations report on the live feed. Note that location_name and location_type are published empty on this feed, so a location cannot be classified as hub, generator, or interface from this table alone. SPP's two market trading hubs are SPPNORTH_HUB and SPPSOUTH_HUB; other identifiers containing 'HUB' are participant settlement aggregates, not market hubs.