Overview

Cleared day-ahead ancillary-service capacity prices in SPP, one row per hour, reserve zone and product. 3,389,365 rows, 2017-01 to the next delivery day. Products: reg_up, reg_down, spin, supplemental, ramp_up, ramp_down, uncertainty_up. 8 SPP reserve zones. price_usd_mw is a price for CAPACITY held in reserve — dollars per megawatt of commitment — not dollars per megawatt-hour of energy delivered. The two are different units and are not comparable to an LMP.

SPP market Ask the agent about this dataset

Schema4

Column

Type

event_timeDateTime64(6, 'UTC')

regionLowCardinality(String)

productLowCardinality(String)

price_usd_mwNullable(Float64)

Sample rows

event_time	region	product	price_usd_mw
2026-08-28 04:00:00.000000	5	reg_up	4.5706
2026-08-28 04:00:00.000000	5	ramp_down	0
2026-08-28 04:00:00.000000	2	ramp_up	0
2026-08-28 04:00:00.000000	5	spin	0.775
2026-08-28 04:00:00.000000	4	spin	0.775
2026-08-28 04:00:00.000000	4	ramp_down	0
2026-08-28 04:00:00.000000	4	ramp_up	0
2026-08-28 04:00:00.000000	5	ramp_up	0
2026-08-28 04:00:00.000000	2	reg_down	0.6297
2026-08-28 04:00:00.000000	4	reg_down	0.6297
2026-08-28 04:00:00.000000	5	reg_down	0.6297
2026-08-28 04:00:00.000000	2	spin	0.775
2026-08-28 04:00:00.000000	2	ramp_down	0
2026-08-28 04:00:00.000000	2	reg_up	4.5706
2026-08-28 04:00:00.000000	4	reg_up	4.5706
2026-08-28 04:00:00.000000	2	supplemental	0.1
2026-08-28 04:00:00.000000	2	uncertainty_up	0
2026-08-28 04:00:00.000000	4	uncertainty_up	0
2026-08-28 04:00:00.000000	5	supplemental	0.1
2026-08-28 04:00:00.000000	5	uncertainty_up	0
2026-08-28 04:00:00.000000	4	supplemental	0.1
2026-08-28 04:00:00.000000	3	spin	0.775
2026-08-28 04:00:00.000000	21	spin	9.1151
2026-08-28 04:00:00.000000	1	spin	0.775
2026-08-28 04:00:00.000000	1	ramp_down	0

Coverage

100.0% complete0 gap days3,527 days with data

Show coverage history ▾

Coverage: 100.0%Days with data: 3,527Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

More data from SPP

Actual System LoadSPP's realized system-wide demand in MW at five-minute resolution, the actual-load counterpart to the short-term and mid-term load forecasts. 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.Ancillary Service Market Clearing PricesCleared ancillary-service prices by SPP reserve zone for both the real-time balancing market and the day-ahead market. SPP's product set does not map onto other ISOs': regulation clears as a separate service (capacity) price and mileage price in each direction (reg_up_service, reg_up_mile, reg_dn_service, reg_dn_mile), alongside ramp up and down, spinning, supplemental, and uncertainty products. IMPORTANT: reserve_zone mixes two grains. It carries the numeric ancillary reserve zones (1 through 5 under the SPP balancing authority, 21 under the separate SWPW balancing authority) AND the two balancing-authority roll-ups, 'SPP' and 'SWPW', whose prices equal those of their member zones. Aggregating across every value of reserve_zone double-counts the market.Cleared Operating ReservesCleared ancillary-service quantities in MW by SPP reserve zone: regulation up and down, ramp up and down, spinning, supplemental, and both uncertainty products (unc_up and the short-term sts_unc_up). The quantity counterpart to the ancillary clearing prices. The same reserve_zone caveat applies: the column carries both the numeric reserve zones and the 'SPP' and 'SWPW' balancing-authority roll-ups, so aggregating across every value double-counts.Day-Ahead Binding ConstraintsTransmission constraints binding in SPP's day-ahead market, published hourly for the delivery day with the constraint name, shadow price, direction, and the monitored limit and flow in MW. Pairs with the real-time binding-constraint table to compare which constraints the day-ahead market anticipated against those that actually bound in real time. As with the real-time table, no contingency or monitored-facility name is published.