Cleared Operating Reserves

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

Ancillary Services data SPP market

Open in Data Ask the agent

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

Overview

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.

Query contract: Preserve one canonical row per (event_time, reserve_zone) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time, 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_operating_reserves/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

11 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`reserve_zone`	`LowCardinality(String)`
`reg_up_cleared`	`Nullable(Float64)`
`reg_dn_cleared`	`Nullable(Float64)`
`ramp_up_cleared`	`Nullable(Float64)`
`ramp_dn_cleared`	`Nullable(Float64)`
`unc_up_cleared`	`Nullable(Float64)`
`sts_unc_up_cleared`	`Nullable(Float64)`
`spin_cleared`	`Nullable(Float64)`
`supp_cleared`	`Nullable(Float64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Sample data

event_time	reserve_zone	reg_up_cleared	reg_dn_cleared	ramp_up_cleared	ramp_dn_cleared	unc_up_cleared	sts_unc_up_cleared	spin_cleared	supp_cleared	ingested_at
2026-11-04 12:35:00.000000	SWPW	84	75	90.5	40	341.999	341.999	62.4	62.4	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	SPP	475.001	354	1206.263	200	2156.398	2156.398	685.501	685.502	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	5	51.422	117	241.5	34	418.2	418.2	60.1	166.5	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	4	267.882	64.19	876.463	40	1614.608	1614.608	443.9	150.535	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	3	80	131.81	36.156	61.844	60	60	58	13.867	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	21	84	75	90.5	40	341.999	341.999	62.4	62.4	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	2	74.697	40	32.183	58.5	44.19	44.19	99.801	85.6	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	1	1	1	19.961	5.656	19.4	19.4	23.7	269	2026-11-04 12:37:20.106348
2026-11-04 12:35:00.000000	SWPW	84	75	90.5	40	341.999	341.999	62.4	62.4	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	SPP	475.001	354	1206.263	200	2156.398	2156.398	685.501	685.502	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	5	51.422	117	241.5	34	418.2	418.2	60.1	166.5	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	4	267.882	64.19	876.463	40	1614.608	1614.608	443.9	150.535	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	3	80	131.81	36.156	61.844	60	60	58	13.867	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	21	84	75	90.5	40	341.999	341.999	62.4	62.4	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	2	74.697	40	32.183	58.5	44.19	44.19	99.801	85.6	2026-11-04 12:37:17.821873
2026-11-04 12:35:00.000000	1	1	1	19.961	5.656	19.4	19.4	23.7	269	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	SWPW	84	75	90.5	40	342	342	62.4	62.4	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	SPP	475	354	1149.301	200	2156.401	2156.401	685.499	685.502	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	5	45	117	256.5	135.9	443.7	443.7	60.1	166.5	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	4	274.694	64.12	759.454	36.3	1577.186	1577.186	455.624	150.535	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	3	80	131.88	36	0	60	60	55.942	13.867	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	21	84	75	90.5	40	342	342	62.4	62.4	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	2	74.306	40	30	0	56.115	56.115	89.533	85.6	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	1	1	1	67.347	27.8	19.4	19.4	24.3	269	2026-11-04 12:37:17.821873
2026-11-04 12:30:00.000000	SWPW	84	75	90.5	40	342	342	62.4	62.4	2026-11-04 12:32:19.413871

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 3,595

Show coverage history

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Related 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.
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.