STRASMORE/EXPLORE 2,433 QUERIES

bucket_series

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-09-20, from how-treasury-buybacks-work.

as of series 76×4read in context →
bucket_series — 76 rows by 4 columns, computed from US exchange, SIP and OPRA data.
dateas_of_labelyield_2y_pctyield_10y_pct
2026-06-01June 1, 20264.054.47
2026-06-02June 2, 20264.054.46
2026-06-03June 3, 20264.084.49
2026-06-04June 4, 20264.054.47
2026-06-05June 5, 20264.174.55
2026-06-08June 8, 20264.154.56
2026-06-09June 9, 20264.134.53
2026-06-10June 10, 20264.134.55
2026-06-11June 11, 20264.054.45
2026-06-12June 12, 20264.094.48
2026-06-15June 15, 20264.074.47
2026-06-16June 16, 20264.054.43
2026-06-17June 17, 20264.24.49
2026-06-18June 18, 20264.194.46
2026-06-22June 22, 20264.244.51
2026-06-23June 23, 20264.164.5
2026-06-24June 24, 20264.114.41
2026-06-25June 25, 20264.094.4
2026-06-26June 26, 20264.074.38
2026-06-29June 29, 20264.14.38
2026-06-30June 30, 20264.144.44
2026-07-01July 1, 20264.174.48
2026-07-02July 2, 20264.144.49
2026-07-06July 6, 20264.134.48
2026-07-07July 7, 20264.194.55
2026-07-08July 8, 20264.214.56
2026-07-09July 9, 20264.164.54
2026-07-10July 10, 20264.214.56
2026-07-13July 13, 20264.264.62
2026-07-14July 14, 20264.184.58
2026-07-15July 15, 20264.134.55
2026-07-16July 16, 20264.164.57
2026-07-17July 17, 20264.184.55
2026-07-20July 20, 20264.214.6
2026-07-21July 21, 20264.264.63
2026-07-22July 22, 20264.314.67
2026-07-23July 23, 20264.374.71
2026-07-24July 24, 20264.334.69
2026-07-27July 27, 20264.314.65
2026-07-28July 28, 20264.264.61
2026-07-29July 29, 20264.224.67
2026-07-30July 30, 20264.234.68
2026-07-31July 31, 20264.284.75
2026-08-03August 3, 20264.254.7
2026-08-04August 4, 20264.24.63
2026-08-05August 5, 20264.184.63
2026-08-06August 6, 20264.254.69
2026-08-07August 7, 20264.194.65
2026-08-10August 10, 20264.254.72
2026-08-11August 11, 20264.224.7
2026-08-12August 12, 20264.24.68
2026-08-13August 13, 20264.154.63
2026-08-14August 14, 20264.174.68
2026-08-17August 17, 20264.194.72
2026-08-18August 18, 20264.194.71
2026-08-19August 19, 20264.194.65
2026-08-20August 20, 20264.194.69
2026-08-21August 21, 20264.244.74
2026-08-24August 24, 20264.244.7
2026-08-25August 25, 20264.174.64
2026-08-26August 26, 20264.194.66
2026-08-27August 27, 20264.24.67
2026-08-28August 28, 20264.344.73
2026-08-31August 31, 20264.344.75
2026-09-01September 1, 20264.394.79
2026-09-02September 2, 20264.394.79
2026-09-03September 3, 20264.344.77
2026-09-04September 4, 20264.374.78
2026-09-08September 8, 20264.394.8
2026-09-09September 9, 20264.434.83
2026-09-10September 10, 20264.564.95
2026-09-11September 11, 20264.634.96
2026-09-14September 14, 20264.654.97
2026-09-15September 15, 20264.675
2026-09-16September 16, 20264.745.01
2026-09-17September 17, 20264.674.94
Rows × columns
76 × 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 bucket_series, derived from the stored result.
ColumnTypeRangeNotes
date date 2026-06-01 to 2026-09-17
as_of_label text 76 distinct values
yield_2y_pct number 4.05 to 4.74 percent
yield_10y_pct number 4.38 to 5.01 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
    date,
    concat(monthName(date), ' ', toString(toDayOfMonth(date)), ', ', toString(toYear(date))) AS as_of_label,
    round(toFloat64(max(yield_2_year)), 2)  AS yield_2y_pct,
    round(toFloat64(max(yield_10_year)), 2) AS yield_10y_pct
FROM global_markets.treasury_yields
WHERE date >= '2026-06-01'
  AND date <= '2026-09-18'
  AND isNotNull(yield_2_year)
  AND isNotNull(yield_10_year)
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter
More from this analysishow-treasury-buybacks-work
curve_by_bucket ranking 7×3 The 2s10s spread by month, full history series 604×5 One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 3m10y and 2s10s spreads, monthly averages over twenty years series 241×4 2s10s spread, monthly average: last 20 years series 240×2 Rolling seven-year returns on SPY, one window per start month series 193×5 See all 2,433 queries →