3,256 answered market questions

SELECT
    date,
    formatDateTime(date, '%b %e, %Y')                                                      AS date_label,
    round(max(toFloat64(yield_3_month)), 2)                                                AS three_month_yield,
    round(max(toFloat64(yield_10_year)), 2)                                                AS ten_year_yield,
    toInt32(round((max(toFloat64(yield_10_year)) - max(toFloat64(yield_3_month))) * 100))  AS spread_3m10y_bps,
    toInt32(round((max(toFloat64(yield_10_year)) - max(toFloat64(yield_2_year))) * 100))   AS spread_2s10s_bps
FROM global_markets.treasury_yields
WHERE date >= today() - 90
  AND yield_3_month > 0
  AND yield_2_year > 0
  AND yield_10_year > 0
GROUP BY date
ORDER BY date