Day-Ahead Ancillary Service Prices

NYISO day-ahead ancillary-service prices by pricing location, keyed by PTID, with separate columns for 10-minute spinning reserve, 10-minute non-synchronous reserve, 30-minute operating reserve, and regulation capacity.

Ancillary Services data

Download data

Native record

event_time x ptid

hourly (DAM) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Point-in-time records

UTC · event_time

Overview

These prices show the reserve and regulation stack cleared before the operating day, complementing day-ahead energy LBMP for full market-context analysis.

Query contract

Preserve one canonical row per (event_time, ptid) before aggregating.

Analysis rules

Group only after preserving the declared grain: event_time, ptid.

Schema9

Column

Type

event_timeDateTime64(6, 'UTC')

time_zoneNullable(String)

zone_nameNullable(String)

ptidInt64

spin_10_priceNullable(Float64)

nonsync_10_priceNullable(Float64)

operating_30_priceNullable(Float64)

regulation_capacity_priceNullable(Float64)

ingested_atDateTime64(6, 'UTC')

Sample data

event_time	time_zone	zone_name	ptid	spin_10_price	nonsync_10_price	operating_30_price	regulation_capacity_price	ingested_at
2026-10-02 03:00:00.000000	EDT	LONGIL	61762	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	N.Y.C.	61761	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	DUNWOD	61760	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	MILLWD	61759	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	HUD VL	61758	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	CAPITL	61757	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	MHK VL	61756	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	NORTH	61755	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	CENTRL	61754	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	GENESE	61753	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	WEST	61752	5.23	5.23	5.23	11.45	2026-10-01 14:30:35.316086
2026-10-02 03:00:00.000000	EDT	LONGIL	61762	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	N.Y.C.	61761	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	DUNWOD	61760	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	MILLWD	61759	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	HUD VL	61758	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	CAPITL	61757	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	MHK VL	61756	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	NORTH	61755	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	CENTRL	61754	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	GENESE	61753	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 03:00:00.000000	EDT	WEST	61752	5.23	5.23	5.23	11.45	2026-10-01 13:30:35.949483
2026-10-02 02:00:00.000000	EDT	LONGIL	61762	5.98	5.98	5.98	11.98	2026-10-01 14:30:35.316086
2026-10-02 02:00:00.000000	EDT	N.Y.C.	61761	5.98	5.98	5.98	11.98	2026-10-01 14:30:35.316086
2026-10-02 02:00:00.000000	EDT	DUNWOD	61760	5.98	5.98	5.98	11.98	2026-10-01 14:30:35.316086

Coverage

100.0% complete0 gap days9,816 days with data

Show coverage history

Coverage: 100.0%Days with data: 9,816Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

gaplessmore

Related ancillary services data

Related ancillary services data
Dataset	Description
NYISO Day-Ahead Ancillary PricesNYISO · hourly (day-ahead)	Cleared day-ahead ancillary-service capacity prices in NYISO, one row per hour, zone and product. 3,918,376 rows, 2016-06 to the next delivery day. Products: spin, non_spin, operating_30, reg_capacity. 11 NYISO zones. price_usd_mw is a price for CAPACITY held in reserve — dollars per megawatt of commitment — not dollars per megawatt-hour of energy delivered. The two are different units and are not comparable to an LMP.
Real-Time Ancillary Service PricesNYISO · 5-minute	NYISO real-time ancillary-service prices by pricing location, keyed by PTID, with separate columns for 10-minute spinning reserve, 10-minute non-synchronous reserve, 30-minute operating reserve, regulation capacity, and regulation movement. Use this with energy LBMP when analyzing reserve scarcity, regulation value, or storage/operator behavior beyond energy-only dispatch.
Ancillary Service Market Clearing PricesSPP · 5-minute (RTBM) and hourly (Day-Ahead)	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.
Ancillary Service PricesERCOT · hourly (DAM)	Hourly market clearing prices for the ancillary services ERCOT procures alongside energy in its Day-Ahead Market, broken out by product: Regulation Up (RegUp), Regulation Down (RegDown), Responsive Reserve (RRS), Non-Spinning Reserve (NSPIN), and the ERCOT Contingency Reserve Service (ECRS). These prices represent what the grid pays per megawatt to hold capacity in reserve for frequency control and contingency response, separate from the energy itself. Watching them shows when reserves are scarce and expensive (often during tight or volatile conditions), which informs how generators and storage operators allocate capacity between energy and reserve markets, and gives researchers a read on the cost of keeping the Texas grid reliable. ECRS, added in 2023, is the newest of these products and has at times cleared at notably high levels.