SPP · Ancillary
SPP real-time ancillary prices
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.
spp-rt-asevery 5 min · 5m rows8 entitiesWhat is in it
- Updates
- every 5 min · 5m rows
- Entities
- 8 entities — SPP, SWPW, 1…
- Source timezone
- US Central — every timestamp Dryos serves is UTC
- Coverage
- 14 September 2026 to now
- Rows held
- 7,520
- Primary key
- iso, zone, interval_start_utc
What it measures
Every value, its unit, and what the source means by it.
- Regulation up$/MW
Regulation up clearing price.
reg_up_mcp - Regulation down$/MW
Regulation down clearing price.
reg_down_mcp - Spinning$/MW
Spinning reserve clearing price.
spin_mcp - Supplemental$/MW
Supplemental (non-spinning) reserve clearing price.
supp_mcp - Ramp up$/MW
Ramp capability up clearing price. Often zero.
ramp_up_mcp - Ramp down$/MW
Ramp capability down clearing price. Often zero.
ramp_down_mcp - Uncertainty up$/MW
Uncertainty reserve up clearing price. Often zero.
uncertainty_up_mcp - Mileage up$/MW
Regulation mileage up price.
reg_mileage_up_mcp - Mileage down$/MW
Regulation mileage down price.
reg_mileage_down_mcp
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-14T20:10:00Z |
| isorequired | string | Publishing ISO.e.g. SPP |
| zonerequired | string | Reserve zone as SPP names it: 1 to 5 and SPP in the RTO, 21 and SWPW in RTO West. The zones of one market have priced alike in every interval read; SPP and SWPW read as each market's system-wide row.e.g. SPP |
| reg_up_mcprequired | number | Market clearing price for regulation up, $/MW.e.g. 2.0824 |
| reg_down_mcprequired | number | Market clearing price for regulation down, $/MW.e.g. 2.0824 |
| reg_mileage_up_mcp | number | Market clearing price for regulation mileage up, $/MW.e.g. 2.0824 |
| reg_mileage_down_mcp | number | Market clearing price for regulation mileage down, $/MW.e.g. 2.0824 |
| ramp_up_mcprequired | number | Market clearing price for ramp capability up, $/MW.e.g. 2.0824 |
| ramp_down_mcprequired | number | Market clearing price for ramp capability down, $/MW.e.g. 2.0824 |
| spin_mcprequired | number | Market clearing price for spinning reserve, $/MW.e.g. 2.0824 |
| supp_mcprequired | number | Market clearing price for supplemental reserve, $/MW.e.g. 2.0824 |
| uncertainty_up_mcprequired | number | Market clearing price for uncertainty reserve up, $/MW.e.g. 2.0824 |
| 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-14T20:16:30Z |
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-as/query?node=SPP&limit=12"The catalogue entry — every column, its type and the source
curl "https://api.dryos.ai/v1/datasets/spp-rt-as"Hourly averages for the last day
curl "https://api.dryos.ai/v1/datasets/spp-rt-as/query?node=SPP&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 SPP 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.
Every other operator's reserve prices were here and SPP's were not. Reconciled against the live files on 2026-09-14: every check passed, eight zones an interval, nine products each.
How this stream is checked
- Pulled straight from SPP Marketplace Portal · RTBM Market Clearing Prices — 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 reserves clearedSPP
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.
every 5 min · 5m rows8 entitiesspp-rt-reserves-cleared - 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 - CAISO real-time ancillary pricesCAISO
Fifteen-minute real-time clearing prices for regulation up and down, spinning and non-spinning reserve and regulation mileage, in CAISO's six ancillary service regions.
every 15 min · 15m rows6 entitiescaiso-rt-as - NYISO real-time ancillary pricesNYISO
Five-minute clearing prices for NYISO's reserves and regulation — ten-minute spinning and non-synchronous, thirty-minute operating, regulation capacity and movement — in each of its eleven zones.
every 5 min · 5m rows11 entitiesnyiso-rt-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