STRASMORE/EXPLORE 2,170 QUERIES

Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print

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-07-26, from Treasury Yield Curve, H1 2026: Twist, Not Shift.

as of table 100×7read in context →
Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print — 100 rows by 7 columns, computed from US exchange, SIP and OPRA data.
period_starthalfprintschange_2y_bpchange_10y_bptwist_bpmin_2s10s_bp
1976-07-011976 H2125-168-107-6185
1977-01-011977 H1126663630106
1977-07-011977 H2123110446632
1978-01-011978 H112412479459
1978-07-011978 H21241545698-86
1979-01-011979 H1124-103-37-66-82
1979-07-011979 H212423015773-169
1980-01-011980 H1125-242-41-201-241
1980-07-011980 H2125405230175-170
1981-01-011981 H112415614412-170
1981-07-011981 H2125-131-6-125-155
1982-01-011982 H1124792554-71
1982-07-011982 H2125-512-404-108-24
1983-01-011983 H112694643052
1983-07-011983 H21246889-2164
1984-01-011984 H11252301983252
1984-07-011984 H2124-315-232-8320
1985-01-011985 H1123-136-1459106
1985-07-011985 H2125-68-11951100
1986-01-011986 H1124-121-1694842
1986-07-011986 H2126-45-14-3156
1987-01-011987 H1124118120-275
1987-07-011987 H21263347-1483
1988-01-011988 H112525-12680
1988-07-011988 H21251163779-3
1989-01-011989 H1125-113-1130-45
1989-07-011989 H2125-15-161-20
1990-01-011990 H11253749-12-14
1990-07-011990 H2125-110-35-7517
1991-01-011991 H1124-1827-4585
1991-07-011991 H2126-220-155-65127
1992-01-011992 H1125636-30175
1992-07-011992 H2126-26-4014201
1993-01-011993 H1124-45-8035171
1993-07-011993 H212626323138
1994-01-011994 H112418914247112
1994-07-011994 H2125150501009
1995-01-011995 H1125-194-167-2715
1995-07-011995 H2125-61-63230
1996-01-011996 H112693113-2041
1996-07-011996 H2126-27-31445
1997-01-011997 H112411-31435
1997-07-011997 H2126-36-70343
1998-01-011998 H1124-10-2313-7
1998-07-011998 H2126-92-79-13-4
1999-01-011999 H112595112-175
1999-07-011999 H21266660612
2000-01-012000 H11260-5555-52
2000-07-012000 H2125-120-88-32-49
2001-01-012001 H1125-6250-1125
2001-07-012001 H2123-114-30-84111
2002-01-012002 H1124-32-342163
2002-07-012002 H2126-127-102-25176
2003-01-012003 H1124-48-535196
2003-07-012003 H21265471-17226
2004-01-012004 H1124762452187
2004-07-012004 H212644-3377112
2005-01-012005 H112556-298528
2005-07-012005 H2125653332-2
2006-01-012006 H112582784-16
2006-07-012006 H2125-35-449-19
2007-01-012007 H1126735-28-15
2007-07-012007 H2125-181-96-8514
2008-01-012008 H1125-258-33103
2008-07-012008 H2126-187-176-11127
2009-01-012009 H112423107-84150
2009-07-012009 H2126930-21231
2010-01-012010 H1125-48-8840236
2010-07-012010 H2126-234-36199
2011-01-012011 H1125-16-182252
2011-07-012011 H2125-25-133108152
2012-01-012012 H11266-3036122
2012-07-012012 H2124-517-22121
2013-01-012013 H1124966-57146
2013-07-012013 H2126454-50214
2014-01-012014 H11248-4755206
2014-07-012014 H212620-4161146
2015-01-012015 H1125-223-25119
2015-07-012015 H212637-1653119
2016-01-012016 H1125-44-753185
2016-07-012016 H21256199-3876
2017-01-012017 H112516-143078
2017-07-012017 H21254854351
2018-01-012018 H112560392131
2018-07-012018 H2124-9-18911
2019-01-012019 H1124-75-66-913
2019-07-012019 H2126-20-11-9-4
2020-01-012020 H1125-142-122-2012
2020-07-012020 H2126-424-2841
2021-01-012021 H11251452-3882
2021-07-012021 H21264844472
2022-01-012022 H112421413579-5
2022-07-012022 H212515710057-84
2023-01-012023 H112547245-107
2023-07-012023 H2125-712-73-108
2024-01-012024 H11243841-3-47
2024-07-012024 H2126-5210-62-35
2025-01-012025 H1123-53-33-2020
2025-07-012025 H2126-31-8-2343
2026-01-012026 H112467254227
Rows × columns
100 × 7
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 Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print, derived from the stored result.
ColumnTypeRangeNotes
period_start date 1976-07-01 to 2026-01-01
half text 100 distinct values (1976 H2, 1977 H1, 1977 H2…)
prints number 123 to 126
change_2y_bp number -512 to 405
change_10y_bp number -404 to 230
twist_bp number -201 to 175
min_2s10s_bp number -241 to 252

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.

the exact SQL behind every number
SELECT concat(toString(toYear(date)), if(toMonth(date) <= 6, '-01-01', '-07-01')) AS period_start,
       concat(toString(toYear(date)), if(toMonth(date) <= 6, ' H1', ' H2')) AS half,
       count() AS prints,
       round((argMax(yield_2_year, date) - argMin(yield_2_year, date)) * 100, 0) AS change_2y_bp,
       round((argMax(yield_10_year, date) - argMin(yield_10_year, date)) * 100, 0) AS change_10y_bp,
       round((argMax(yield_2_year, date) - argMin(yield_2_year, date)) * 100
           - (argMax(yield_10_year, date) - argMin(yield_10_year, date)) * 100, 0) AS twist_bp,
       round(min(yield_10_year - yield_2_year) * 100, 0) AS min_2s10s_bp
FROM global_markets.treasury_yields
WHERE date >= toDate('1976-07-01') AND date <= toDate('2026-06-30')
  AND isNotNull(yield_2_year) AND isNotNull(yield_10_year)
GROUP BY period_start, half
HAVING prints >= 100
ORDER BY period_start ASC

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisTreasury Yield Curve, H1 2026: Twist, Not Shift
The 2s10s spread, every print of the half table 124×2 The H1 2026 move per maturity, split into quarters: the hump sits squarely on the 2-year ranking 7×4 Seven maturities, three single-day snapshots: the half's first print, the last March print, and the last June print ranking 7×4 The rank receipt: H1 2026's twist against every prior half, by absolute size scalar 1×6 The 30-year's half: start, end, the first and last 5% prints, time spent at or above 5%, and the high scalar 1×8 The 2s10s slope receipt: start, end, minimum (with its date), maximum, and print count scalar 1×6 See all 2,170 queries →