Freddie Mac

Federal Home Loan Mortgage Corporation


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

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.


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

Cybersyn Products

Tables above are available in the following Cybersyn data product:

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).

FROM cybersyn.freddie_mac_housing_timeseries ts
LEFT JOIN cybersyn.freddie_mac_housing_attributes att
ON ts.variable = att.variable
    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( >= 2018;


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 for questions.

Last updated

Copyright © 2024 Cybersyn