STRASMORE/EXPLORE 2,749 QUERIES

curve_compare

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-09-28, from what-is-the-5s30s-spread.

as of series 241×3read in context →
curve_compare — 241 rows by 3 columns, computed from US exchange, SIP and OPRA data.
monthspread_5s30s_bpsspread_2s10s_bps
2006-0918-5
2006-1017-7
2006-1110-15
2006-1215-11
2007-0110-12
2007-0211-13
2007-0324-1
2007-04273
2007-0523-2
2007-061812
2007-072219
2007-085036
2007-095951
2007-105856
2007-118581
2007-1210498
2008-01135127
2008-02174176
2008-03191189
2008-04160163
2008-05144143
2008-06120133
2008-07127143
2008-08136147
2008-09138161
2008-10145220
2008-11171231
2008-12135160
2009-01153171
2009-02172189
2009-03183189
2009-04190200
2009-05209236
2009-06181254
2009-07194254
2009-08180247
2009-09182245
2009-10186244
2009-11208260
2009-12215272
2010-01212280
2010-02226283
2010-03221277
2010-04211279
2010-05211259
2010-06213248
2010-07223239
2010-08234218
2010-09236217
2010-10269216
2010-11284231
2010-12248267
2011-01253278
2011-02239280
2011-03240272
2011-04233272
2011-05245261
2011-06265259
2011-07273260
2011-08263207
2011-09228176
2011-10207187
2011-11211176
2011-12209172
2012-01219173
2012-02228169
2012-03226183
2012-04229176
2012-05217152
2012-06199133
2012-07197128
2012-08206141
2012-09221147
2012-10219147
2012-11214139
2012-12219146
2013-01228165
2013-02232172
2013-03234170
2013-04222153
2013-05227168
2013-06220197
2013-07220224
2013-08224238
2013-09219241
2013-10231228
2013-11243241
2013-12231256
2014-01212246
2014-02215238
2014-03198232
2014-04182229
2014-05180217
2014-06174215
2014-07163204
2014-08157195
2014-09149197
2014-10149186
2014-11142180
2014-12119157
2015-01108133
2015-02109136
2015-03111140
2015-04123140
2015-05142159
2015-06143167
2015-07143166
2015-08131147
2015-09146146
2015-10150143
2015-11136138
2015-12127126
2016-01134119
2016-02140105
2016-03131101
2016-04137104
2016-0513399
2016-0612991
2016-0711683
2016-0811382
2016-0911786
2016-1012392
2016-11127116
2016-12115130
2017-01110123
2017-02113122
2017-03107117
2017-04112106
2017-05112100
2017-0610284
2017-0710195
2017-0810287
2017-099882
2017-109081
2017-117566
2017-125956
2018-015055
2018-025368
2018-034657
2018-043748
2018-053247
2018-062738
2018-072328
2018-082725
2018-092624
2018-103429
2018-114126
2018-124116
2019-015017
2019-025417
2019-036016
2019-046119
2019-056319
2019-067526
2019-077422
2019-08636
2019-09595
2019-106716
2019-116420
2019-126225
2020-016524
2020-026517
2020-038642
2020-048843
2020-0510450
2020-0611554
2020-0710348
2020-0810951
2020-0911554
2020-1012364
2020-1112370
2020-1212880
2021-0113895
2021-02150114
2021-03152146
2021-04144147
2021-05150147
2021-06132132
2021-07118110
2021-08114107
2021-09107113
2021-1095119
2021-1173105
2021-126279
2022-015678
2022-024350
2022-033022
2022-04321
2022-051928
2022-06615
2022-0714-14
2022-0810-35
2022-09-14-34
2022-10-14-39
2022-11-6-61
2022-12-11-67
2023-012-68
2023-02-14-79
2023-03-5-64
2023-0415-56
2023-0526-56
2023-06-8-89
2023-07-18-93
2023-08-3-73
2023-09-1-64
2023-1017-27
2023-1117-38
2023-1214-44
2024-0127-26
2024-0219-34
2024-0316-38
2024-0410-33
2024-0512-37
2024-0613-43
2024-0730-25
2024-0844-9
2024-095510
2024-104612
2024-113110
2024-123317
2025-014236
2025-024024
2025-035531
2025-048050
2025-058850
2025-069349
2025-079751
2025-0810856
2025-0910855
2025-109954
2025-1110354
2025-1211064
2026-0110668
2026-0210865
2026-0310053
2026-049752
2026-058949
2026-067436
2026-077738
2026-088447
2026-095733
Rows × columns
241 × 3
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 curve_compare, derived from the stored result.
ColumnTypeRangeNotes
month text 241 distinct values (2006-09, 2006-10, 2006-11…)
spread_5s30s_bps number -18 to 284
spread_2s10s_bps number -93 to 283

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
    formatDateTime(toStartOfMonth(date), '%Y-%m')                           AS month,
    round(avg(toFloat64(yield_30_year) - toFloat64(yield_5_year)) * 100, 0) AS spread_5s30s_bps,
    round(avg(toFloat64(yield_10_year) - toFloat64(yield_2_year)) * 100, 0) AS spread_2s10s_bps
FROM global_markets.treasury_yields
WHERE date >= toStartOfMonth(subtractYears(today(), 20))
  AND yield_2_year  > 0
  AND yield_5_year  > 0
  AND yield_10_year > 0
  AND yield_30_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-5s30s-spread
monthly_history series 241×4 → long_end ranking 14×4 → inversions table 14×5 → split_years ranking 9×4 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → See all 2,749 queries →