STRASMORE/EXPLORE 3,293 QUERIES

bill_trend

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-10-16, from capital-market-vs-money-market.

as of series 26×4read in context →
bill_trend — 26 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labeltbill_3m_pctnote_10y_pct
2024-09-01Sep 20244.773.73
2024-10-01Oct 20244.724.1
2024-11-01Nov 20244.624.36
2024-12-01Dec 20244.394.39
2025-01-01Jan 20254.344.63
2025-02-01Feb 20254.334.45
2025-03-01Mar 20254.344.28
2025-04-01Apr 20254.324.28
2025-05-01May 20254.364.42
2025-06-01Jun 20254.424.38
2025-07-01Jul 20254.414.39
2025-08-01Aug 20254.34.26
2025-09-01Sep 20254.074.12
2025-10-01Oct 20253.984.06
2025-11-01Nov 20253.944.09
2025-12-01Dec 20253.684.14
2026-01-01Jan 20263.674.21
2026-02-01Feb 20263.694.13
2026-03-01Mar 20263.724.25
2026-04-01Apr 20263.74.32
2026-05-01May 20263.694.48
2026-06-01Jun 20263.814.47
2026-07-01Jul 20263.874.6
2026-08-01Aug 20263.884.68
2026-09-01Sep 20264.094.99
2026-10-01Oct 20264.235.25
Rows × columns
26 × 4
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 bill_trend, derived from the stored result.
ColumnTypeRangeNotes
month date 2024-09-01 to 2026-10-01
month_label text 26 distinct values (Apr 2025, Apr 2026, Aug 2025…)
tbill_3m_pct number 3.67 to 4.77 percent
note_10y_pct number 3.73 to 5.25 percent

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
    toString(toStartOfMonth(date))                AS month,
    formatDateTime(toStartOfMonth(date), '%b %Y') AS month_label,
    round(avg(toFloat64(yield_3_month)), 2)       AS tbill_3m_pct,
    round(avg(toFloat64(yield_10_year)), 2)       AS note_10y_pct
FROM global_markets.treasury_yields
WHERE date >= today() - 760
  AND yield_3_month > 0
  AND yield_10_year > 0
GROUP BY month, month_label
ORDER BY month
⌘/Ctrl + Enter

Use dis data for your AI assistant

E go open ready to query, with dis page data. Free, no account.