ERCOT Day-Ahead Total Energy Sold

This dataset reports the total energy sold in ERCOT's Day-Ahead Market, in megawatt-hours, for each delivery hour.

ercot.dam_total_energy_soldGeneration data ERCOT market

One row per: event_time; Hourly (DAM) cadence
Evidence: Cleared day-ahead market; A market outcome, not a physical observation
Time basis: Point-in-time records; UTC · event_time

Overview

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.

Query contract: Preserve one canonical row per (event_time) before aggregating.
Analysis rules: Group only after preserving the declared grain: event_time.

Access

Plans: See available download and API access options. View pricing
MCP: Connect an MCP client and load the contract with describe_data before calling query_data.ERCOT MCP API reference
HTTP endpoint: POST /api/v1/datasets/ercot_dam_total_energy_sold/query
Full history: Delivered to Snowflake, Databricks or your own storage on a schedule by Data services.
More coverage

Schema

6 columns

Column	Type
`event_time`	`DateTime64(6, 'UTC')`
`total_energy_sold_mwh`	`Nullable(Float64)`
`dst_flag`	`Nullable(Bool)`
`emil_id`	`Nullable(String)`
`doc_id`	`Nullable(Int64)`
`ingested_at`	`DateTime64(6, 'UTC')`

Loading…

Sample data

event_timeDateTime64(6, 'UTC')

total_energy_sold_mwhNullable(Float64)

dst_flagNullable(Bool)

emil_idNullable(String)

doc_idNullable(Int64)

ingested_atDateTime64(6, 'UTC')

2026-11-10 06:00:00.000000

34896.5

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 06:00:00.000000

34896.5

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 05:00:00.000000

35603.7

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 05:00:00.000000

35603.7

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 04:00:00.000000

35920.1

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 04:00:00.000000

35920.1

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 03:00:00.000000

36664.9

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 03:00:00.000000

36664.9

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 02:00:00.000000

37152.5

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 02:00:00.000000

37152.5

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 01:00:00.000000

38409.5

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 01:00:00.000000

38409.5

false

NULL

2026-11-09 06:30:15.963492

2026-11-10 00:00:00.000000

38213.9

false

NULL

2026-11-09 07:30:14.322868

2026-11-10 00:00:00.000000

38213.9

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 23:00:00.000000

37301.4

false

NULL

2026-11-09 07:30:14.322868

2026-11-09 23:00:00.000000

37301.4

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 22:00:00.000000

36919.1

false

NULL

2026-11-09 07:30:14.322868

2026-11-09 22:00:00.000000

36919.1

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 21:00:00.000000

35909.9

false

NULL

2026-11-09 07:30:14.322868

2026-11-09 21:00:00.000000

35909.9

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 20:00:00.000000

36390.6

false

NULL

2026-11-09 07:30:14.322868

2026-11-09 20:00:00.000000

36390.6

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 19:00:00.000000

36493.6

false

NULL

2026-11-09 07:30:14.322868

2026-11-09 19:00:00.000000

36493.6

false

NULL

2026-11-09 06:30:15.963492

2026-11-09 18:00:00.000000

35969.9

false

NULL

2026-11-09 07:30:14.322868

25 rows

25 sample rows of 86.4KBrowse every row in Data

Loading…

Coverage

Complete: 100.0%
Gap days: 0
Days with data: 3,600

Show coverage history

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

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

gaplessmore

Loading…

Related data

Related generation data
Dataset	Description
ERCOT Day-Ahead Energy Storage Offers and Awards (60-Day)ERCOT · hourly (DAM), 60-day disclosure	What each ERCOT battery offered into the Day-Ahead Market and what it was awarded, hour by hour, from the 60-Day DAM Disclosure Reports. Like the SCED storage file this subreport begins at RTC+B go-live on 6 December 2025. Each row is one hour for one storage resource and its QSE, carrying the QSE's submitted energy curve as up to ten monotonic MW/price pairs, the resource's high and low sustainable limits and status, the awarded energy quantity, its settlement point and that point's day-ahead price, and its ancillary awards with the matching market clearing price for capacity in each service (Reg-Up, Reg-Down, RRS-PFR, RRS-FFR, RRS-UFR, ECRS, Non-Spin). This is where day-ahead storage strategy is legible: how a fleet split its capacity between energy and reserves, what it was paid for each, and how its bid curve related to the price that cleared. It is a cleared-market record on a 60-day regulatory delay, not a live feed. Measured 2026-09-07: 3.2 million rows. The official source is ERCOT report NP3-966-ER, 60-Day DAM Disclosure Reports.
ERCOT Fuel Mix (15-Minute Settlement)ERCOT · 15-minute (settlement)	ERCOT's Fuel Mix Report (IntGenByFuel) gives actual electricity generation across the Texas grid broken out by fuel type, for every 15-minute settlement interval. Each interval lists output for categories such as gas, coal, nuclear, wind, solar, hydro, and storage, with values first published as initial readings and later restated as settlement-quality finals. It shows what physically ran on the system and in what proportion, letting operators, traders, and researchers track the real-time generation mix, gauge renewable penetration against load, and study how the fuel stack shifts hour to hour and season to season. The SQL agent queries this through the unified `ercot_fuel_mix` view (quality='settled') rather than this table directly.
ERCOT Fuel Mix (5-minute)ERCOT · 5-minute	Realized generation in megawatts across ERCOT's eight headline fuel categories (such as gas, wind, solar, nuclear, coal, and hydro), reported at five-minute intervals for the Texas grid. This is the live operational view of where power is actually coming from at any moment, the faster companion to the settlement-grade Fuel Mix Report. It lets operators, traders, and researchers watch the resource mix shift in near real time, track renewable ramps and gas response intraday, and see how generation composition moves with load and prices. The official upstream source is ERCOT report NP6-788-CD (Fuel Mix Report). The SQL agent queries this through the unified `ercot_fuel_mix` view (quality='live') rather than this table directly.
ERCOT Fuel Mix (Unified)ERCOT · 5-minute (live only, pending settled backfill)	Realized ERCOT generation in megawatts by fuel type (coal, hydro, nuclear, storage, solar, wind, gas, other), one row per (event_time, fuel_type, quality). Long-format unification of the live 5-minute feed and the settlement-grade Fuel Mix Report — but quality='settled' is TEMPORARILY DISABLED: ercot.fuel_mix_report's gen_mw was found to be ~4x too low (ERCOT publishes MWh delivered per 15-min interval, not average MW, and the writer didn't convert). The write-path bug is fixed, but existing report rows are still wrong pending a full historical backfill, so this view currently emits quality='live' only (the 5-minute feed, which reads a separate MW-native source and is correct). The settled branch will return once the backfill is verified. Always filter by event_time; this is a view, and an unbounded scan is expensive. This is the table the SQL agent actually queries; ercot_fuel_mix_report and ercot_fuel_mix_5min remain in the public catalog as the underlying raw sources.