Overview

ERCOT day-ahead locational marginal prices, one row per interval and location. 66.7M rows, 2017-01 to the next delivery day. Carries price_usd_mwh plus energy_usd_mwh and congestion_usd_mwh, with energy taken from ERCOT's DAM system lambda. No loss component: ERCOT does not publish one. Locations are node, zone, hub, interface; location_id joins atg.ercot_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.

ERCOT market Ask the agent about this dataset

Use with MCP

This table is readable two ways, over the same guarded boundary. Over HTTP: POST /api/v1/datasets/ercot_prices_da/query, described in the API reference. Or from an MCP client: connect a market below, then use search_data or describe_data to load its query contract before calling query_data.

ERCOT MCP Server

Schema6

Column

Type

event_timeDateTime64(6, 'UTC')

location_idString

kindLowCardinality(String)

price_usd_mwhNullable(Float64)

energy_usd_mwhNullable(Float64)

congestion_usd_mwhNullable(Float64)

Sample rows

event_time	location_id	kind	price_usd_mwh	energy_usd_mwh	congestion_usd_mwh
2026-08-29 05:00:00.000000	AMAD_ESS_RN	node	32.77	∅	∅
2026-08-29 05:00:00.000000	7RNCHSLR_ALL	node	35.56	∅	∅
2026-08-29 05:00:00.000000	ALGOD_ALL_RN	node	36.04	∅	∅
2026-08-29 05:00:00.000000	ALAMO_ST_RN	node	47.94	∅	∅
2026-08-29 05:00:00.000000	A4_DGR1_RN	node	36.56	∅	∅
2026-08-29 05:00:00.000000	AMOCOOIL_CC2	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AJAXWIND_RN	node	29.72	∅	∅
2026-08-29 05:00:00.000000	A4_DGR2_RN	node	36.56	∅	∅
2026-08-29 05:00:00.000000	ALVIN_RN	node	34.65	∅	∅
2026-08-29 05:00:00.000000	AE_RN	node	34.73	∅	∅
2026-08-29 05:00:00.000000	AEEC	node	14.24	∅	∅
2026-08-29 05:00:00.000000	ADL_RN	node	34.46	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_G3	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_1	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_2	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_5	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_G1	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AMO_AMOCO_G2	node	34.6	∅	∅
2026-08-29 05:00:00.000000	AQLA_WND_RN	node	32.88	∅	∅
2026-08-29 05:00:00.000000	ANACACHO_ANA	node	38.88	∅	∅
2026-08-29 05:00:00.000000	AUSTPL_ALL	node	35.64	∅	∅
2026-08-29 05:00:00.000000	ANDMDSLR_ALL	node	27.88	∅	∅
2026-08-29 05:00:00.000000	AURO_SLR_RN	node	34.26	∅	∅
2026-08-29 05:00:00.000000	ATK_ATKINSG7	node	34.02	∅	∅
2026-08-29 05:00:00.000000	ASTRA_RN	node	21.32	∅	∅

Coverage

100.0% complete0 gap days3,527 days with data

Show coverage history ▾

Coverage: 100.0%Days with data: 3,527Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

More data from ERCOT

Ancillary Service PricesHourly 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.CRR Monthly Auction ResultsCleared ERCOT monthly Congestion Revenue Right auction awards, one row per source-to-sink CRR and time-of-use block, including awarded MW and the auction shadow price per MWh. This is public auction evidence for who acquired a path and at what clearing price. It does not contain realized day-ahead congestion settlements, fees, later trades, the holder's full portfolio, or net profit, so auction cost must not be described as payout or profitability. The official source is ERCOT report NP7-803-M.Current Supply, Demand & Intraday ForecastERCOT's public real-time supply and demand dashboard at five-minute resolution. This is the preferred dataset for a current actual-versus-forecast demand comparison: series='realized' reports observed demand_mw, series='intraday_forecast' reports demand_mw forecast for the same target event_time at successive source_time vintages, and series='forward_forecast' reports forecasted_demand_mw farther ahead. It also carries committed and available capacity. Operators, traders, and researchers use it to measure current forecast error, headroom, and how forecasts converge toward realized demand.DAM Settlement Point PricesHourly settlement point prices cleared in the ERCOT Day-Ahead Market, covering every settlement point in Texas (load zones, hubs, and resource nodes). These are the prices at which energy is bought and sold a day in advance of delivery, set the afternoon before each operating day. They are the day-ahead counterpart to real-time locational prices, and the gap between the two reflects how the market expected conditions to differ from how they actually unfolded. Traders use them to position and hedge, generators and loads use them to plan commitments, and researchers use them to study how congestion and scarcity show up across the grid.