Month over month change in the 3 month bill and the 10 year, in basis points

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(mo)                           AS month,
    formatDateTime(mo, '%b %Y')            AS month_label,
    round((bill_3m - prior_bill) * 100, 1) AS front_end_delta_bp,
    round((ten_yr - prior_ten) * 100, 1)   AS ten_year_delta_bp
FROM
(
    SELECT
        mo,
        bill_3m,
        ten_yr,
        lagInFrame(bill_3m) OVER (ORDER BY mo ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_bill,
        lagInFrame(ten_yr)  OVER (ORDER BY mo ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_ten
    FROM
    (
        SELECT
            toStartOfMonth(date)          AS mo,
            avg(toFloat64(yield_3_month)) AS bill_3m,
            avg(toFloat64(yield_10_year)) AS ten_yr
        FROM global_markets.treasury_yields
        WHERE date >= today() - 790 AND yield_10_year > 0
        GROUP BY mo
    )
)
WHERE prior_bill > 0
ORDER BY mo