STRASMORE/EXPLORE 3,293 QUERIES

Average yield step between benchmark tenors, trailing four months

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-07, from On-the-Run vs Off-the-Run Treasuries.

as of ranking 2×3read in context →
Average yield step between benchmark tenors, trailing four months — 2 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tenor_pairavg_gap_bpsabs_bps_per_year
2-year to 10-year39.34.9
10-year to 30-year43.32.2
Rows × columns
2 × 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 Average yield step between benchmark tenors, trailing four months, derived from the stored result.
ColumnTypeRangeNotes
tenor_pair text 2 distinct values (10-year to 30-year, 2-year to 10-year)
avg_gap_bps number 39.3 to 43.3
abs_bps_per_year number 2.2 to 4.9

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
    tenor_pair,
    round(avg(gap_pct) * 100, 1)                   AS avg_gap_bps,
    round(abs(avg(gap_pct)) * 100 / max(years), 1) AS abs_bps_per_year
FROM
(
    SELECT
        step.1 AS tenor_pair,
        step.2 AS gap_pct,
        step.3 AS years,
        step.4 AS step_order
    FROM
    (
        SELECT arrayJoin([
            ('2-year to 10-year',  toFloat64(yield_10_year) - toFloat64(yield_2_year),   8.0, 1),
            ('10-year to 30-year', toFloat64(yield_30_year) - toFloat64(yield_10_year), 20.0, 2)
        ]) AS step
        FROM global_markets.treasury_yields
        WHERE date >= today() - 120
          AND yield_2_year > 0
          AND yield_10_year > 0
          AND yield_30_year > 0
    )
)
GROUP BY tenor_pair
HAVING count() > 0
ORDER BY max(step_order)
⌘/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 analysisOn-the-Run vs Off-the-Run Treasuries
The Treasury constant maturity curve, latest published session ranking 10×3 → 2-year and 10-year constant maturity yields, month by month series 24×5 → Typical one-day move in the 10-year yield, by month series 23×4 → 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 2s10s spread, every print of the half table 124×2 → See all 3,293 queries →