SPP Day-Ahead Ancillary Prices

Cleared day-ahead ancillary-service capacity prices in SPP, one row per hour, reserve zone and product.

Ancillary Services data SPP market

Query with the agent

Native record

product x region x delivery hour

hourly (day-ahead) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Interval-start records

UTC · event_time

Overview

Inspect the current measured time coverage. 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.

Query contract

Select one product and one region before aggregating. Each row is already the canonical cleared price for that combination.

Analysis rules

Never sum prices across products. Reserve products are separately procured markets and their prices do not add to a meaningful total.
Never sum or average across reserve zones without saying so; 8 spp reserve zones.

Interpretation

price_usd_mw is $/MW of capacity held, not $/MWh of energy. Do not compare it directly to an LMP, and do not multiply it by megawatt-hours.
A cleared price is what the day-ahead market settled at. It is not the quantity procured, not a scarcity measurement, and not evidence that reserves were short.

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

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema4

Column

Type

event_timeDateTime64(6, 'UTC')

regionLowCardinality(String)

productLowCardinality(String)

price_usd_mwNullable(Float64)

Sample data

event_time	region	product	price_usd_mw
2026-10-12 04:00:00.000000	5	reg_down	7.868
2026-10-12 04:00:00.000000	5	ramp_down	0
2026-10-12 04:00:00.000000	5	ramp_up	0
2026-10-12 04:00:00.000000	1	ramp_up	0
2026-10-12 04:00:00.000000	1	ramp_down	0
2026-10-12 04:00:00.000000	4	reg_up	8.7248
2026-10-12 04:00:00.000000	4	spin	1
2026-10-12 04:00:00.000000	1	reg_up	8.7248
2026-10-12 04:00:00.000000	4	ramp_down	0
2026-10-12 04:00:00.000000	5	spin	1
2026-10-12 04:00:00.000000	5	reg_up	8.7248
2026-10-12 04:00:00.000000	4	reg_down	7.868
2026-10-12 04:00:00.000000	4	ramp_up	0
2026-10-12 04:00:00.000000	5	uncertainty_up	0
2026-10-12 04:00:00.000000	4	uncertainty_up	0
2026-10-12 04:00:00.000000	5	supplemental	0.0101
2026-10-12 04:00:00.000000	4	supplemental	0.0101
2026-10-12 04:00:00.000000	21	ramp_up	0
2026-10-12 04:00:00.000000	2	ramp_down	0
2026-10-12 04:00:00.000000	2	reg_down	7.868
2026-10-12 04:00:00.000000	21	reg_down	8.8359
2026-10-12 04:00:00.000000	21	ramp_down	0
2026-10-12 04:00:00.000000	1	reg_down	7.868
2026-10-12 04:00:00.000000	3	ramp_down	0
2026-10-12 04:00:00.000000	SWPW	ramp_up	0

Coverage

100.0% complete0 gap days4,609 days with data

Show coverage history

Coverage: 100.0%Days with data: 4,609Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

gaplessmore

Related ancillary services data

Related ancillary services data
Dataset	Description
Ancillary Service Market Clearing PricesSPP · 5-minute (RTBM) and hourly (Day-Ahead)	Cleared 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 ReservesSPP · 5-minute	Cleared 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.
DA and RUC Headroom / FloorroomSPP · source publication	Published day-ahead market and RUC headroom/floorroom by BAA and native GMT interval end. It is a cleared/outlook report, not proof of realized operating reserves. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.
East / West Area Control ErrorSPP · source publication	Published signed ACE MW by qualified GMT clock and filename-derived SPP/SWPW footprint. Overlapping rolling snapshots collapse to the newest complete publication per instant and BAA. History accumulates prospectively; annual archive formats are not covered here. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.