The 2s10s over the trailing six months, with the 2-year and 10-year moves that produced it

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
    week,
    week_label,
    y2_yield,
    y10_yield,
    spread_2s10s,
    y2_move_bp,
    y10_move_bp,
    multiIf(
        (y10_move_bp - y2_move_bp) <= 0,                        'no steepening over the window',
        y2_move_bp < 0 AND abs(y2_move_bp) >= abs(y10_move_bp), 'bull steepener (2-year fell most)',
        'bear steepener (10-year rose most)'
    ) AS steepening_type
FROM
(
    SELECT
        week,
        week_label,
        y2_yield,
        y10_yield,
        spread_2s10s,
        round((y2_yield  - first_value(y2_yield)  OVER (ORDER BY week ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)) * 100) AS y2_move_bp,
        round((y10_yield - first_value(y10_yield) OVER (ORDER BY week ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)) * 100) AS y10_move_bp
    FROM
    (
        SELECT
            toStartOfWeek(date, 1)                                                   AS week,
            formatDateTime(week, '%b %e')                                            AS week_label,
            round(argMax(ifNull(toFloat64(yield_2_year), 0.), date), 2)              AS y2_yield,
            round(argMax(ifNull(toFloat64(yield_10_year), 0.), date), 2)             AS y10_yield,
            round(argMax(ifNull(toFloat64(yield_10_year), 0.) - ifNull(toFloat64(yield_2_year), 0.), date), 2) AS spread_2s10s
        FROM global_markets.treasury_yields
        WHERE date >= today() - 182
          AND yield_2_year > 0 AND yield_10_year > 0
        GROUP BY week
    )
)
ORDER BY week