Freddie Mac

Overview

Freddie Mac is a government-sponsored enterprise in the US that purchases and securitizes mortgages.

• House Price Index (HPI): Freddie Mac collects data on residential property sales and appraisals. Their index tracks price movements for both single-family homes and condominiums in the US.
• Primary Mortgage Market Survey (PMMS): Freddie Mac provides a weekly report on mortgage interest rates in the US. This tracks the borrowing costs for homebuyers and refinancers. The PMMS collects data on fixed-rate and adjustable-rate mortgage products, presenting averages for various loan terms.

Key Attributes

Geographic Coverage	United States
Entity Level	Primary Mortgage Market Survey (Mortgage Rates): US House Price Index: State
Time Granularity	Primary Mortgage Market Survey (Mortgage Rates): Weekly House Price Index: Monthly
Release Frequency	Primary Mortgage Market Survey (Mortgage Rates): Weekly House Price Index: Monthly
History	Primary Mortgage Market Survey (Mortgage Rates): 1971 House Price Index: 1975

Cybersyn Products

Tables above are available in the following Cybersyn data product:

• US Real Estate
• Cybersyn Foundations - PAID

Sample Queries

Compare 15-Year and 30-Year Fixed Rate Mortgage Rates since 2018.

Freddie Mac releases weekly average mortgage rates for the US in their Primary Mortgage Market Survey (PMMS).

SELECT
    ts.geo_id,
    att.variable_name,
    ts.date,
    ts.value,
    ts.unit,
    att.measure,
    att.frequency
FROM cybersyn.freddie_mac_housing_timeseries ts
LEFT JOIN cybersyn.freddie_mac_housing_attributes att
ON ts.variable = att.variable
WHERE 
    att.variable_name IN ('15-Year Fixed Rate Mortgage Rate, National Average','30-Year Fixed Rate Mortgage Rate, National Average')
    AND ts.geo_id = 'country/USA'
    AND YEAR(ts.date) >= 2018;

Disclaimers

The data in this product is sourced from Freddie Mac, see license.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact snowflake-public-data@snowflake.com for questions.