STRASMORE/EXPLORE 3,293 QUERIES

Three tenors through the 2022 hiking cycle, monthly averages

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-11-01, from What Is the 3m10y Spread? The Fed's Yield Curve.

as of series 42×5read in context →
Three tenors through the 2022 hiking cycle, monthly averages — 42 rows by 5 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labelthree_month_yieldtwo_year_yieldten_year_yield
2021-07-01Jul 20210.050.221.32
2021-08-01Aug 20210.050.221.28
2021-09-01Sep 20210.040.241.37
2021-10-01Oct 20210.050.391.58
2021-11-01Nov 20210.050.511.56
2021-12-01Dec 20210.060.681.47
2022-01-01Jan 20220.150.981.76
2022-02-01Feb 20220.311.441.93
2022-03-01Mar 20220.451.912.13
2022-04-01Apr 20220.762.542.75
2022-05-01May 20220.992.622.9
2022-06-01Jun 20221.5433.14
2022-07-01Jul 20222.33.042.9
2022-08-01Aug 20222.723.252.9
2022-09-01Sep 20223.223.863.52
2022-10-01Oct 20223.874.383.98
2022-11-01Nov 20224.324.53.89
2022-12-01Dec 20224.364.293.62
2023-01-01Jan 20234.694.213.53
2023-02-01Feb 20234.794.533.75
2023-03-01Mar 20234.864.33.66
2023-04-01Apr 20235.074.023.46
2023-05-01May 20235.314.133.57
2023-06-01Jun 20235.424.643.75
2023-07-01Jul 20235.494.833.9
2023-08-01Aug 20235.564.94.17
2023-09-01Sep 20235.565.024.38
2023-10-01Oct 20235.65.074.8
2023-11-01Nov 20235.524.884.5
2023-12-01Dec 20235.444.464.02
2024-01-01Jan 20245.454.324.06
2024-02-01Feb 20245.444.544.21
2024-03-01Mar 20245.474.594.21
2024-04-01Apr 20245.444.874.54
2024-05-01May 20245.454.864.48
2024-06-01Jun 20245.514.744.31
2024-07-01Jul 20245.434.54.25
2024-08-01Aug 20245.33.973.87
2024-09-01Sep 20244.923.623.72
2024-10-01Oct 20244.723.974.1
2024-11-01Nov 20244.624.264.36
2024-12-01Dec 20244.394.234.39
Rows × columns
42 × 5
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Three tenors through the 2022 hiking cycle, monthly averages, derived from the stored result.
ColumnTypeRangeNotes
month date 2021-07-01 to 2024-12-01
month_label text 42 distinct values (Apr 2022, Apr 2023, Apr 2024…)
three_month_yield number 0.04 to 5.6 ratio or rate
two_year_yield number 0.22 to 5.07 ratio or rate
ten_year_yield number 1.28 to 4.8 ratio or rate

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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
    toStartOfMonth(date)                          AS month,
    formatDateTime(month, '%b %Y')                AS month_label,
    round(avg(toFloat64(yield_3_month)), 2)       AS three_month_yield,
    round(avg(toFloat64(yield_2_year)), 2)        AS two_year_yield,
    round(avg(toFloat64(yield_10_year)), 2)       AS ten_year_yield
FROM global_markets.treasury_yields
WHERE date >= toDate('2021-07-01')
  AND date <  toDate('2025-01-01')
  AND yield_3_month > 0
  AND yield_2_year > 0
  AND yield_10_year > 0
GROUP BY month
ORDER BY month
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisWhat Is the 3m10y Spread? The Fed's Yield Curve
3m10y and 2s10s spreads, monthly averages over twenty years series 240×4 → 3-month and 10-year yields with both spreads, last 90 days series 62×6 → Every 3m10y inversion since 1985, on monthly averages series 9×6 → 2s10s versus 3m10y in three inversion windows, daily closes table 3×9 → The 2s10s spread by month, full history series 605×5 → The 2s10s over the trailing six months, with the 2-year and 10-year moves that produced it series 26×8 → See all 3,293 queries →