Ask the Grid

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

Column
Type
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_timemarket_runreserve_zonereg_up_servicereg_dn_servicereg_up_milereg_dn_mileramp_upramp_dnspinsuppunc_upingested_at
2026-08-05 19:20:00.000000rt_5minSWPW10.000510.00860.010.01006.54125.7502026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5minSPP11.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min511.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min411.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min311.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min2110.000510.00860.010.01006.54125.7502026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min211.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:20:00.000000rt_5min111.21250.6552.403.200303.20033.200302026-08-05 19:22:55.882598
2026-08-05 19:15:00.000000rt_5minSWPW10.000510.00050.010.01006.54125.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5minSPP7.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min57.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min47.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min37.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min2110.000510.00050.010.01006.54125.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min27.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:15:00.000000rt_5min17.38360.49345.882.40.600.750.7502026-08-05 19:17:55.607106
2026-08-05 19:10:00.000000rt_5minSWPW10.000510.00040.010.01006.54125.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5minSPP6.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min56.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min46.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min36.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min2110.000510.00040.010.01006.54125.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min26.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:10:00.000000rt_5min16.6010.65444.7600.7400.750.7502026-08-05 19:12:58.447985
2026-08-05 19:05:00.000000rt_5minSWPW10.000512.10380.010.01006.54125.7502026-08-05 19:07:54.983586

Coverage

100.0% complete0 gap days582 days with data
Show coverage history ▾
Coverage: 100.0%Days with data: 582Gaps: 0
2026
2025
gaplessmore