The 10 year yield split into implied inflation and an implied real yield

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(y.month)                     AS month,
    formatDateTime(y.month, '%b %Y')      AS month_label,
    round(y.nominal, 2)                   AS nominal_10y_pct,
    round(i.expected_inflation, 2)        AS inflation_10y_pct,
    round(y.nominal - i.expected_inflation, 2) AS real_10y_pct
FROM
(
    SELECT
        toStartOfMonth(date)          AS month,
        avg(toFloat64(yield_10_year)) AS nominal
    FROM global_markets.treasury_yields
    WHERE date >= today() - 760 AND yield_10_year > 0
    GROUP BY month
) AS y
INNER JOIN
(
    SELECT
        toStartOfMonth(date)            AS month,
        avg(toFloat64(market_10_year))  AS expected_inflation
    FROM global_markets.inflation_expectations
    WHERE date >= today() - 760 AND market_10_year > 0
    GROUP BY month
) AS i USING (month)
ORDER BY month