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: June 29, 2026, The Day in Numbers
Volume leaders two ways: top 6 by dollars traded, top 4 by shares tradedtable · 2026-07-26 · 10×6 The Treasury curve, June 29 close vs June 26 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. QQQ and SPY: June 29 ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×102.57 Session check: SPY's observed minute-bar span, and the Friday closure on the tapescalar · 2026-07-26 · 1×80 The eleven sector baskets: June 29 vs the June 26 close, regular hourstable · 2026-07-26 · 11×6 SPY / QQQ / DIA / IWM: June 29 vs the June 26 close, regular hourstable · 2026-07-26 · 4×9 What it cost to cross the spread: NBBO updates and median quoted width, regular hourstable · 2026-07-26 · 4×7 One row for the whole options day: volume, 0DTE, the holiday-shifted weekscalar · 2026-07-26 · 1×2011.04 The memory/storage names: change vs Friday's close and intraday rangetable · 2026-07-26 · 4×9 June 29's corporate calendar and information flow, in one rowscalar · 2026-07-26 · 1×22449 Advancers vs decliners among tickers with at least $1M traded on June 29scalar · 2026-07-26 · 1×93,968
page 3 of 3
Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closure

Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closure

most recentas of scalar 1×7read in context →
first spy bar et
04:00
last spy bar et
19:59
regular session bars
390
day sessions
1
jul30 holiday rows
0
next closure date
2026-09-07
next closure name
Labor Day
the exact SQL behind every number 
SELECT
    formatDateTime(min(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS first_spy_bar_et,
    formatDateTime(max(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS last_spy_bar_et,
    countIf(window_start >= '2026-07-30 13:30:00' AND window_start < '2026-07-30 20:00:00') AS regular_session_bars,
    uniqExactIf(toDate(toTimeZone(window_start, 'America/New_York')), window_start >= '2026-07-30 13:30:00' AND window_start < '2026-07-30 20:00:00') AS day_sessions,
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date = '2026-07-30') AS jul30_holiday_rows,
    (SELECT toString(min(date)) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-30' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_date,
    (SELECT argMin(name, date) FROM global_markets.stocks_market_holidays WHERE date > '2026-07-30' AND date <= '2026-12-31' AND status = 'closed') AS next_closure_name
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY' AND window_start >= '2026-07-30 00:00:00' AND window_start < '2026-07-31 00:00:00'
More from this analysisMarket Recap: July 30, 2026, The Day in Numbers
July 31 and August 3 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lag scalar 1×6 → Ex-dividends, splits, listings, news, and the July 30 SEC filing mix scalar 1×14 → SPY's median spread ranked against every July session, tightest first scalar 1×4 → Stocks NBBO update count: July 30 vs July 29, with named-ticker updates (millions) scalar 1×6 → See all 2,170 queries →
$