Overview
The EIA Energy Data listing delivers every public-domain series published by the U.S. Energy Information Administration (EIA): more than 3.8 million series and 250 million values across 28 EIA datasets, ready to query in Snowflake with no API keys or rate limits to manage. Start with a free 30-day trial with full use of the data. It’s built for energy and commodity analysts, quant researchers and data teams who need EIA data next to their own data in Snowflake: gas storage and production, grid demand, refinery runs, prices and EIA’s forecasts, without writing and maintaining an EIA pipeline. Data is standardized into analytic‑ready tables (series metadata, current values, revision history) with every value’s period parsed into a real date, the raw value kept next to the numeric one, and automated pipeline quality checks (row parity with EIA’s published data, format validation, version ordering) so you can query, join, model and build dashboards right away, without building or maintaining your own EIA ingestion pipeline.Coming soon to the Snowflake Marketplace
- Free 30-day trial with full use of every view, series and revision
- 3.8M+ EIA series from 28 datasets: natural gas, petroleum, electricity, coal, international, state energy, emissions and more
- Hourly electric grid data (EIA-930): demand, generation by fuel and interchange for every balancing authority, from 2019
- Forecasts and projections: the Short-Term Energy Outlook, 12 editions of the Annual Energy Outlook and 4 of the International Energy Outlook
- Full available history, back to 1859 for some petroleum series
- Revision history: every value each data point has had since we started loading it, with
valid_fromandvalid_to - Checked hourly: new EIA data is in the listing within about an hour of EIA publishing it
- Automated pipeline quality checks (row parity with EIA’s published data, period and value validation, version ordering)
What is EIA data?
The U.S. Energy Information Administration (EIA) is the independent statistics agency of the U.S. Department of Energy. It collects data from energy companies, utilities, grid operators and other agencies, and publishes the official U.S. numbers on how energy is produced, stored, moved, priced and used. Its data is in the public domain, and it’s the standard reference for anyone who analyzes energy markets. What’s available, at a glance:- Natural gas: production, weekly storage, imports and exports, consumption and prices by state
- Petroleum: crude oil and product supply, weekly inventories (including Cushing, Oklahoma), refinery runs, imports by country, and retail gasoline and diesel prices
- Electricity: generation by fuel, state and power plant, retail sales and prices, and the hourly U.S. grid (demand, generation and interchange for every balancing authority)
- Coal and nuclear: coal production, consumption and prices, and the daily status of every U.S. nuclear reactor
- State and total energy: the State Energy Data System and the Monthly Energy Review, covering all fuels together
- International: production, consumption and reserves for countries around the world
- Emissions: energy-related CO2 emissions by state and sector
- Forecasts: the monthly Short-Term Energy Outlook and the long-range Annual and International Energy Outlooks
Coverage
As of November 2026:NG and PET) aren’t public domain and are left out. Every other EIA series in these datasets is included.
Schema
The listing has three views. Every series ID starts with its dataset, for exampleNG.NW2_EPG0_SWO_R48_BCF.W. Join the observation views to eia_series_vw on series_id to get each value’s name, units and geography.
eia_series_vw
One row per series, including series EIA has stopped publishing.
eia_observations_vw
The current value of every data point: one row per (dataset, series_id, period).
eia_observations_history_vw
Every value each data point has had since we started loading it: one row per (dataset, series_id, period, valid_from). The row with is_current = true matches eia_observations_vw.
Example queries
All example output below is real, pulled from the listing on November 20, 2026 at 01:50 UTC. Timestamps are shown in UTC. Each query finished in under 1.5 seconds on an X-Small warehouse. Run the same queries yourself during the free 30-day trial once the listing launches on the Snowflake Marketplace (coming soon).Natural gas in storage
Weekly Lower 48 natural gas working storage, in billion cubic feet:Find series by name
Crude oil stocks at Cushing, Oklahoma:Hourly electricity demand
Hourly Lower 48 electricity demand, in megawatthours, from EIA-930:STEO forecasts vs. actuals
STEO world petroleum production, in million barrels per day, with EIA’s forecasts marked apart from actuals:Revisions to one data point
Every value one hour of grid demand has had, as EIA revised it:Revision history
EIA revises values after it first publishes them, and only ever publishes the latest number.eia_observations_vw gives you that latest number. eia_observations_history_vw keeps every earlier one: each time EIA changes or removes a value, the old row is closed with a valid_to and the new one starts. That lets you see how a number was reported before it was revised, or rebuild a series as it was known at a past moment:
Data Ingestion
Data is ingested into Snowflake with best practices in mind.Change detection
Raw snapshot
Standardize
Insert-only versioning
EBA) republishes about twice a day, natural gas storage weekly, the Short-Term Energy Outlook monthly, and the Annual Energy Outlook once a year. New data is loaded within about an hour of EIA publishing it.
Data Quality
- Row parity: every load checks that each dataset’s series and value counts match what EIA published, and that the published counts for all 28 datasets match the listing’s views.
- Format validation: every staged row is checked for a known frequency, a period that matches its frequency and parses to a date, a numeric value that parsed, and no hourly or daily period far in the future.
- Unique grain: every
(dataset, series_id, period)has exactly one current value. - No hollow series: every series in
eia_series_vwmust have values ineia_observations_vw. - Truncated-load guard: a dataset update with far fewer series or values than its last load, or missing key series like Lower 48 gas storage, is stopped before it reaches the listing.
- Versions only move forward: a dataset can’t be replaced by an older EIA release than the one already published.
- Public domain only: licensed series are checked to never appear in the listing’s views.
Disclosures
Fruit Stand Data LLC is not endorsed by or affiliated with the U.S. Energy Information Administration. EIA data is in the public domain. Use contact@fruitstand.dev for questions. Source gaps: some EIA series have periods with no value, or a marker such asNA or W (withheld to avoid disclosing individual company data) in place of a number. These are passed through as EIA published them: value is null and value_raw shows the marker.
F.A.Q.
Frequently asked questions from our clients.Is there a free trial?
Is there a free trial?
What is the EIA?
What is the EIA?
How often is the data refreshed?
How often is the data refreshed?
When does replication across cloud regions happen?
When does replication across cloud regions happen?
How far back does the historical data go?
How far back does the historical data go?
How is the data obtained?
How is the data obtained?
Why use this listing instead of the EIA API?
Why use this listing instead of the EIA API?
NA and W, detect changes and keep revisions. This listing does all of that, so you can start querying right away, and the free 30-day trial lets you check it against your own use case first.What does it cost to build this ourselves vs. buy the listing?
What does it cost to build this ourselves vs. buy the listing?
Does this include revision history?
Does this include revision history?
eia_observations_history_vw keeps every value each data point has had since we started loading it in November 2026, with valid_from and valid_to. See Revision history above.Are EIA's forecasts included?
Are EIA's forecasts included?
STEO) has monthly forecasts through the end of next year, and last_historical_period on each STEO series marks where actuals end. The Annual Energy Outlook editions from 2014 to 2026 (AEO.2014 to AEO.2026) and the International Energy Outlook editions (IEO.2017 to IEO.2023) carry long-range projections to 2040 or 2050, each edition as its own dataset so you can compare them.What isn't included?
What isn't included?
What happens when EIA stops publishing a series?
What happens when EIA stops publishing a series?
is_active turns false in eia_series_vw. Filter on is_active to see only series EIA still updates.Can I request additional EIA data to be made available in Snowflake?
Can I request additional EIA data to be made available in Snowflake?