inversions

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.

WITH daily AS
(
    SELECT
        date,
        toFloat64(yield_30_year) - toFloat64(yield_5_year) AS spread
    FROM global_markets.treasury_yields
    WHERE date >= subtractYears(today(), 30)
      AND yield_5_year  > 0
      AND yield_30_year > 0
),
islands AS
(
    SELECT
        date,
        spread,
        row_number() OVER (ORDER BY date)
            - row_number() OVER (PARTITION BY spread < 0 ORDER BY date) AS island
    FROM daily
)
SELECT
    formatDateTime(min(date), '%b %e, %Y') AS started,
    formatDateTime(max(date), '%b %e, %Y') AS ended,
    count()                                AS session_count,
    round(min(spread) * 100, 0)            AS deepest_spread_bps,
    round(avg(spread) * 100, 0)            AS average_spread_bps
FROM islands
WHERE spread < 0
GROUP BY island
HAVING session_count >= 5
ORDER BY min(date)