> ## Documentation Index
> Fetch the complete documentation index at: https://fruitstand.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# What FRED Economic Data Is on the Snowflake Marketplace?

> One Snowflake Marketplace listing has FRED series by FRED ID: 573,411 of them. What's in it, which licensed series it leaves out, and how alternatives compare.

*By [Fruit Stand Team](https://fruitstand.dev/about.md) · November 7, 2026 · Comparisons*

One Snowflake Marketplace listing carries FRED series under their FRED IDs:
Fruit Stand's FRED listing, with 573,411 series from 61 sources and every
ALFRED vintage, for \$150/month after a 30-day trial. Snowflake Curated Data
has 167,190 economic indicators from the same original publishers under its
own IDs, and a few free listings use a handful of FRED series.

Below is every FRED option on the Marketplace, what the FRED listing
contains, which popular series it leaves out and why, and SQL to find a
series.

> [!NOTE]
>
> Fruit Stand publishes the FRED listing. We searched the title and
> description of all 4,344 listings visible to our Snowflake account on
> November 7, 2026, and took the counts below from the listing's views and
> from Snowflake Curated Data's free tier the same day.

## Every FRED option on the Marketplace

| Listing | Provider | What it has | FRED series IDs | Revisions (vintages) | Price |
| - | - | - | - | - | - |
| [FRED - Federal Reserve Economic Data Series Observations](https://app.snowflake.com/marketplace/listing/GZTYZ40XYNE) | Fruit Stand | 573,411 FRED series with full history, refreshed daily | Yes | Yes, every ALFRED vintage | \$150/month after a 30-day trial |
| [Snowflake Curated Data](https://app.snowflake.com/marketplace/listing/GZTSZ290BV255) | Snowflake | 167,190 economic indicators loaded from the BLS, Federal Reserve, BEA, Census Bureau and others, not from FRED | No | Yes, in separate vintage tables | Free with a 3-month lag; paid tier with a 60-day trial |
| Data Utilities | Snowflake | Functions that call the FRED API with your own key; no data included | Yes | No | Free |
| Macroeconomic Indicator Market Data Product | Hexaware Technologies | 45 US indicators from the IMF, FRED, World Bank, BEA, BLS and CBO, with forecasts | Not stated | Not stated | Free |
| Banking Analytics Bundle | InSights | FDIC data, Treasury bill rates and FRED unemployment and labor series | Not stated | Not stated | Free |

Two things are missing from that table. FRED itself, run by the Federal
Reserve Bank of St. Louis, doesn't publish a Marketplace listing. And no
listing carries Cybersyn's name anymore: its provider profile now reads
"Snowflake Curated Data Products (formerly Cybersyn)".

## What's in the FRED listing

From the listing's views on November 7, 2026:

| | Count |
| - | -: |
| Series | 573,411 |
| Sources | 61 |
| Releases | 239 |
| Observations (latest values) | 69.8 million |
| Vintage rows (every revision) | 824.6 million, covering 573,292 series |
| Series with an observation in the last 12 months | 166,514 |
| Earliest observation | October 1854 |

Nearly half are county-level: 253,206 series are tagged county, 69,917
state and 44,648 metro area. Regional estimates are mostly published once a
year, which is why annual series outnumber the rest:

| Frequency | Series |
| - | -: |
| Annual | 398,132 |
| Monthly | 96,751 |
| Quarterly | 74,451 |
| Weekly | 2,065 |
| Semiannual | 1,382 |
| Daily | 427 |

The biggest sources are the U.S. Census Bureau (220,285 series), the Bureau
of Labor Statistics (146,805), the Bureau of Economic Analysis (70,918), the
St. Louis Fed itself (56,418), the Federal Reserve Board (49,692) and the
OECD (37,311).

### The 25 most popular FRED series

Ranked by FRED's popularity score on November 7, 2026. Ranks 1 to 17
follow FRED's [Popular Series](https://fred.stlouisfed.org/tags/series?ob=pv)
page; 18 to 25 come from the scores FRED's API returned the same day. 22 of
the 25 are in the listing; the other three are licensed (see the next
section).

| Rank | Series | Name | In the listing |
| -: | - | - | :-: |
| 1 | `BAMLH0A0HYM2` | ICE BofA US High Yield Index Option-Adjusted Spread | No, licensed |
| 2 | `DGS10` | 10-Year Treasury Constant Maturity Yield | ✓ |
| 3 | `T10Y2Y` | 10-Year Minus 2-Year Treasury Spread | ✓ |
| 4 | `FEDFUNDS` | Federal Funds Effective Rate (monthly) | ✓ |
| 5 | `CPIAUCSL` | Consumer Price Index for All Urban Consumers | ✓ |
| 6 | `MORTGAGE30US` | 30-Year Fixed Rate Mortgage Average | ✓ |
| 7 | `M2SL` | M2 Money Stock | ✓ |
| 8 | `UNRATE` | Unemployment Rate | ✓ |
| 9 | `WALCL` | Federal Reserve Total Assets (Wednesday level) | ✓ |
| 10 | `GDPC1` | Real Gross Domestic Product | ✓ |
| 11 | `GDP` | Gross Domestic Product | ✓ |
| 12 | `RRPONTSYD` | Overnight Reverse Repurchase Agreements | ✓ |
| 13 | `DFII10` | 10-Year Treasury Inflation-Indexed Yield | ✓ |
| 14 | `T10Y3M` | 10-Year Minus 3-Month Treasury Spread | ✓ |
| 15 | `SOFR` | Secured Overnight Financing Rate | ✓ |
| 16 | `T10YIE` | 10-Year Breakeven Inflation Rate | ✓ |
| 17 | `DGS30` | 30-Year Treasury Constant Maturity Yield | ✓ |
| 18 | `SP500` | S\&P 500 | No, licensed |
| 19 | `GFDEBTN` | Federal Debt: Total Public Debt | ✓ |
| 20 | `GFDEGDQ188S` | Federal Debt as Percent of GDP | ✓ |
| 21 | `MSPUS` | Median Sales Price of New Houses Sold | ✓ |
| 22 | `WTREGEN` | U.S. Treasury General Account (week average) | ✓ |
| 23 | `BAMLC0A0CM` | ICE BofA US Corporate Index Option-Adjusted Spread | No, licensed |
| 24 | `DFF` | Federal Funds Effective Rate (daily) | ✓ |
| 25 | `DGS2` | 2-Year Treasury Constant Maturity Yield | ✓ |

Names are shortened from FRED's titles. Treasury yields and spreads, policy
rates, inflation and the Fed's balance sheet dominate the list, and all of
those are included. The three gaps are credit-index spreads and a stock
index.

## What isn't in it: licensed series

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. That's 96,159 series from 47 sources, including S\&P Dow
Jones Indices, ICE Data Indices, Moody's, Dow Jones, Nasdaq, Zillow,
Realtor.com, Coinbase, Indeed and Haver Analytics.

Of the 100 most popular series in our FRED catalog, 85 are in the listing.
The 15 that aren't:

| Rank | Series | Name | Licensed from |
| -: | - | - | - |
| 1 | `BAMLH0A0HYM2` | ICE BofA US High Yield Index Option-Adjusted Spread | ICE Data Indices |
| 18 | `SP500` | S\&P 500 | S\&P Dow Jones Indices |
| 23 | `BAMLC0A0CM` | ICE BofA US Corporate Index Option-Adjusted Spread | ICE Data Indices |
| 28 | `IHLIDXUSTPSOFTDEVE` | Software Development Job Postings on Indeed | Indeed |
| 31 | `BAMLC0A4CBBB` | ICE BofA BBB US Corporate Index Option-Adjusted Spread | ICE Data Indices |
| 32 | `BAMLH0A0HYM2EY` | ICE BofA US High Yield Index Effective Yield | ICE Data Indices |
| 35 | `SAHMREALTIME` | Real-time Sahm Rule Recession Indicator | Claudia Sahm |
| 40 | `CSUSHPINSA` | S\&P Cotality Case-Shiller U.S. National Home Price Index | S\&P Dow Jones Indices |
| 51 | `BAMLH0A3HYC` | ICE BofA CCC & Lower US High Yield Index Option-Adjusted Spread | ICE Data Indices |
| 71 | `BAMLC0A4CBBBEY` | ICE BofA BBB US Corporate Index Effective Yield | ICE Data Indices |
| 80 | `BAMLH0A1HYBB` | ICE BofA BB US High Yield Index Option-Adjusted Spread | ICE Data Indices |
| 81 | `DBAA` | Moody's Seasoned Baa Corporate Bond Yield | Moody's |
| 88 | `AAA` | Moody's Seasoned Aaa Corporate Bond Yield | Moody's |
| 92 | `DJIA` | Dow Jones Industrial Average | S\&P Dow Jones Indices |
| 96 | `NASDAQCOM` | NASDAQ Composite | Nasdaq |

Some have unlicensed neighbors in the listing:

* **Corporate bond spreads and yields:** FRED's own spreads over Treasuries,
  `BAA10Y` and `AAA10Y`, are included, and so are the Treasury's High
  Quality Market corporate bond rates, such as `HQMCB10YR`.
* **Home prices:** the FHFA All-Transactions House Price Index (`USSTHPI`)
  is included in place of Case-Shiller.
* **Stock indexes:** for the S\&P 500, use an index fund's prices instead,
  such as SPY in our [Historical Stock Prices](https://fruitstand.dev/datasets/historical-stock-prices.md)
  listing.
* **The Sahm rule:** it's a formula on the unemployment rate, so you can
  compute it yourself (below).

We found no other Marketplace listing that carries them as FRED series.
ICE publishes its own ICE Data Indices listing on the Marketplace; for the
rest, license the data from the owner.

## Snowflake Curated Data and FRED IDs

Snowflake Curated Data loads economic data from the original publishers.
Its free tier's indicator table has 167,190 variables: 93,096 from the BLS,
46,044 from the Federal Reserve, 19,537 from the BEA and 6,712 from the
Census Bureau, plus smaller sources. On November 7, 2026, its latest date
was August 8, 2026, the free tier's 3-month lag.

It doesn't use FRED IDs. The legacy Cybersyn table we still have mounted
has a `FRED_SERIES_ID` column, but it's empty in all 167,190 rows, and the
current Snowflake Curated Data table drops the column. If your code or
colleagues use FRED IDs, you'd build that crosswalk yourself. [How to Get
FRED Data into Snowflake](https://fruitstand.dev/blog/fred-data-into-snowflake.md) compares the
listing with Snowflake's Data Utilities app and a FRED API pipeline, step by
step.

## Find a series in SQL

`fred_series_vw` has one row per series, with FRED's popularity score, so a
name search sorted by popularity finds the series most people use:

```sql theme={null}
select series_id, series_name, frequency_short, observation_end, popularity
from fred.fred_series_vw
where series_name ilike '%corporate bond%'
order by popularity desc nulls last
limit 6;
```

On November 7, 2026 that returned `BAA10Y`, `AAA10Y`, `HQMCB10YR`,
`BAA10YM`, `BAAFF` and `HQMCB10YRP`.

### The Sahm rule from UNRATE

The Sahm rule compares the 3-month average unemployment rate with its lowest
3-month average over the previous 12 months. A rise of 0.50 points or more
is the rule's recession signal:

```sql theme={null}
with u as (
    select date,
           avg(value) over (order by date rows between 2 preceding and current row) as unrate_3m
    from fred.fred_series_observations_vw
    where series_id = 'UNRATE'
),
s as (
    select date,
           unrate_3m,
           unrate_3m - min(unrate_3m) over (order by date rows between 12 preceding and 1 preceding) as sahm
    from u
)
select date, round(unrate_3m, 2) as unrate_3m, round(sahm, 2) as sahm, sahm >= 0.5 as triggered
from s
order by date desc
limit 6;
```

On November 7, 2026 the latest month, October 2026, came out at 0.00, with a
3-month average of 4.13%. Run on July 2024 instead, it returns 0.50, the
month the rule was widely reported to have triggered. This uses today's
revised unemployment rates. FRED's `SAHMREALTIME` uses each month's rate as
first published, which you can rebuild from
`fred_series_observations_vintages_vw`.

## Which should you choose?

* **You use FRED IDs, need many series, or need revisions:** the [FRED
  listing](https://app.snowflake.com/marketplace/listing/GZTYZ40XYNE).
* **You need a few core US indicators and can wait three months:** Snowflake
  Curated Data's free tier.
* **You need a handful of series, including licensed ones you have rights
  to:** the Data Utilities app with your own FRED API key.
* **You need the S\&P 500, ICE BofA or Case-Shiller series:** check ICE's
  own Marketplace listing, or license them from S\&P Dow Jones Indices or ICE.
  They aren't on the Marketplace as FRED series.

For other financial data on the Marketplace, see [What Financial Datasets
Are on the Snowflake Marketplace?](https://fruitstand.dev/blog/financial-datasets-snowflake-marketplace.md)
For FRED queries in practice, see [How to Get the US Treasury Yield Curve
in Snowflake](https://fruitstand.dev/blog/treasury-yield-curve-snowflake.md) and [How to Calculate
Inflation-Adjusted Returns in SQL](https://fruitstand.dev/blog/inflation-adjusted-returns-sql.md).

## F.A.Q.

> [accordion] Is FRED data on the Snowflake Marketplace?
>
> Yes. Fruit Stand's FRED listing has 573,411 FRED series by FRED ID, with every ALFRED vintage, refreshed daily. The St. Louis Fed doesn't publish its own listing.

> [accordion] Does the FRED listing include every FRED series?
>
> No. It leaves out 96,159 series from 47 licensed sources, such as S\&P Dow Jones Indices, ICE BofA indexes, Moody's and Zillow, because FRED's terms require the owner's permission to use them beyond personal use.

> [accordion] Is the S\&P 500 (SP500) in the FRED listing?
>
> No. SP500, DJIA and NASDAQCOM are licensed from their index owners. For S\&P 500 returns in Snowflake, use SPY's adjusted prices from a stock price listing.

> [accordion] Is there free FRED data on the Snowflake Marketplace?
>
> Not as FRED series. Snowflake Curated Data's free tier has 167,190 indicators from the same original publishers under its own IDs, three months behind. Snowflake's free Data Utilities app can download FRED series with your own API key.

> [accordion] Does the FRED listing have historical revisions?
>
> Yes. fred\_series\_observations\_vintages\_vw has 824.6 million rows: every published version of each observation, with realtime\_start and realtime\_end, for point-in-time analysis.

To query 573,411 FRED series by FRED ID, with every revision, start a free
30-day trial of the [FRED Series listing on the Snowflake
Marketplace](https://app.snowflake.com/marketplace/listing/GZTYZ40XYNE).
It's \$150/month after the trial. The schema is in the [dataset
docs](https://fruitstand.dev/datasets/fred-series.md). Questions? Reach out at
[contact@fruitstand.dev](mailto:contact@fruitstand.dev).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.