NYISO Day-Ahead Prices

NYISO day-ahead locational marginal prices, one row per interval and location.

Prices data NYISO market

Query with the agent

Native record

location x kind x delivery hour

hourly publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

Time basis

Interval-start records

UTC · event_time

Overview

63.4M rows, 2015-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh, congestion_usd_mwh and loss_usd_mwh. Locations are zone (the 11 load zones plus four external proxy buses) and generator; location_id joins atg.nyiso_locations for the readable name, and kind is carried inline so a hub-only or zone-only question needs no join at all. Every market's day-ahead price table in this catalog has these same column names, so a cross-market price comparison is a UNION rather than a per-ISO rewrite. Revisions are already collapsed — read it plainly.

Query contract

One row is already the canonical price for (event_time, location_id, kind) — the refresh collapsed the source's revisions. Select the interval and the locations you need; do not de-duplicate again. Day-ahead rows for the next delivery day are published in a single late-evening batch, so max(event_time) runs ahead of the wall clock by design.

Analysis rules

Prices are intensive. Averaging across intervals gives a simple (unweighted) average price, which is not a settlement or load-weighted price; say which one you computed. Never sum prices across intervals or locations.
Do not add price_usd_mwh to its own components — they decompose it, they do not extend it.

Related analysis

resolving a location's readable name and type · join on location_id, and on kind where both carry it
day-ahead versus real-time basis at one location · aggregate the real-time intervals in the delivery hour before comparing

Interpretation

kind = 'zone' holds the 11 NYISO load zones AND the four external proxy buses (H Q, NPX, O H, PJM), which are interface reference prices. For any 'which zone' question, restrict to the registered 'NYISO load zones' entity set first; a proxy bus is never the zone with the largest spread, price, or anything else.
NYISO posts the next day's day-ahead prices late morning Eastern time, around 11 AM ET the day before delivery; they typically become available here by mid-afternoon. Earlier in the day, the next day's prices are not out yet.

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.

NYISO MCP API reference

HTTP endpoint

POST /api/v1/datasets/nyiso_prices_da/query

Need the full history of this dataset in Snowflake, Databricks or your own storage? Data services delivers it on a schedule.

Schema7

Column

Type

event_timeDateTime64(6, 'UTC')

location_idLowCardinality(String)

kindLowCardinality(String)

price_usd_mwhNullable(Float64)

energy_usd_mwhNullable(Float64)

congestion_usd_mwhNullable(Float64)

loss_usd_mwhNullable(Float64)

Sample data

event_time	location_id	kind	price_usd_mwh	energy_usd_mwh	loss_usd_mwh
2026-10-13 03:00:00.000000	23516	generator	44.57	42.85	1.72
2026-10-13 03:00:00.000000	23556	generator	41.56	42.85	-1.29
2026-10-13 03:00:00.000000	23531	generator	44.14	42.85	1.29
2026-10-13 03:00:00.000000	23555	generator	44.73	42.849999999999994	1.88
2026-10-13 03:00:00.000000	23553	generator	44.52	42.85	1.67
2026-10-13 03:00:00.000000	23552	generator	44.61	42.85	1.76
2026-10-13 03:00:00.000000	23551	generator	44.61	42.85	1.76
2026-10-13 03:00:00.000000	23550	generator	44.91	42.849999999999994	2.06
2026-10-13 03:00:00.000000	23587	generator	43.96	42.85	1.11
2026-10-13 03:00:00.000000	23517	generator	44.56	42.85	1.71
2026-10-13 03:00:00.000000	23549	generator	41.56	42.85	-1.29
2026-10-13 03:00:00.000000	23548	generator	45.42	42.85	2.57
2026-10-13 03:00:00.000000	23547	generator	44.01	42.85	1.16
2026-10-13 03:00:00.000000	23588	generator	43.96	42.85	1.11
2026-10-13 03:00:00.000000	23586	generator	44.44	42.849999999999994	1.59
2026-10-13 03:00:00.000000	23546	generator	44.73	42.849999999999994	1.88
2026-10-13 03:00:00.000000	23519	generator	44.61	42.85	1.76
2026-10-13 03:00:00.000000	23545	generator	44.73	42.849999999999994	1.88
2026-10-13 03:00:00.000000	23533	generator	44.65	42.85	1.8
2026-10-13 03:00:00.000000	23534	generator	44.65	42.85	1.8
2026-10-13 03:00:00.000000	23535	generator	44.61	42.85	1.76
2026-10-13 03:00:00.000000	23532	generator	41.56	42.85	-1.29
2026-10-13 03:00:00.000000	23538	generator	44.65	42.85	1.8
2026-10-13 03:00:00.000000	23543	generator	40.24	42.85	-2.61
2026-10-13 03:00:00.000000	23540	generator	44.69	42.849999999999994	1.84

Coverage

100.0% complete0 gap days9,827 days with data

Show coverage history

Coverage: 100.0%Days with data: 9,827Gaps: 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 prices data

Related prices data
Dataset	Description
Coordinated Transaction Scheduling PricesNYISO · 15-minute RTC timestep	NYISO Coordinated Transaction Scheduling prices by generator PTID and RTC timestep, including NYISO generator LBMP and the paired external RTO CTS price for PJM / ISO-NE coordination analysis.
Day-Ahead Generator LBMPNYISO · hourly (DAM)	NYISO hourly day-ahead generator-level LBMP by generator PTID, with energy, congestion, and loss components. It is the generator-level day-ahead companion to zonal day-ahead LBMP.
Day-Ahead Zonal LBMPNYISO · hourly (DAM)	Hourly day-ahead locational-based marginal prices (LBMP) for NYISO load zones. These prices clear before the operating day and provide the day-ahead companion to real-time zonal LBMP, useful for DA/RT spreads, congestion expectations, and load-zone market analysis.
Integrated Real-Time Generator LBMPNYISO · hourly integrated RT	NYISO settlement-style hourly integrated real-time LBMP for generator PTIDs. Use it when hourly generator-level price settlement is more appropriate than raw five-minute LBMP.