SPP · Ancillary
SPP real-time reserves cleared
The megawatts of each reserve product SPP's real-time market cleared, every five minutes, by reserve zone — the quantities beside SPP's reserve prices.
spp-rt-reserves-clearedevery 5 min · 5m rows8 entitiesWhat is in it
- Updates
- every 5 min · 5m rows
- Entities
- 8 entities — 1, 4, 21…
- Source timezone
- US Central — every timestamp Dryos serves is UTC
- Coverage
- 14 September 2026 to now
- Rows held
- 7,448
- Primary key
- iso, zone, interval_start_utc
What it measures
Every value, its unit, and what the source means by it.
- Regulation upMW
Cleared regulation up.
reg_up_mw - Regulation downMW
Cleared regulation down.
reg_down_mw - SpinningMW
Cleared spinning reserve.
spin_mw - SupplementalMW
Cleared supplemental reserve.
supp_mw - Ramp upMW
Cleared ramp capability up.
ramp_up_mw - Ramp downMW
Cleared ramp capability down.
ramp_down_mw - Uncertainty upMW
Cleared uncertainty reserve up.
uncertainty_up_mw - STS uncertainty upMW
SPP's STSUncUP product; equal to uncertainty up on every row read.
sts_uncertainty_up_mw
Columns
Exactly what a request answers with, read from the API rather than written here.
| Column | Type | Description |
|---|---|---|
| interval_start_utcrequired | timestamp | Start of the interval, UTC. SPP stamps the interval's end.e.g. 2026-09-14T21:25:00Z |
| isorequired | string | Publishing ISO.e.g. SPP |
| zonerequired | string | Reserve zone as SPP names it: 1 to 5 in the RTO and SPP their total; 21 in RTO West and SWPW its total.e.g. 4 |
| reg_up_mwrequired | number | Cleared regulation up, MW.e.g. 249.796 |
| reg_down_mwrequired | number | Cleared regulation down, MW.e.g. 249.796 |
| ramp_up_mwrequired | number | Cleared ramp capability up, MW.e.g. 249.796 |
| ramp_down_mwrequired | number | Cleared ramp capability down, MW.e.g. 249.796 |
| uncertainty_up_mwrequired | number | Cleared uncertainty reserve up, MW.e.g. 249.796 |
| sts_uncertainty_up_mwrequired | number | Cleared SPP's STSUncUP product (equal to uncertainty up on every row), MW.e.g. 249.796 |
| spin_mwrequired | number | Cleared spinning reserve, MW.e.g. 249.796 |
| supp_mwrequired | number | Cleared supplemental reserve, MW.e.g. 249.796 |
| source_published_at_utc | timestamp | When SPP published the row. |
| collected_at_utcrequired | timestamp | When Dryos collected this row, UTC. Stamped by the platform, not the collector.e.g. 2026-09-14T21:30:40Z |
Read it
Public, read-only, no key and no sign-up. Relative times stay relative, so a URL keeps working.
The newest rows
curl "https://api.dryos.ai/v1/datasets/spp-rt-reserves-cleared/query?node=1&limit=12"The catalogue entry — every column, its type and the source
curl "https://api.dryos.ai/v1/datasets/spp-rt-reserves-cleared"Hourly averages for the last day
curl "https://api.dryos.ai/v1/datasets/spp-rt-reserves-cleared/query?node=1&start=-24h&interval=1h&agg=avg"Full parameters — bucketing, aggregation, filters and search — are on the API reference.
Ask an agent
The same stream through the Model Context Protocol, so Claude, ChatGPT, Cursor or any MCP client can query it directly.
claude mcp add --transport http dryos https://api.dryos.ai/mcpThen ask:
What has Regulation up been at 1 over the last 24 hours, and when did it peak?
Setup for every client is on the MCP server page.
Changes to this collector
A change in the collector is a change in the data. Anyone reading a step in a series is owed the day it moved under them.
- 2026-09-14
First collected, from SPP's marketplace portal.
SPP's reserve prices were here without the quantities they cleared. Reconciled against the live files on 2026-09-14: every check passed.
How this stream is checked
- Pulled straight from SPP Marketplace Portal · Operating Reserves — no reseller in between — and compared against that file before it is served.
- Null means the source did not report it — never zero.
- A reading lands every 5 min; the interval timestamp is the start of the interval, in UTC.
- SPP publishes on US Central prevailing time, with a UTC column on every row. Every timestamp Dryos serves is UTC.
Related streams
- SPP real-time ancillary pricesSPP
Five-minute clearing prices for SPP's reserve products — regulation up and down and their mileage, spinning, supplemental, ramp capability and uncertainty reserve — in every reserve zone of the RTO and RTO West.
every 5 min · 5m rows8 entitiesspp-rt-as - SPP day-ahead ancillary pricesSPP
Hourly day-ahead clearing prices for SPP's reserve products — regulation up and down, spinning, supplemental, ramp capability and uncertainty reserve — in every reserve zone, posted for the whole of tomorrow each afternoon.
daily, afternoon CT · 1h rows8 entitiesspp-dam-as - SPP real-time LMPSPP
Real-time balancing market prices at every SPP settlement location — the trading hubs, load areas, resources, demand response and the interfaces with its neighbours — with the energy, congestion and loss components, every five minutes.
every 5 min · 5m rows1,612 entitiesspp-realtime-lmp - SPP day-ahead LMPSPP
Hourly day-ahead prices at every SPP settlement location — the trading hubs, load areas, resources, demand response and the interfaces with its neighbours — with the energy, congestion and loss components, posted for the whole of tomorrow each afternoon.
daily, afternoon CT · 1h rows1,612 entitiesspp-dam-lmp - SPP real-time bus LMPSPP
Real-time balancing market prices at every SPP electrical bus — about 9,250 of them, the western market included — with the energy, congestion and loss components, every five minutes.
every 5 min · 5m rows9,252 entitiesspp-rt-lmp-bus - SPP day-ahead bus LMPSPP
Hourly day-ahead prices at every SPP electrical bus, the western market included, with the energy, congestion and loss components, posted for the whole of tomorrow each afternoon.
daily, afternoon CT · 1h rows9,252 entitiesspp-dam-lmp-bus