3,256 answered market questions

SELECT
    toString(toYear(date))                         AS year,
    countIf(spread_2s10s < 0)                      AS inverted_2s10s_session_count,
    countIf(spread_5s30s < 0)                      AS inverted_5s30s_session_count,
    countIf(spread_2s10s < 0 AND spread_5s30s > 0) AS split_session_count
FROM
(
    SELECT
        date,
        toFloat64(yield_30_year) - toFloat64(yield_5_year) AS spread_5s30s,
        toFloat64(yield_10_year) - toFloat64(yield_2_year) AS spread_2s10s
    FROM global_markets.treasury_yields
    WHERE date >= toStartOfYear(subtractYears(today(), 30))
      AND yield_2_year  > 0
      AND yield_5_year  > 0
      AND yield_10_year > 0
      AND yield_30_year > 0
)
GROUP BY year
HAVING inverted_2s10s_session_count > 0 OR inverted_5s30s_session_count > 0
ORDER BY year