Skip to main content

Financial & Economic Indicators

Overview​

Snowflake combines frequently monitored financial & economic indicators from various public publishing sources into two tables for enhanced usability. The aggregate data features financial & economic metrics such as:

  • PCE Price Index
  • CPI
  • GDP
  • Interest rates
  • FX rates
  • Weekly jobless claims, local area unemployment
  • New home sales and new residential construction
  • State and metro area employment, hours, earnings
  • Commercial paper
  • Advance monthly sales for retail and food services
  • Advance U.S. international trade in goods

Central bank monetary policy rates from Brazil, Canada, England, Mexico, and Japan are also included for ease of comparison with the Federal Funds Effective Rate.

Key Attributes​

Geographic CoverageGlobal, though US focused
Entity Level

Country, State, County, City, Census Region, Census Division, Census Metropolitan Division, CBSA

Time GranularityDaily, Weekly, Monthly, Quarterly, Annually
Release FrequencyVaries by variable and underlying source
HistoryVaries by variable and underlying source

Snowflake Products​

Tables above are available in our free and Snowflake Data Foundations - PAID products.

Sample Queries​

Track Core PCE for Federal Reserve Policy Analysis​

Monitor the Fed's preferred inflation measure to understand monetary policy decisions.

SELECT 
    date,
    value as core_pce_index,
    variable_name
FROM public_data.financial_economic_indicators_timeseries
WHERE variable = 'BEA_NIPA_PCE_2.8.4_DPCCRG_M_SA'
ORDER BY date DESC
LIMIT 12;  -- Last 12 months

Calculate Year-over-Year PCE Inflation Rate​

Calculate the annual inflation rate based on Core PCE.

WITH pce_data AS (
    SELECT 
        date,
        value as pce_index
    FROM public_data.financial_economic_indicators_timeseries
    WHERE variable = 'BEA_NIPA_PCE_2.8.4_DPCCRG_M_SA'
)
SELECT 
    curr.date,
    curr.pce_index,
    prior.pce_index as prior_year_index,
    ((curr.pce_index - prior.pce_index) / prior.pce_index * 100) as yoy_inflation_rate
FROM pce_data curr
JOIN pce_data prior 
    ON prior.date = DATEADD('year', -1, curr.date)
ORDER BY curr.date DESC
LIMIT 12;

Evaluate monthly retail sales by industry, provided by the US Census Bureau​

Find the industries that are growing / declining in the US.

SELECT
    ts.geo_id,
    att.release_source,
    att.industry,
    ts.date,
    ts.value,
    ts.unit,
    att.seasonally_adjusted,
    att.measurement_type
FROM public_data.financial_economic_indicators_timeseries ts
JOIN public_data.financial_economic_indicators_attributes att
USING (variable)
WHERE
    att.release_source = 'US Census Bureau'
    AND att.release_name = 'Monthly State Retail Sales'
    AND ts.geo_id = 'country/USA'
ORDER BY ts.date, ts.variable_name;

Disclaimers​

The data in this product is sourced on the individual source pages. Snowflake is not endorsed by or affiliated with any of these providers. Contact https://snowforce.my.site.com/s/consumer-reporting for questions.