NorthStarCanada–U.S. macro intelligence

Data refreshed Sep 25, 2026, 10:49 a.m. ET

How NorthStar works

Where the numbers come from, how they are transformed, what the models do, and where their limits are. Data last refreshed Sep 25, 2026, 10:49 a.m. ET.

Data sources

SourceWhatFrequencyTypical lag
Bank of Canada Valet APIPolicy rate, benchmark and Real Return Bond yields, CAD/USD, CPI-trim/median/common, commodity price index (BCPI)Daily / monthly1–2 days
Statistics Canada (WDS vector API)CPI, Labour Force Survey (incl. wages), IPPI, retail trade, GDP, merchandise trade, M1+/M2++, prime and 5-year mortgage ratesWeekly / monthly / quarterly3–8 weeks
FRED, St. Louis Fed (official API)U.S. GDP, jobs, JOLTS, claims, CPI, PCE, breakevens, rates, credit spreads, NFCI, loan-officer survey, housing, orders, sentiment, trade, broad dollar, WTI, OECD leading indicatorsDaily / monthly / quarterly1 day to 3 months
Yahoo Finance (yfinance)Canadian iShares and U.S. Select Sector SPDR ETF pricesDaily1 day

Pipeline and refresh

A GitHub Actions job runs at 10:00 ET every weekday, after the 8:30 ET statistical releases. It ingests all sources, builds a DuckDB warehouse in three layers (raw, clean, marts), exports JSON and Parquet files, and commits them. The commit triggers a new Vercel deployment, so every page is pre-rendered with the latest data. The run stops before deploying if any source fails or if a data-quality check fails (missing series, duplicate rows, data older than 120 days), so the site keeps showing the last good data instead of a broken update.

Transformations

Models

Model outputs are refreshed by re-running the Colab notebook, not daily. The date of the last run appears on the Forecast & scenarios page.

Ask the data

The assistant sends your question and a data dictionary to Claude, which writes one SQL query. The query runs in an in-memory DuckDB database holding only the dashboard's tables, with file, network and settings access switched off. Only single read-only SELECT statements are accepted, results are capped at 1,000 rows, and a second model call summarizes the rows it returned. The SQL is always shown so answers can be checked.

Limitations

Series catalog

Every series on the dashboard, generated from the live data.

SectionSeriesCountryShown asFrequencyLatest
OutputIndustrial capacity utilization (ca_capacity_util)Canada%QuarterlyQ4 2025
OutputReal GDP all industries (monthly) (ca_gdp_monthly)Canada% y/yMonthlyJun 2026
OutputReal GDP per person aged 15+ (ca_gdp_per_capita)Canada% y/yQuarterlyQ2 2026
OutputReal GDP (expenditure) (ca_gdp_quarterly)Canada% q/q ann.QuarterlyQ2 2026
OutputReal GDP (expenditure) (ca_gdp_yoy)Canada% y/yQuarterlyQ2 2026
OutputIndustrial production (GDP basis) (ca_industrial_production)Canada% y/yMonthlyJun 2026
OutputSahm-rule indicator (ca_sahm)CanadappMonthlyAug 2026
OutputCapacity utilization (total industry) (us_capacity_util)U.S.%MonthlyAug 2026
OutputReal GDP (us_gdp)U.S.% q/q ann.QuarterlyQ2 2026
OutputReal GDP per person aged 16+ (us_gdp_per_capita)U.S.% y/yQuarterlyQ2 2026
OutputReal GDP (us_gdp_yoy)U.S.% y/yQuarterlyQ2 2026
OutputIndustrial production (us_industrial_production)U.S.% y/yMonthlyAug 2026
OutputSmoothed recession probability (us_recession_prob)U.S.%MonthlyJul 2026
OutputSahm-rule indicator (us_sahm)U.S.ppMonthlyAug 2026
LabourAverage hourly wages (LFS) (ca_avg_hourly_wages)Canada% y/yMonthlyAug 2026
LabourEI initial and renewal claims (monthly) (ca_ei_claims)CanadapersonsMonthlyJul 2026
LabourEmployment (LFS) (ca_employment)Canadathousands m/m chgMonthlyAug 2026
LabourJob vacancies per unemployed person (ca_openings_per_unemployed)CanadaratioMonthlyJul 2026
LabourParticipation rate (LFS) (ca_participation)Canada%MonthlyAug 2026
LabourReal wage growth (wages minus CPI) (ca_real_wage_growth)Canada% y/yMonthlyAug 2026
LabourUnemployment rate (LFS) (ca_unemployment)Canada%MonthlyAug 2026
LabourAverage hourly earnings (us_avg_hourly_earnings)U.S.% y/yMonthlyAug 2026
LabourInitial jobless claims (weekly avg) (us_initial_claims)U.S.personsWeeklySep 2026
LabourNonfarm payrolls (us_nonfarm_payrolls)U.S.thousands m/m chgMonthlyAug 2026
LabourJob openings per unemployed person (us_openings_per_unemployed)U.S.ratioMonthlyJul 2026
LabourParticipation rate (us_participation_rate)U.S.%MonthlyAug 2026
LabourQuits rate (JOLTS) (us_quits_rate)U.S.%MonthlyJul 2026
LabourReal wage growth (earnings minus CPI) (us_real_wage_growth)U.S.% y/yMonthlyAug 2026
LabourUnemployment rate (us_unemployment)U.S.%MonthlyAug 2026
PricesLong-term breakeven (nominal minus RRB yield) (ca_breakeven_long)Canada%DailySep 2026
PricesCPI excluding food & energy (ca_core_cpi_3m)Canada% 3m ann.MonthlyAug 2026
PricesHeadline CPI (ca_cpi_all_items)Canada% y/yMonthlyAug 2026
PricesIndustrial product price index (ca_ippi_total)Canada% y/yMonthlyAug 2026
PricesCPI-common (BoC core) (cpi_common)Canada% y/yMonthlyAug 2026
PricesCPI-median (BoC core) (cpi_median)Canada% y/yMonthlyAug 2026
PricesCPI-trim (BoC core) (cpi_trim)Canada% y/yMonthlyAug 2026
Prices5-year 5-year forward inflation expectation (us_5y5y)U.S.%DailySep 2026
Prices10-year breakeven inflation (us_breakeven_10y)U.S.%DailySep 2026
PricesCore CPI ex food & energy (us_core_cpi)U.S.% y/yMonthlyAug 2026
PricesCore CPI (us_core_cpi_3m)U.S.% 3m ann.MonthlyAug 2026
PricesCore PCE price index (us_core_pce)U.S.% y/yMonthlyJul 2026
PricesCore PCE (us_core_pce_3m)U.S.% 3m ann.MonthlyJul 2026
PricesHeadline CPI (us_cpi)U.S.% y/yMonthlyAug 2026
PricesWTI crude oil (wti_crude_yoy)U.S.% y/yDailySep 2026
Central banksBusiness loan balances (banks) (ca_business_credit)Canada% y/yMonthlyJun 2026
Central banksConsumer credit balances (banks) (ca_consumer_credit)Canada% y/yMonthlyJun 2026
Central banks5-year conventional mortgage rate (posted) (ca_mortgage_5y)Canada%WeeklySep 2026
Central banksResidential mortgage balances (banks) (ca_mortgage_credit)Canada% y/yMonthlyJun 2026
Central banksPrime minus overnight rate (ca_prime_margin)CanadappDailySep 2026
Central banksReal policy rate (overnight minus CPI-trim) (ca_real_policy_rate)Canada%MonthlyAug 2026
Central banks10y minus 2y spread (ca_spread_10_2)CanadappDailySep 2026
Central banksVariable-rate share of new mortgage lending (ca_variable_mortgage_share)Canada%MonthlyJun 2026
Central banksM1+ (gross) (m1_gross)Canada% y/yMonthlyJul 2026
Central banksM2++ (gross) (m2pp_gross)Canada% y/yMonthlyJul 2026
Central banksBoC target overnight rate (overnight_rate)Canada%DailySep 2026
Central banksPrime rate (prime_rate)Canada%WeeklySep 2026
Central banksGoC 10-year yield (yield_10yr)Canada%DailySep 2026
Central banksGoC 2-year yield (yield_2yr)Canada%DailySep 2026
Central banksGoC 5-year yield (yield_5yr)Canada%DailySep 2026
Central banksBaa corporate minus 10-year Treasury (us_baa_spread)U.S.ppDailySep 2026
Central banksCommercial & industrial loans (banks) (us_ci_loans)U.S.% y/yMonthlyAug 2026
Central banksConsumer loans (banks) (us_consumer_loans)U.S.% y/yMonthlyAug 2026
Central banksEffective fed funds rate (us_fed_funds)U.S.%MonthlyAug 2026
Central banksM2 money stock (us_m2)U.S.% y/yMonthlyAug 2026
Central banks30-year fixed mortgage rate (us_mortgage_30y)U.S.%WeeklySep 2026
Central banksChicago Fed financial conditions (NFCI) (us_nfci)U.S.indexWeeklySep 2026
Central banksReal estate loans (banks) (us_re_loans)U.S.% y/yMonthlyAug 2026
Central banksReal policy rate (fed funds minus core PCE) (us_real_policy_rate)U.S.%MonthlyJul 2026
Central banksBanks tightening business-loan standards (us_sloos_ci)U.S.net %QuarterlyQ3 2026
Central banks10y minus 2y spread (us_spread_10_2)U.S.ppMonthlyAug 2026
Central banksTreasury 10-year yield (us_yield_10yr)U.S.%MonthlyAug 2026
Central banksTreasury 2-year yield (us_yield_2yr)U.S.%MonthlyAug 2026
SentimentOECD leading indicator (ca_cli_yoy)Canada% y/yMonthlyAug 2026
SentimentExpected inflation next 12 months (BoC CSCE) (ca_consumer_infl_exp)Canada%QuarterlyQ2 2026
SentimentHousing starts (CMHC) (ca_housing_starts)Canadathousands SAARMonthlyAug 2026
SentimentManufacturing new orders (ca_mfg_new_orders)Canada% y/yMonthlyJul 2026
SentimentReal retail sales (deflated by CPI) (ca_real_retail_sales)Canada% y/yMonthlyJul 2026
SentimentRetail sales (ca_retail_sales)Canada% y/yMonthlyJul 2026
SentimentOECD composite leading indicator (canada_oecd_cli)CanadaindexMonthlyAug 2026
SentimentBuilding permits (us_building_permits)U.S.thousands SAARMonthlyAug 2026
SentimentOECD leading indicator (us_cli_yoy)U.S.% y/yMonthlyAug 2026
SentimentExpected inflation next 12 months (UMich) (us_consumer_infl_exp)U.S.%MonthlyJul 2026
SentimentUMich consumer sentiment (us_consumer_sentiment)U.S.indexMonthlyJul 2026
SentimentCore capital goods orders (us_core_capex_orders)U.S.% y/yMonthlyAug 2026
SentimentHousing starts (us_housing_starts)U.S.thousands SAARMonthlyAug 2026
SentimentOECD composite leading indicator (us_oecd_cli)U.S.indexMonthlyAug 2026
SentimentReal retail & food services sales (us_real_retail_sales)U.S.% y/yMonthlyAug 2026
SentimentRetail & food services sales (us_retail_sales)U.S.% y/yMonthlyAug 2026
Trade & FXBCPI energy (bcpi_energy)Canada% y/yMonthlyAug 2026
Trade & FXBCPI excluding energy (bcpi_ex_energy)Canada% y/yMonthlyAug 2026
Trade & FXBoC commodity price index (BCPI) (bcpi_total)Canada% y/yMonthlyAug 2026
Trade & FXMerchandise exports (ca_exports)Canada% y/yMonthlyJul 2026
Trade & FXMerchandise exports to non-U.S. markets (ca_exports_non_us)Canada% y/yMonthlyJul 2026
Trade & FXMerchandise exports to U.S. (ca_exports_to_us)Canada% y/yMonthlyJul 2026
Trade & FXMerchandise imports (ca_imports)Canada% y/yMonthlyJul 2026
Trade & FXMerchandise trade balance (ca_trade_balance)Canadamn CADMonthlyJul 2026
Trade & FXCanada minus U.S. 2-year yield (ca_us_2y_spread)CanadappMonthlyAug 2026
Trade & FXShare of exports going to the U.S. (ca_us_export_share)Canada%MonthlyJul 2026
Trade & FXCAD–oil correlation (12 months) (cad_oil_corr_12m)CanadacorrDailySep 2026
Trade & FXCAD–oil correlation (36 months) (cad_oil_corr_36m)CanadacorrDailySep 2026
Trade & FXCAD/USD exchange rate (cad_usd_combined)CanadaUSD per CADDailySep 2026
Trade & FXBroad trade-weighted U.S. dollar (us_broad_dollar)U.S.indexDailySep 2026
Trade & FXGoods & services trade balance (us_trade_balance)U.S.mn USDMonthlyJul 2026
Trade & FXWTI crude oil (wti_crude)U.S.USD/bblDailySep 2026