Fuel Mix (Unified)

Realized ERCOT generation in megawatts by fuel type (coal, hydro, nuclear, storage, solar, wind, gas, other), one row per (event_time, fuel_type, quality).

Generation data

Download data

Native record

ERCOT system x fuel type x 5-minute (live) or 15-minute (settled) interval

5-minute (live only, pending settled backfill) publication cadence

Evidence

Observed market data

Published observations from the named source

Time basis

Point-in-time records

UTC · event_time

Overview

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.

Query contract

Select one exact event_time and one quality ('live' or 'settled'); never mix quality within one snapshot or sum across it. gen_mw is already the collapsed, revision-resolved value for that (event_time, fuel_type, quality) — no further argMax/vintage reduction is needed or correct.

Analysis rules

For a current fuel mix, use every fuel_type row at the same latest event_time and quality; do not combine values from different snapshots or different quality levels.
Calculate shares against the sum of gen_mw across fuel_type at that (event_time, quality).

Interpretation

quality='settled' is temporarily unavailable (returns no rows): the underlying ercot.fuel_mix_report source had a ~4x unit bug (MWh-per-interval stored as if it were average MW). Only quality='live' is currently exposed. Do not describe historical/settled fuel-mix data as unavailable in general — this is a known, temporary gap being backfilled, not a product boundary.
gen_mw for fuel_type='storage' is net fleet output: positive is discharging into the grid, negative is charging from the grid.

Access

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

Schema4

Column

Type

event_timeDateTime64(6, 'UTC')

fuel_typeString

gen_mwNullable(Float64)

qualityString

Sample data

event_time	fuel_type	gen_mw	quality
2026-10-21 06:10:00.000000	coal	6052.4501953125	live
2026-10-21 06:10:00.000000	hydro	0	live
2026-10-21 06:10:00.000000	nuclear	3837.35327148437	live
2026-10-21 06:10:00.000000	storage	-2747.24072265625	live
2026-10-21 06:10:00.000000	solar	1.03515601158142	live
2026-10-21 06:10:00.000000	wind	15750.322265625	live
2026-10-21 06:10:00.000000	gas	22034.22621154786	live
2026-10-21 06:10:00.000000	other	50	live
2026-10-21 06:05:00.000000	coal	6160.25732421875	live
2026-10-21 06:05:00.000000	hydro	0	live
2026-10-21 06:05:00.000000	nuclear	3837.6220703125	live
2026-10-21 06:05:00.000000	storage	-2848.09252929687	live
2026-10-21 06:05:00.000000	solar	1.08969783782959	live
2026-10-21 06:05:00.000000	wind	15776.2578125	live
2026-10-21 06:05:00.000000	gas	22223.88475036622	live
2026-10-21 06:05:00.000000	other	50.0999984741211	live
2026-10-21 06:00:00.000000	coal	6213.42431640625	live
2026-10-21 06:00:00.000000	hydro	4.96399974822998	live
2026-10-21 06:00:00.000000	nuclear	3835.02172851562	live
2026-10-21 06:00:00.000000	storage	-2776.21899414063	live
2026-10-21 06:00:00.000000	solar	1.36057424545288	live
2026-10-21 06:00:00.000000	wind	15853.021484375	live
2026-10-21 06:00:00.000000	gas	22173.15440368653	live
2026-10-21 06:00:00.000000	other	50.0999984741211	live
2026-10-21 05:55:00.000000	coal	6200.33837890625	live

Coverage

100.0% complete0 gap days135 days with data

Show coverage history

Coverage: 100.0%Days with data: 135Gaps: 0

2026

gaplessmore

Related generation data

Related generation data
Dataset	Description
ERCOT Generation Mix by FuelERCOT · 5-minute (live) and 15-minute (settled)	What is physically generating in ERCOT, in megawatts by fuel, one row per interval. 691,109 intervals, 2007-01 to now. Columns: coal_mw, gas_mw, nuclear_mw, hydro_mw, wind_mw, solar_mw, storage_mw, other_mw. Wide rather than long: a whole interval's mix is one row, so shares are computed across columns in that row and the timestamp does not repeat once per fuel. "Which fuel is largest" is greatest() across the columns, or simply reading the row.
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.
Fuel Mix ReportERCOT · 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.
Hourly RUC Committed CapacityERCOT · hourly	How much generation capacity ERCOT's Reliability Unit Commitment (RUC) process has effectively forced online, hour by hour. For each hour of the RUC study period, ERCOT publishes the sum of the High Sustained Limits (HSLs) of resources that are online in the most recent SCED execution but were indicated as offline in their Current Operating Plan (COP) — i.e. capacity RUC committed beyond what the market self-committed. This is a direct hourly proxy for RUC-committed MW, the signal behind reliability commitments on tight days. From 2021 the megawatts are broken out by weather zone (South, North, West, Houston) with committed_capacity_mw as the system total; earlier vintages (back to October 2018) carry the system-wide total only, since ERCOT did not publish the zonal split before then. It is bitemporal — every row carries both the study delivery hour (event_time) and the publishing vintage (source_time), so successive hourly RUC runs accumulate as distinct rows. The official source is ERCOT report NP3-764-CD, Hourly RUC Online In SCED Offline In COP.