Ancillary Service Market Clearing Prices

Cleared ancillary-service prices by SPP reserve zone for both the real-time balancing market and the day-ahead market.

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

Overview

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.

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

Access

Download: Query it in SQL, download it, or read it with an API key. Download data
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.SPP MCP API reference
HTTP endpoint: POST /api/v1/datasets/spp_as_prices/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

13 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`market_run`	`LowCardinality(String)`
`reserve_zone`	`LowCardinality(String)`
`reg_up_service`	`Nullable(Float64)`
`reg_dn_service`	`Nullable(Float64)`
`reg_up_mile`	`Nullable(Float64)`
`reg_dn_mile`	`Nullable(Float64)`
`ramp_up`	`Nullable(Float64)`
`ramp_dn`	`Nullable(Float64)`
`spin`	`Nullable(Float64)`
`supp`	`Nullable(Float64)`
`unc_up`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	market_run	reserve_zone	reg_up_service	reg_dn_service	reg_up_mile	reg_dn_mile	ramp_up	spin	supp	ingested_at
2026-11-05 05:00:00.000000	da_hourly	SWPW	7.3478	4.3506	∅	∅	4.9833	6.4836	5.7333	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	SPP	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	5	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	4	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	3	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	21	7.3478	4.3506	∅	∅	4.9833	6.4836	5.7333	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	2	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 05:00:00.000000	da_hourly	1	4.0411	0.4317	∅	∅	0	0.2603	0.096	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	SWPW	29.2866	28.5055	∅	∅	0.6917	28.6916	28.4416	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	SPP	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	5	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	4	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	3	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	21	29.2866	28.5055	∅	∅	0.6917	28.6916	28.4416	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	2	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 04:00:00.000000	da_hourly	1	8.0129	0.5946	∅	∅	0	1.8427	0.098	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	SWPW	10.5107	3.5847	∅	∅	8.9242	9.9241	6.75	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	SPP	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	5	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	4	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	3	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	21	10.5107	3.5847	∅	∅	8.9242	9.9241	6.75	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	2	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 03:00:00.000000	da_hourly	1	8.5808	0.9687	∅	∅	0	1.2405	0.668	2026-11-04 11:00:26.055744
2026-11-05 02:00:00.000000	da_hourly	SWPW	8.709	3.4081	∅	∅	6.805	7.805	6.75	2026-11-04 11:00:26.055744

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 4,633

Show coverage history

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

gaplessmore

Related data

Related ancillary services data
Dataset	Description
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.
East / West Capacity and ObligationSPP · source publication	Published East/West capacity and obligation snapshot, preserving LocalInterval as a source calendar label. event_time and published_at are file publication, not a converted local event clock. Source numeric units are not inferred from the bare Capacity and Obligation headers. Complete views require a matching receipt and mirrored row count; empty results are unknown coverage. Raw sources retain publication history internally.