Freddie Mac

Federal Home Loan Mortgage Corporation

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

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Tables	Sources
FREDDIE_MAC_HOUSING_ATTRIBUTES FREDDIE_MAC_HOUSING_TIMESERIES	Primary Mortgage Market Survey (PMMS) House Price Index

Cybersyn Products

Tables above are available in the following Cybersyn data product:

• US Real Estate

• Enterprise

Examples & 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 [e-mail] for questions.