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

Market Recap: H1 2026
Slope receipts: start, end, minimum, the spread never inverted this halfscalar · 2026-07-26 · 1×472 123 sessions in the half, verified from the tapescalar · 2026-07-26 · 1×1123 Median quoted spread by sector ETF, one representative session (June 29, 2026), regular hoursranking · 2026-07-26 · 11×4Preview: 11 ranked values, smallest first. The eleven sector ETFs: H1 2026 return, Q1 and Q2 split, and H1 dollar volumetable · 2026-07-26 · 11×5 Q2 regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,477.9 May: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,394.6 April: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,386.9 March: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,442.6 February: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,262.3 January: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,316.1 SPY median quoted spread on one labeled sample session per month (second Wednesdays), every NBBO updateseries · 2026-07-26 · 6×4Preview: a 6-point series, ending higher. SPY sessions up vs down across the half, one cheap receiptscalar · 2026-07-26 · 1×464 H1 2026: half, Q1, and Q2 returns for the four index ETFs, computed in one querytable · 2026-07-26 · 4×5 The leader set's half and Q2 returns plus half dollar volume: one ticker-filtered queryranking · 2026-07-26 · 6×4Preview: 6 ranked values, largest first. The half, month by month (SPY and QQQ, recomputed identically in one query)ranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. New listings per month across the halfranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. The 2s10s spread, every print of the halftable · 2026-07-26 · 124×2 Seven maturities: yield at the start of the half vs the end, and the changeranking · 2026-07-26 · 7×4Preview: 7 ranked values, smallest first. H1 2026's corporate calendar (all three month-end filing-index gaps disclosed)scalar · 2026-07-26 · 1×728,356 The rank receipts: DIA and IWM against every prior first half (rank 1 = best; self-excluded)table · 2026-07-26 · 2×6 The rank receipts: this half against every prior one (SPY and QQQ; rank 1 = best; self-excluded)table · 2026-07-26 · 2×6 Every first half on the tape: DIA and IWM, same arithmetictable · 2026-07-26 · 46×4 Every first half on the tape: SPY and QQQ, recomputed identically by year (per-year session counts shown)table · 2026-07-26 · 39×4
Slope receipts: start, end, minimum, the spread never inverted this half

Slope receipts: start, end, minimum, the spread never inverted this half

most recentas of scalar 1×4read in context →
start bp
72
end bp
30
min bp
27
prints
124
the exact SQL behind every number 
SELECT
    round((argMin(yield_10_year - yield_2_year, date)) * 100, 0) AS start_bp,
    round((argMax(yield_10_year - yield_2_year, date)) * 100, 0) AS end_bp,
    round(min((yield_10_year - yield_2_year)) * 100, 0) AS min_bp,
    count() AS prints
FROM global_markets.treasury_yields
WHERE date >= toDate('2026-01-01') AND date <= toDate('2026-06-30')
  AND isNotNull(yield_10_year) AND isNotNull(yield_2_year)
More from this analysisMarket Recap: H1 2026
123 sessions in the half, verified from the tape scalar 1×1 → June: whole-tape options contract volume and same-day-expiry share (one scan) scalar 1×3 → May: whole-tape options contract volume and same-day-expiry share (one scan) scalar 1×3 → April: whole-tape options contract volume and same-day-expiry share (one scan) scalar 1×3 → See all 2,170 queries →
$