MISO logo

Live Ancillary-Service Prices

Real-time and day-ahead ancillary-service clearing prices for each of MISO's eight reserve zones.

Native record
publisher snapshot x market run x reserve zone
1-minute snapshots publication cadence
Evidence
Mixed evidence
Multiple evidence types kept distinct in the contract
Time basis
Point-in-time records
UTC · event_time

Overview

Keep zone and product explicit; averaging reserve-zone prices would create a market-wide price MISO does not publish.

Query contract

Select one latest ref_id/ingested_at snapshot and filter market_run before comparing product prices by reserve zone.

Analysis rules

  • Keep all eight reserve zones explicit. Do not average zone prices into a market-wide price MISO does not publish.
  • Keep real-time and day-ahead market runs separate.

Access

Query from your own tools

Use the guarded HTTP endpoint directly, or connect an MCP client and load the dataset contract with describe_data before calling query_data.

HTTP endpoint
POST /api/v1/datasets/miso_live_ancillary_services/query

Schema17

Column
Type
event_timeDateTime64(6, 'UTC')
ref_idLowCardinality(String)
market_dayNullable(String)
market_runLowCardinality(String)
raw_intervalString
zoneLowCardinality(String)
generation_regulation_mcpNullable(Float64)
generation_spinning_mcpNullable(Float64)
generation_supplemental_mcpNullable(Float64)
short_term_reserve_mcpNullable(Float64)
demand_regulation_mcpNullable(Float64)
demand_spinning_mcpNullable(Float64)
demand_supplemental_mcpNullable(Float64)
ramp_up_mcpNullable(Float64)
ramp_down_mcpNullable(Float64)
raw_record_jsonString
ingested_atDateTime64(6, 'UTC')

Sample data

event_timeref_idmarket_daymarket_runraw_intervalzonegeneration_regulation_mcpgeneration_spinning_mcpgeneration_supplemental_mcpshort_term_reserve_mcpdemand_regulation_mcpdemand_spinning_mcpdemand_supplemental_mcpramp_up_mcpramp_down_mcpraw_record_jsoningested_at
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35617.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"6"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17123.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"1"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17223.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"2"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17323.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"3"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17423.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"4"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17523.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"5"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35817.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"8"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17723.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"7"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17823.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"8"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35117.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"1"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35217.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"2"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35317.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"3"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35417.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"4"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35517.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"5"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17623.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"6"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35717.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"7"}2026-09-27 21:41:08.978909
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17123.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"1"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17223.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"2"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17323.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"3"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17423.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"4"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17523.670.750.2523.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"0.25","number":"5"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17623.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"6"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17723.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"7"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026DayAheadMCP17823.670.754.923.670.7590{"DemandRegMcp":"23.60","DemandSpinMcp":"7.00","DemandSuppMcp":"0.75","GenRegMCP":"23.60","GenSpinMCP":"7.00","GenSuppMCP":"0.75","RcpDownMcp":"0.00","RcpUpMcp":"9.00","StrMcp":"4.90","number":"8"}2026-09-27 21:42:06.602640
2026-09-27 21:35:00.00000027-Sep-2026 - Interval 16:35 EST09-27-2026RealTimeMCP16:35117.410.20.1617.410.200{"DemandRegMcp":"17.40","DemandSpinMcp":"1.00","DemandSuppMcp":"0.20","GenRegMCP":"17.40","GenSpinMCP":"1.00","GenSuppMCP":"0.20","RcpDownMcp":"0.00","RcpUpMcp":"0.00","StrMcp":"0.16","number":"1"}2026-09-27 21:42:06.602640

Coverage

100.0% complete0 gap days47 days with data
Show coverage history
Coverage: 100.0%Days with data: 47Gaps: 0
2026
gaplessmore