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).
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
Analysis rules
Interpretation
Schema4
event_timeDateTime64(6, 'UTC')fuel_typeStringgen_mwNullable(Float64)qualityStringSample data
| event_time | fuel_type | gen_mw | quality |
|---|---|---|---|
| 2026-09-05 23:15:00.000000 | coal | 10712.4970703125 | live |
| 2026-09-05 23:15:00.000000 | hydro | 63.4370002746582 | live |
| 2026-09-05 23:15:00.000000 | nuclear | 4956.189453125 | live |
| 2026-09-05 23:15:00.000000 | storage | 2474.01000976562 | live |
| 2026-09-05 23:15:00.000000 | solar | 15855.0732421875 | live |
| 2026-09-05 23:15:00.000000 | wind | 8779.23046875 | live |
| 2026-09-05 23:15:00.000000 | gas | 39617.64739990235 | live |
| 2026-09-05 23:15:00.000000 | other | 76.0999984741211 | live |
| 2026-09-05 23:10:00.000000 | coal | 10759.8740234375 | live |
| 2026-09-05 23:10:00.000000 | hydro | 64.4290008544922 | live |
| 2026-09-05 23:10:00.000000 | nuclear | 4960.56982421875 | live |
| 2026-09-05 23:10:00.000000 | storage | 2251.4033203125 | live |
| 2026-09-05 23:10:00.000000 | solar | 16332.01171875 | live |
| 2026-09-05 23:10:00.000000 | wind | 8609.4130859375 | live |
| 2026-09-05 23:10:00.000000 | gas | 39570.85180664064 | live |
| 2026-09-05 23:10:00.000000 | other | 71.9000015258789 | live |
| 2026-09-05 23:05:00.000000 | coal | 10758.13671875 | live |
| 2026-09-05 23:05:00.000000 | hydro | 64.4380035400391 | live |
| 2026-09-05 23:05:00.000000 | nuclear | 4956.0859375 | live |
| 2026-09-05 23:05:00.000000 | storage | 1593.31359863281 | live |
| 2026-09-05 23:05:00.000000 | solar | 17004.146484375 | live |
| 2026-09-05 23:05:00.000000 | wind | 8632.8896484375 | live |
| 2026-09-05 23:05:00.000000 | gas | 39578.07701110839 | live |
| 2026-09-05 23:05:00.000000 | other | 69.8000030517578 | live |
| 2026-09-05 23:00:00.000000 | coal | 10760.5400390625 | live |