The US Energy Transition
Seven years of hourly electricity generation by fuel type across the US grid. Watch coal decline and solar and wind rise — region by region — then see the fuel mix powering the grid right now.
How It Works
Data Source: The US Energy Information Administration’s Hourly Electric Grid Monitor (Form EIA-930) reports net generation by fuel type for every balancing authority, every hour, back to 2019.
Ingestion: A Python job backfilled seven years of history and a live tail polls the EIA API each hour, writing to Arc using its MessagePack columnar format — the same path Arc uses for millions of rows per second.
Storage: Millions of hourly generation records across 14 regions and a dozen fuel types, stored in compressed Parquet.
Rollup: An Arc continuous query keeps a daily generation-by-fuel table current, so the seven-year trend answers in under a second while the live panels query the raw hourly data directly.
SQL Query for the Transition Trend
SELECT
date_trunc('month', time) AS month,
sum(coal) AS coal,
sum(renewables) AS renewables,
sum(total) AS total
FROM energy_grid.fuel_daily
WHERE region = 'US48'
GROUP BY 1
ORDER BY 1 ASC