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: Q2 2026
62 sessions in the quarter, verified from the tape, month by monthscalar · 2026-07-16 · 1×462 The 2s10s spread and the 10-year through Q2, dailytable · 2026-07-16 · 63×3 SPY median quoted spread on one labeled sample session per month of the quarter (second Wednesdays)series · 2026-07-16 · 3×4Preview: a 3-point series, ending higher. SPY sessions up vs down across the quarter, one cheap receiptscalar · 2026-07-16 · 1×436 June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,477.9 May: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,394.6 April: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,386.9 Q2 month by month: April, May, June (SPY and QQQ, recomputed identically)ranking · 2026-07-16 · 6×4Preview: 6 ranked values, largest first. Q2 regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-16 · 8×3Preview: 8 ranked values, largest first. Listings, splits, and ex-dividend events by month through the quarterranking · 2026-07-16 · 3×4Preview: 3 ranked values, smallest first. Q2's corporate calendar (the June 30 filing-index gap disclosed)scalar · 2026-07-16 · 1×615,402 Q2 2026 returns for the four index ETFs, with Q1 recomputed live for contrastranking · 2026-07-16 · 4×4Preview: 4 ranked values, smallest first. The rank receipts: this quarter against every prior second quarter (rank 1 = best; self-excluded)table · 2026-07-16 · 2×6 Every second quarter on the tape: SPY and QQQ, recomputed identically by year (session counts shown)table · 2026-07-16 · 40×4
62 sessions in the quarter, verified from the tape, month by month

62 sessions in the quarter, verified from the tape, month by month

most recentas of scalar 1×4read in context →
q2 sessions
62
april sessions
21
may sessions
20
june sessions
21
the exact SQL behind every number 
SELECT
    (SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-04-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')) AS q2_sessions,
    (SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-04-01 00:00:00') AND window_start < toDateTime('2026-05-01 00:00:00')) AS april_sessions,
    (SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-05-01 00:00:00') AND window_start < toDateTime('2026-06-01 00:00:00')) AS may_sessions,
    (SELECT uniqExact(toDate(toTimeZone(window_start, 'America/New_York'))) FROM global_markets.delayed_stocks_minute_aggs
     WHERE ticker = 'SPY' AND window_start >= toDateTime('2026-06-01 00:00:00') AND window_start < toDateTime('2026-07-01 00:00:00')) AS june_sessions
More from this analysisMarket Recap: Q2 2026
SPY sessions up vs down across the quarter, one cheap receipt scalar 1×4 → 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 →
$