STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

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

Where to Park Idle Cash
The pickup for extending: extra yield over the 1-month bill, in basis pointsseries · 2026-08-22 · 126×3Preview: a 16-point series, ending higher. The short end over the last 180 days: 1-month, 3-month and 1-year bill yieldsseries · 2026-08-22 · 126×5Preview: a 16-point series, ending higher. The current Treasury yield curve: what every maturity pays right nowranking · 2026-08-22 · 7×2Preview: 7 ranked values, smallest first.
Macro Picture Entering H2 2026, With Receipts
SPY month by month in H1 2026: regular-hours open-to-close return per monthranking · 2026-08-11 · 6×4Preview: 6 ranked values, smallest first. The labor market, monthly: unemployment, participation, average hourly earnings, with ingest receiptstable · 2026-08-11 · 6×5 Model-based inflation expectations by horizon, monthlyranking · 2026-08-11 · 6×4Preview: 6 ranked values, smallest first. The Treasury curve at each month-end of H1 2026: bill, 2-year, 10-year, and the spreads between themtable · 2026-08-11 · 6×8 CPI year-over-year, computed from the index against the same month a year earliertable · 2026-08-11 · 6×5 CPI month-over-month, computed from the index against the prior monthranking · 2026-08-11 · 6×3Preview: 6 ranked values, largest first. The as-of receipts: every June print on file, the July CPI column armed as the next tripwirescalar · 2026-08-11 · 1×51
The pickup for extending: extra yield over the 1-month bill, in basis points

The pickup for extending: extra yield over the 1-month bill, in basis points

most recentas of series 126×3read in context →
The pickup for extending: extra yield over the 1-month bill, in basis points — 126 rows by 3 columns, computed from US exchange, SIP and OPRA data.
dateten_year_pickup_bpstwo_year_pickup_bps
2026-02-2331-29
2026-02-2432-29
2026-02-2534-26
2026-02-2628-32
2026-02-2723-36
2026-03-0231-27
2026-03-0331-24
2026-03-0434-21
2026-03-0538-18
2026-03-0640-19
2026-03-0937-19
2026-03-1040-18
2026-03-1146-11
2026-03-12510
2026-03-1353-2
2026-03-1648-7
2026-03-1746-6
2026-03-18533
2026-03-19526
2026-03-206615
2026-03-236110
2026-03-246516
2026-03-256011
2026-03-266822
2026-03-277014
2026-03-30618
2026-03-31565
2026-04-01597
2026-04-02597
2026-04-036413
2026-04-066212
2026-04-076513
2026-04-086212
2026-04-096312
2026-04-106414
2026-04-13619
2026-04-14555
2026-04-15574
2026-04-16639
2026-04-17572
2026-04-20573
2026-04-216311
2026-04-226211
2026-04-236514
2026-04-24629
2026-04-27658
2026-04-286816
2026-04-297424
2026-04-306816
2026-05-016817
2026-05-047424
2026-05-057323
2026-05-066617
2026-05-076920
2026-05-086719
2026-05-117124
2026-05-127529
2026-05-137527
2026-05-147528
2026-05-158838
2026-05-189238
2026-05-1910147
2026-05-209239
2026-05-218536
2026-05-228441
2026-05-267829
2026-05-277628
2026-05-287327
2026-05-297326
2026-06-017533
2026-06-027433
2026-06-037837
2026-06-047634
2026-06-058446
2026-06-088645
2026-06-098444
2026-06-108644
2026-06-117636
2026-06-127940
2026-06-157838
2026-06-167638
2026-06-178152
2026-06-187750
2026-06-228558
2026-06-238551
2026-06-247545
2026-06-257039
2026-06-266837
2026-06-296739
2026-06-307444
2026-07-018150
2026-07-027944
2026-07-067944
2026-07-078650
2026-07-088954
2026-07-098244
2026-07-108550
2026-07-138953
2026-07-148545
2026-07-158240
2026-07-168140
2026-07-178245
2026-07-208849
2026-07-218851
2026-07-229155
2026-07-238955
2026-07-248953
2026-07-278551
2026-07-288550
2026-07-299449
2026-07-308944
2026-07-319750
2026-08-039146
2026-08-048542
2026-08-058641
2026-08-068945
2026-08-078640
2026-08-109346
2026-08-119143
2026-08-129042
2026-08-138436
2026-08-148938
2026-08-179340
2026-08-189341
2026-08-198842
2026-08-208939
the exact SQL behind every number
SELECT date,
       round((yield_10_year - yield_1_month) * 100, 0) AS ten_year_pickup_bps,
       round((yield_2_year - yield_1_month) * 100, 0) AS two_year_pickup_bps
FROM global_markets.treasury_yields
WHERE date >= (SELECT max(date) FROM global_markets.treasury_yields) - 180
  AND yield_1_month IS NOT NULL
ORDER BY date
$