STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

T-Bill Maturities and How Yields Are Quoted
A nine-month estimate, interpolated between the 3-month and 1-year pointsseries · 2026-10-07 · 26×5Preview: a 16-point series, ending higher. Front-end yields by horizon: 13-week bill, 1-year point, 2-year noteseries · 2026-10-07 · 26×6Preview: a 16-point series, ending higher. The published short end of the Treasury curve, April to September 2026table · 2026-10-07 · 3×6 The same bill on both conventions: coupon equivalent versus discount basistable · 2026-10-07 · 2×5
What Is the Term Premium in Bond Yields?
Ten year inflation expectations: market implied against model basedseries · 2026-10-05 · 18×5Preview: a 16-point series, ending lower. The 10 year yield split into implied inflation and an implied real yieldseries · 2026-10-05 · 18×5Preview: a 16-point series, ending higher. Month over month change in the 3 month bill and the 10 year, in basis pointsseries · 2026-10-05 · 26×4Preview: a 16-point series, ending higher. The 5 year, the 10 year, and the implied 5y5y forward rateseries · 2026-10-05 · 26×5Preview: a 16-point series, ending higher. The Treasury curve now and a year ago, by maturitytable · 2026-10-05 · 6×3
Gold vs Real Interest Rates: Does It Hold?
Five pinned episodes: real-yield move, GLD return, and the daily correlation inside eachtable · 2026-10-05 · 5×5 Rolling 12-month correlation: daily GLD returns vs daily changes in the 10-year real yieldtable · 2026-10-05 · 76×4 The 10-year real yield, built from the nominal yield and the breakeventable · 2026-10-05 · 80×5 GLD implied volatility by month, near-the-money contracts with 20 to 45 days to expiryseries · 2026-10-05 · 25×4Preview: a 16-point series, ending higher.
What Is the 5s30s Spread? 20 Years of Data
Inverted sessions per year: 2s10s, 5s30s, and the split stateranking · 2026-10-04 · 9×4Preview: 9 ranked values, smallest first. The 5s30s spread month by month, with both legsseries · 2026-10-04 · 241×4Preview: a 16-point series, ending higher. Which leg moved: 5-year and 30-year travel inside each inversionranking · 2026-10-04 · 14×4Preview: 14 ranked values, smallest first. Every 5s30s inversion of at least five sessions, last 30 yearstable · 2026-10-04 · 14×5 5s30s and 2s10s, monthly averages over 20 yearsseries · 2026-10-04 · 241×3Preview: a 16-point series, ending higher.
What Is the 3m10y Spread? The Fed's Yield Curve
3-month and 10-year yields with both spreads, last 90 daysseries · 2026-10-04 · 63×6Preview: a 16-point series, ending higher. 3m10y and 2s10s spreads, monthly averages over twenty yearsseries · 2026-10-04 · 241×4Preview: a 16-point series, ending higher. Every 3m10y inversion since 1985, on monthly averagesseries · 2026-10-04 · 9×6Preview: a 9-point series, roughly flat. Three tenors through the 2022 hiking cycle, monthly averagesseries · 2026-10-04 · 42×5Preview: a 16-point series, ending higher. 2s10s versus 3m10y in three inversion windows, daily closestable · 2026-10-04 · 3×9
What Is the 2s10s Spread? Yield Curve Data
The 2s10s spread as of the latest close (10-year minus 2-year)scalar · 2026-10-04 · 1×54.78 2s10s spread, monthly average: last 20 yearsseries · 2026-10-04 · 240×2Preview: a 16-point series, ending higher. 2s10s inversion episodes: first close, last close, length, and depthranking · 2026-10-04 · 11×4Preview: 11 ranked values, smallest first. US Treasury yield curve: latest available yield per maturityranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first.
What Happens When the Yield Curve Un-Inverts
Which leg did the work: 2-year and 10-year moves over the 91 days before each crossingtable · 2026-10-04 · 7×9 SPY's change from the crossing-day close, 3, 6 and 12 months after each un-inversiontable · 2026-10-04 · 2×5 The 2s10s spread by month, full historyseries · 2026-10-04 · 605×5Preview: a 16-point series, ending lower. The 2s10s over the trailing six months, with the 2-year and 10-year moves that produced itseries · 2026-10-04 · 26×8Preview: a 16-point series, ending higher. Every 2s10s un-inversion: the crossing and the spread 3, 6 and 12 months latertable · 2026-10-04 · 7×8
On-the-Run vs Off-the-Run Treasuries
Average yield step between benchmark tenors, trailing four monthsranking · 2026-10-04 · 2×3Preview: 2 ranked values, smallest first. 2-year and 10-year constant maturity yields, month by monthseries · 2026-10-04 · 24×5Preview: a 16-point series, ending higher. Typical one-day move in the 10-year yield, by monthseries · 2026-10-04 · 23×4Preview: a 16-point series, ending lower. The Treasury constant maturity curve, latest published sessionranking · 2026-10-04 · 10×3Preview: 10 ranked values, smallest first.
Treasury Yield Curve, H1 2026: Twist, Not Shift
The rank receipt: H1 2026's twist against every prior half, by absolute sizescalar · 2026-07-26 · 1×642 Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s printtable · 2026-07-26 · 100×7 The 30-year's half: start, end, the first and last 5% prints, time spent at or above 5%, and the highscalar · 2026-07-26 · 1×84.86 The 2s10s spread, every print of the halftable · 2026-07-26 · 124×2 The 2s10s slope receipt: start, end, minimum (with its date), maximum, and print countscalar · 2026-07-26 · 1×672 The H1 2026 move per maturity, split into quarters: the hump sits squarely on the 2-yearranking · 2026-07-26 · 7×4Preview: 7 ranked values, largest first. Seven maturities, three single-day snapshots: the half's first print, the last March print, and the last June printranking · 2026-07-26 · 7×4Preview: 7 ranked values, smallest first.
A nine-month estimate, interpolated between the 3-month and 1-year points

A nine-month estimate, interpolated between the 3-month and 1-year points

most recentas of series 26×5read in context →
A nine-month estimate, interpolated between the 3-month and 1-year points — 26 rows by 5 columns, computed from US exchange, SIP and OPRA data.
weekweek_labelbill_3m_pctinterp_9m_pctbill_1y_pct
2026-03-30Mar 303.73.73.69
2026-04-06Apr 63.73.73.69
2026-04-13Apr 133.713.693.69
2026-04-20Apr 203.693.683.68
2026-04-27Apr 273.683.713.72
2026-05-04May 43.693.743.76
2026-05-11May 113.693.763.8
2026-05-18May 183.673.773.82
2026-05-25May 253.693.763.8
2026-06-01Jun 13.783.823.84
2026-06-08Jun 83.793.843.87
2026-06-15Jun 153.813.883.91
2026-06-22Jun 223.843.943.99
2026-06-29Jun 293.853.943.98
2026-07-06Jul 63.863.974.03
2026-07-13Jul 133.853.964.02
2026-07-20Jul 203.914.044.1
2026-07-27Jul 273.874.014.08
2026-08-03Aug 33.893.994.04
2026-08-10Aug 103.883.964
2026-08-17Aug 173.873.964
2026-08-24Aug 243.863.994.05
2026-08-31Aug 313.914.074.15
2026-09-07Sep 73.994.154.24
2026-09-14Sep 144.124.314.41
2026-09-21Sep 214.24.384.48
the exact SQL behind every number
SELECT
    toString(toMonday(date))                AS week,
    formatDateTime(toMonday(date), '%b %e') AS week_label,
    round(avg(toFloat64(yield_3_month)), 2) AS bill_3m_pct,
    round(avg(
        toFloat64(yield_3_month)
        + (toFloat64(yield_1_year) - toFloat64(yield_3_month)) * (273 - 91) / (365 - 91)
    ), 2)                                   AS interp_9m_pct,
    round(avg(toFloat64(yield_1_year)), 2)  AS bill_1y_pct
FROM global_markets.treasury_yields
WHERE date >= '2026-04-01'
  AND date <  '2026-09-26'
  AND yield_3_month > 0
  AND yield_1_year  > 0
GROUP BY week, week_label
ORDER BY week
$