2,173 answered market questions

SELECT formatDateTime(toStartOfMonth(date), '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(toStartOfMonth(date), 'MMMM yyyy') AS month_label,
       round(avg(yield_3_month), 2) AS bill_3m_pct,
       round(avg(yield_10_year), 2) AS treasury_10y_pct
FROM global_markets.treasury_yields
WHERE date BETWEEN toDate('2024-07-01') AND toDate('2026-06-30')
  AND yield_3_month IS NOT NULL
  AND yield_10_year IS NOT NULL
GROUP BY month, month_label
ORDER BY month