Skip to main content
Try it free for 30 days. Get full access to the complete history of every series, and every vintage, during the trial.

Overview

The FRED Series listing delivers 574,480 series from FRED (Federal Reserve Economic Data), with 69.9 million observations and their full history, ready to query in Snowflake with no API keys or rate limits to manage. It also includes 826 million ALFRED vintage rows, so you can see every series as it was known on any past date. Start with a free 30-day trial with full access. It’s built for economists, quant researchers, analysts and data teams who need macro data next to their own data in Snowflake: rates, inflation, jobs, GDP, housing, banking and regional data, without writing and maintaining a FRED pipeline. Data is standardized into analytic‑ready views (series, observations, vintages, categories, tags, releases) with metadata on every series (units, frequency, seasonal adjustment, popularity) and automated pipeline quality checks (load parity, unique keys, matching series between views) so you can query, join, model and build dashboards right away.

Start your free 30-day trial on the Snowflake Marketplace

Free for 30 days with full access, then $150/month flat rate — no pipelines to build.
Pricing: one flat subscription of $150/month, billed monthly in advance through Snowflake. It includes every view, all 574,000+ series with full history, the ALFRED vintages and every daily refresh. There are no per-query, per-row or per-user fees; your own Snowflake warehouse pays for the queries you run.
  • Free 30-day trial with full access to every view, series and vintage
  • 574,480 FRED series and 69.9 million observations, from 61 sources such as the Census Bureau, BLS, BEA and the Federal Reserve
  • Full history of every series, back to 1854 for the NBER recession indicators and 1948 for the unemployment rate
  • ALFRED vintages: 826 million rows covering every published version of each observation, for point-in-time analysis
  • Rich metadata: 240 releases, 4,599 categories and 5,567 tags to find and group series
  • Refreshed daily: series FRED updated the day before are reloaded each night
  • Automated pipeline quality checks (load parity, unique keys, observations matching their vintages)
Fruit Stand also publishes EIA energy data, historical stock prices, fund and ETF returns and earnings call transcripts on the Snowflake Marketplace.

What is FRED data?

FRED (Federal Reserve Economic Data) is the economic database of the Federal Reserve Bank of St. Louis. It collects time series from government agencies, central banks, international organizations and universities, and publishes them under one ID scheme (UNRATE, CPIAUCSL, GDP). Its companion archive, ALFRED, keeps every past version of each series, so you can see what was known before later revisions. FRED is the standard free reference for U.S. and international macro data. What’s available, at a glance:
  • Labor: unemployment, payrolls, wages, job openings and claims, nationally and by state and metro area
  • Prices and inflation: CPI and its components, PCE, PPI and deflators
  • Output and income: GDP and its parts, industrial production, capacity utilization, personal income
  • Interest rates: Fed funds, Treasury yields and spreads such as T10Y2Y, mortgage rates
  • Money and banking: money supply, reserves, bank loans, deposits and balance sheets
  • Housing: starts, permits, sales and FHFA house prices
  • Regional: state, county and metro data from the Census Bureau, BLS and BEA
  • International: OECD, IMF, World Bank and Eurostat series by country

Coverage

As of November 2026, by series frequency: The earliest dates (1854) are the NBER recession indicators such as USREC. Some projection series run to 2036. The ALFRED vintage views cover 574,361 of the series, with 23.6 million vintage dates. What isn’t included: FRED’s terms say series owned by third parties need the owner’s permission to use beyond personal use, so the listing leaves out every series from licensed sources: 96,159 series, including S&P Dow Jones Indices (such as SP500 and DJIA), ICE BofA bond indexes, Moody’s, Nasdaq and Zillow. Every other FRED series is included. See What FRED Economic Data Is on the Snowflake Marketplace? for the full breakdown and alternatives.

Schema

The listing has eight views in the FRED schema. Every view has series_id, the FRED series ID (e.g. UNRATE), so join on it. The listing also includes a semantic view, FRED_ECONOMIC_DATA_SV, and a Cortex agent, FRED_AGENT, for asking questions in plain English.

fred_series_vw

One row per series.

fred_series_observations_vw

The current value of every observation: one row per (series_id, date).

fred_series_observations_vintages_vw

Every published version of every observation, from ALFRED: one row per (series_id, date, realtime_start).

fred_series_vintage_dates_vw

One row per (series_id, vintage_date): each date on which the series was revised or new data was released.

fred_series_categories_vw

One row per (series_id, category_id). A series can sit in more than one category.

fred_series_tags_vw

One row per (series_id, tag_name).

fred_series_releases_vw

One row per series: the FRED release it’s published in.

fred_series_search_vw

One row per series, with one text column for searching by keyword.

Example queries

All example output below is real, pulled from the listing on November 20, 2026 at 03:23 UTC. Each query finished in under 3.5 seconds on an X-Small warehouse. Run the same queries yourself during the free 30-day trial. The queries name only the fred schema, so they work in whatever database you mount the listing as.

What is the latest unemployment rate?

The full history, back to January 1948:

What is the 10-year minus 2-year Treasury spread?

The monthly average since the series starts in June 1976. Below zero, the curve is inverted: For the rest of the curve, see How to Get the US Treasury Yield Curve in Snowflake.

Find series by keyword

The most popular series that mention mortgage rates:

Release, category and tags for a series

First 5 of 14 rows:

How was a jobs number revised?

Every published value of June 2026 nonfarm payrolls (PAYEMS, thousands of persons), from ALFRED:
The first print was revised down by 103,000 jobs a month later, then up by 11,000.

Vintage observations (ALFRED)

FRED revises values after it first publishes them. fred_series_observations_vw holds the current value of each observation. fred_series_observations_vintages_vw holds every published version, from ALFRED, FRED’s archive. Each row is one version of a data point, valid from realtime_start to realtime_end, so you can rebuild a series as it was known on any past date. Use it for backtests and forecast evaluation without look-ahead bias. GDP (billions of dollars, seasonally adjusted annual rate) as it was known on March 1, 2020:
fred_series_vintage_dates_vw lists every vintage date for each series:
For background on vintages and why they’re hard to maintain yourself, see How to Get FRED Data into Snowflake.

Data Ingestion

Data is ingested into Snowflake with best practices in mind.
1

Find what changed

Every night at midnight Pacific, the FRED API is asked which series it updated in the previous day. That list is saved as a dated snapshot in S3 and merged into fred_series_vw.
2

Fetch full history

Each series whose update is newer than what the listing holds is fetched again in full from the FRED API, one parquet file per series, into a dated S3 folder.
3

Load and replace

The files are copied into a Snowflake staging table and merged into the observations. In the same transaction, rows FRED no longer returns for that series are removed, so a reloaded series ends with exactly its current observations and readers never see half a series.
4

Vintages, categories, tags and releases

After the observations load, the ALFRED vintages are refreshed for the series FRED updated, and categories, tags and releases are loaded for series new to the listing.
Refresh cadence: the nightly load starts at 12:00 AM Pacific. On 27 of the last 31 days it finished before 5:00 AM Pacific; the slowest days finished in the morning or afternoon. In the listing’s primary region (AWS US West 2, Oregon) new data is live as soon as the load finishes. Other regions get it with the daily replication at 5:00 AM Pacific.

Data Quality

These checks run with every load, and a failure is flagged on that run:
  • Load parity: every staging load checks that the rows Snowflake loaded equal the rows parsed from the files, with no load errors.
  • Every changed series staged: every series selected for reload must end up staged in S3, and the count selected must match the count FRED reported as updated.
  • Unique keys: each (series_id, date) has exactly one current value, and each series has one metadata row.
  • Matching series: fred_series_vw and fred_series_observations_vw must hold the same set of series, so no series has metadata without values or values without metadata.
  • Vintages agree with current values: for every series with a complete vintage load, the current ALFRED versions must equal the current observations.
  • No overlapping vintages: no two versions of the same data point can have overlapping real-time periods, and each data point has exactly one current version.
  • Vintage completeness: the staged vintage rows must equal what FRED returned for each series, and the vintage dates must match the ones FRED lists.
  • No series is ever emptied: a reload that returns no values for a series leaves its existing values in place.
Known quirks:
  • When FRED has no value for a date (it publishes .), there is no row in fred_series_observations_vw. In the vintage view, those versions are kept with a null value.
  • As of November 2026, 114 series have metadata in fred_series_vw but no observations yet, and 119 have no ALFRED vintages.
  • Categories, tags and releases are loaded when a series first arrives. They aren’t reloaded for existing series each day.
Revisions: a revised value replaces the old one in fred_series_observations_vw on the next nightly load. The old value stays in fred_series_observations_vintages_vw, with its realtime_end set to the day before the revision.

Disclosures

Fruit Stand Data LLC is not endorsed by or affiliated with the Federal Reserve Bank of St. Louis, FRED, ALFRED or any of the sources whose data FRED publishes. The listing includes only series FRED does not mark as owned by a third party; most are public domain, and FRED asks that you cite the source (see each series’ cc tag and notes). Use contact@fruitstand.dev for questions.

F.A.Q.

Frequently asked questions from our clients.
Yes. The listing comes with a free 30-day trial with full access: every view, the complete history of every series and every ALFRED vintage, the same data paying subscribers get. After 30 days it’s $150/month flat. Nothing is charged when the trial ends unless you choose to subscribe.
FRED (Federal Reserve Economic Data) is the Federal Reserve Bank of St. Louis’s database of U.S. and international economic time series: rates, money, prices, labor, GDP, housing, banking and regional data, gathered from sources such as the Census Bureau, BLS, BEA, the Federal Reserve Board, the OECD and the IMF. ALFRED is its archive of every past version of each series.
Every night. The load starts at 12:00 AM Pacific, asks FRED which series changed in the previous day, and reloads those series in full. On most days it finishes before 5:00 AM Pacific. ALFRED vintages are refreshed after it for the series FRED updated. Categories, tags and releases are loaded for new series each day.
Replication of refreshes across cloud regions begins at 5:00 AM Pacific each day. If you consume this listing from a Snowflake region other than its primary region (AWS US West 2), expect each day’s updated data to arrive after that replication run. On a day the nightly load finishes after 5:00 AM, that day’s changes reach other regions with the next day’s replication.
Every series carries its full history as FRED publishes it. That’s back to 1854 for the NBER recession indicators, 1939 for nonfarm payrolls (PAYEMS), 1947 for GDP and CPI, 1948 for the unemployment rate (UNRATE) and 1976 for the 10-year minus 2-year spread (T10Y2Y). The vintage history goes back as far as ALFRED has it for each series.
Directly from the FRED and ALFRED APIs of the Federal Reserve Bank of St. Louis.
You certainly can use the FRED API to load data into Snowflake yourself. The API needs a key, is rate-limited, and serves one series per call, so loading 574,000+ series and their vintages means well over a million calls and a pipeline to keep in sync. You’d also have to track which series changed each day, handle FRED’s missing-value markers, stitch ALFRED’s real-time periods together and leave out licensed series. 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.
Building it yourself means a pipeline against the FRED API for 574,000+ series: backfilling full history and vintages, handling rate limits, reloading changed series every night, checking each load, and keeping it running as FRED changes things. That’s weeks of engineering up front and ongoing maintenance after. The listing is $150/month with all of it done, and the free 30-day trial lets you check it first.
Yes. fred_series_observations_vintages_vw has every published version of each observation from ALFRED, with realtime_start and realtime_end dates, so you can see any series as it was known on a past date. See Vintage observations above.
The 96,159 series FRED marks as owned by third parties, such as S&P Dow Jones Indices (SP500, DJIA), ICE BofA bond indexes, Moody’s, Nasdaq and Zillow, because FRED’s terms require the owner’s permission to use them beyond personal use. Some have public alternatives in the listing, such as BAA10Y for corporate spreads and the FHFA house price index. See What FRED Economic Data Is on the Snowflake Marketplace? for details.
Yes! Please reach out to contact@fruitstand.dev with the requirements. We are more than happy to make it available.
More on FRED in Snowflake: Cybersyn’s FRED Tables Are Deprecated: What to Use Instead and How to Calculate Inflation-Adjusted Returns in SQL.

Start your free 30-day trial on the Snowflake Marketplace

Full access to all 574,000+ series and their ALFRED vintages, then $150/month flat rate.