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

3,171 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
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
$