Overview
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.
Schema13
event_timeDateTime64(6, 'UTC')market_runLowCardinality(String)reserve_zoneLowCardinality(String)reg_up_serviceNullable(Float64)reg_dn_serviceNullable(Float64)reg_up_mileNullable(Float64)reg_dn_mileNullable(Float64)ramp_upNullable(Float64)ramp_dnNullable(Float64)spinNullable(Float64)suppNullable(Float64)unc_upNullable(Float64)ingested_atDateTime64(6, 'UTC')Sample rows
| event_time | market_run | reserve_zone | reg_up_service | reg_dn_service | reg_up_mile | reg_dn_mile | ramp_up | ramp_dn | spin | supp | unc_up | ingested_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-08-05 19:20:00.000000 | rt_5min | SWPW | 10.0005 | 10.0086 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | SPP | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 5 | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 4 | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 3 | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 21 | 10.0005 | 10.0086 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 2 | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:20:00.000000 | rt_5min | 1 | 11.2125 | 0.655 | 2.4 | 0 | 3.2003 | 0 | 3.2003 | 3.2003 | 0 | 2026-08-05 19:22:55.882598 |
| 2026-08-05 19:15:00.000000 | rt_5min | SWPW | 10.0005 | 10.0005 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | SPP | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 5 | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 4 | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 3 | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 21 | 10.0005 | 10.0005 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 2 | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:15:00.000000 | rt_5min | 1 | 7.3836 | 0.4934 | 5.88 | 2.4 | 0.6 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:17:55.607106 |
| 2026-08-05 19:10:00.000000 | rt_5min | SWPW | 10.0005 | 10.0004 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | SPP | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 5 | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 4 | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 3 | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 21 | 10.0005 | 10.0004 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 2 | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:10:00.000000 | rt_5min | 1 | 6.601 | 0.6544 | 4.76 | 0 | 0.74 | 0 | 0.75 | 0.75 | 0 | 2026-08-05 19:12:58.447985 |
| 2026-08-05 19:05:00.000000 | rt_5min | SWPW | 10.0005 | 12.1038 | 0.01 | 0.01 | 0 | 0 | 6.5412 | 5.75 | 0 | 2026-08-05 19:07:54.983586 |