DAM Settlement Point Prices

Hourly settlement point prices cleared in the ERCOT Day-Ahead Market, covering every settlement point in Texas (load zones, hubs, and resource nodes).

Prices data

Download data Open on map

Native record

settlement point x delivery hour

hourly (DAM) publication cadence

Evidence

Cleared day-ahead market

A market outcome, not a physical observation

In Ask the Grid

Price nodes on the ERCOT map

Values for the live grid surface

Overview

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.

Query contract

Read ercot.spp_day_ahead_hourly with FINAL so repeated ingestion revisions collapse to one row per settlement point and delivery hour.

Analysis rules

For an ERCOT trading-hub comparison, use the canonical hubs HB_HOUSTON, HB_NORTH, HB_SOUTH, HB_WEST, and HB_PAN. Do not include HB_BUSAVG or HB_HUBAVG unless the user explicitly asks for aggregate hub indices.
Aggregate only after revision collapse; otherwise repeated ingestions multiply every delivery hour.

Related analysis

day-ahead congestion component and point price decomposition · same day-ahead delivery hour
day-ahead versus real-time point price · Use query_data on both datasets with the same exact settlement_point and ISO-local day, event_time bucket='hour', ascending. Select the day-ahead hourly SPP and average real-time LMP by delivery hour. query_data normalizes this source's interval-end labels to delivery-hour starts, so the returned UTC axes align exactly for compute.

Interpretation

ERCOT clears its day-ahead market around midday and posts the results by about 1:30 PM Central the day before delivery. Before early afternoon Central time, the next day's prices have not been published yet — that is the market's schedule, not missing coverage; offer today's cleared prices instead.

Schema9

Column

Type

event_timeDateTime64(6, 'UTC')

settlement_pointLowCardinality(String)

settlement_point_typeLowCardinality(String)

dam_sppNullable(Float64)

dst_flagNullable(Bool)

emil_idNullable(String)

doc_idNullable(Int64)

ingested_atDateTime64(6, 'UTC')

source_timeNullable(DateTime64(6, 'UTC'))

Sample data

event_time	settlement_point	dam_spp	dst_flag	emil_id	doc_id	ingested_at	source_time
2026-09-26 05:00:00.000000	ZIER_SLR_ALL	35.55	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	Z5_DGR1_RN	33.71	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	Z0_DGR2_RN	33.71	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	Z0_DGR1_RN	33.71	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	YNG_WND_ALL	28.41	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	YCAT_WND_RN	31.53	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	YAPN_SLR_RN	32.52	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	X443ESRN	33.78	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	X1_DGR_RN	33.75	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	W_PECO_UNIT1	47.48	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	W_HRL_ESR_RN	33.61	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WZRD_ESS_RN	32.62	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WR_RN	32.74	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WRSBES_BESS1	48.86	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WOV_BESS_RN	45.29	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WOODWRD2_RN	41.08	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WOODWRD1_RN	41.08	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WND_WHITNEY	31.24	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WNDTS2_UNIT1	31.48	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WL_RANCH_RN	38.41	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WLTC_ESR_RN	33.57	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WIR_WIRTZ_G2	33.81	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WIR_WIRTZ_G1	33.81	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WIPOPA_3_4	33.22	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000
2026-09-26 05:00:00.000000	WIPOPA_1_2	33.22	false	∅	∅	2026-09-25 10:40:46.084710	2026-09-24 17:51:24.000000

Coverage

100.0% complete0 gap days4,531 days with data

Show coverage history

Coverage: 100.0%Days with data: 4,531Gaps: 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

gaplessmore

Related prices data

Related prices data
Dataset	Description
DAM System LambdaERCOT · hourly (DAM)	ERCOT's hourly day-ahead system lambda, the system-wide marginal energy component in the cleared Day-Ahead Market. For the same delivery hour and settlement point, day-ahead SPP minus DAM system lambda is the point's cleared day-ahead congestion component. Paired with SCED system lambda and real-time LMP, it supports day-ahead-versus-real-time congestion basis by point. It does not identify a binding constraint's effect on a point without direct attribution evidence.
DAM Total Energy SoldERCOT · hourly (DAM)	This dataset reports the total energy sold in ERCOT's Day-Ahead Market, in megawatt-hours, for each delivery hour. It represents the system-wide quantity of energy that cleared the day-ahead auction, where buyers and sellers commit to next-day positions before real-time operations. The hourly shape across a day shows how much of expected Texas demand is locked in financially a day ahead, and tracking it over time reveals shifts in day-ahead market participation and how forward commitments line up against eventual real-time conditions. The figures come from ERCOT report NP4-193-CD.
ERCOT Day-Ahead PricesERCOT · hourly (DAM)	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 Real-Time PricesERCOT · 5-minute (SCED)	ERCOT real-time locational marginal prices, one row per interval and location. 979.1M rows, 2014-05 to now. Carries price_usd_mwh plus energy_usd_mwh and congestion_usd_mwh. ERCOT publishes no marginal-loss component and this table has no loss column: energy is ERCOT's own SCED system lambda and congestion is price minus lambda, an exact identity rather than an estimate. Locations are node (resource nodes), zone (load zones), hub, interface (the four DC ties); 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 real-time 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.