Locational Marginal Prices by Bus

Real-time locational marginal prices at the individual electrical bus, with total LMP and its marginal energy, congestion, and loss components.

Prices data

Open in Data

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

Overview

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.

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

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

8 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`bus_name`	`LowCardinality(String)`
`market_run`	`LowCardinality(String)`
`lmp`	`Nullable(Float64)`
`mlc`	`Nullable(Float64)`
`mcc`	`Nullable(Float64)`
`mec`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	bus_name	market_run	lmp	mlc	mcc	mec	ingested_at
2026-11-04 00:20:00.000000	WRZOO_WRLDTX_2	rt_5min	20.2321	-1.4057	-0.3773	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRZOO_WRLDTX_1	rt_5min	20.2321	-1.4057	-0.3773	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRZOOKLD2	rt_5min	19.7119	-1.8046	-0.4986	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRYOSTLD4	rt_5min	20.3108	-1.2983	-0.406	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRW_PLAINGUNCOWP_GEN2	rt_5min	22.554	0.4999	0.039	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRW_PLAINGUNCOWP_GEN1	rt_5min	22.554	0.4999	0.039	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRW_PLAINGLDCOWP_LD1	rt_5min	22.554	0.4999	0.039	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWSTPRTLDWSTPRT2	rt_5min	19.5734	-1.9566	-0.4852	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWSTPRTLDWPRT2	rt_5min	19.5734	-1.9566	-0.4852	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWR_SMKHLUNWINDFARM_SPRM	rt_5min	19.5141	-2.0029	-0.4981	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWR_SMKHLUNWINDFARM_ENEL	rt_5min	19.5141	-2.0029	-0.4981	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWR_SMKHLUNSMOK1_ENEL	rt_5min	19.5141	-2.0029	-0.4981	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWR_SMKHLLDWINDFARM_AUX	rt_5min	19.5141	-2.0029	-0.4981	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWR_SMKHLLDWINDFARM2_AUX	rt_5min	19.5141	-2.0029	-0.4981	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRENUNV266_DDR_GEN	rt_5min	20.8365	-0.6673	-0.5114	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRENLDV266_DDR_LD	rt_5min	20.8365	-0.6673	-0.5114	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRENLDTX3	rt_5min	20.8365	-0.6673	-0.5114	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRENLD4	rt_5min	20.8365	-0.6673	-0.5114	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRENLD3	rt_5min	20.8365	-0.6673	-0.5114	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWRBATESVUNINDNHYDRO	rt_5min	22.713	0.5996	0.0983	22.0151	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWOLFUN15	rt_5min	20.6155	-1.0336	-0.3661	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWOLFLD31	rt_5min	20.6071	-1.042	-0.3661	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWOLFLD18	rt_5min	20.6026	-1.0521	-0.3605	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWMCPLD19	rt_5min	20.2521	-1.306	-0.4571	22.0152	2026-11-04 00:25:11.173824
2026-11-04 00:20:00.000000	WRWMBRLD2	rt_5min	20.2365	-1.3188	-0.4599	22.0152	2026-11-04 00:25:11.173824

Coverage

Showing the last 440 days of a 3,577-day history (Jan 1, 2017 → Oct 17, 2026). At 8.12B rows the table is too large to count day by day on every visit, so the figures below cover the window from Aug 4, 2025.

Complete: 99.8%
Gap days: 1
Days with data: 457

Show coverage history

Coverage: 99.8%Days with data: 457Gaps: 1

2026

2025

gaplessmore

Related 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 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.
Real-time market-clearing reportSPP · day publication	SPP's Real-time 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.