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: July 2, 2026, The Day in Numbers
Stocks NBBO update count: July 2 vs July 1, with named-ticker updates (millions)scalar · 2026-07-26 · 1×6597.22 The memory and storage names: change vs Wednesday's close, range timing, and dollar volumetable · 2026-07-26 · 4×10 Megacap rotation: change vs Wednesday's close, range timing, and dollar volumetable · 2026-07-26 · 4×10 July 2's corporate calendar and information flow, in one row (including the eight splits behind one fake screener move)scalar · 2026-07-26 · 1×20322 Advancers vs decliners among tickers with at least $1M traded on July 2scalar · 2026-07-26 · 1×113,398
Market Recap: July 1, 2026, The Day in Numbers
Volume leaders two ways: top 6 by dollars traded, top 4 by shares traded (one reused-symbol listing excluded pending entity verification)table · 2026-07-26 · 10×6 Session check: SPY's observed minute-bar spanscalar · 2026-07-26 · 1×6893 One row for the whole options day: volume, same-day expiry, put/call skew, and the busiest contractscalar · 2026-07-26 · 1×2111.22 The day's last twelve news articles tagging MU, SNDK, STX, WDC or META (one licensed feed)table · 2026-07-26 · 12×4 The biggest names going ex-dividend on July 1, ranked by the day's dollar volumetable · 2026-07-26 · 8×7 July 1's corporate calendar and information flow, in one rowscalar · 2026-07-26 · 1×14746 The volatility complex on July 1: VIX-futures ETFs vs Tuesday's close, with SPY as the anchortable · 2026-07-26 · 5×5 The Treasury curve, July 1 close vs June 30 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY's open-to-close move ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×40.09 The memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volumetable · 2026-07-26 · 8×9 The eleven S&P sector ETFs on July 1, best to worst vs Tuesday's closetable · 2026-07-26 · 11×7 SPY / QQQ / DIA / IWM: July 1 vs the June 30 close, regular hourstable · 2026-07-26 · 4×8 Every quarter-opening session since 2004: SPY's open-to-close move, with July 1 ranked inside itscalar · 2026-07-26 · 1×991 Advancers, decliners, and new quarterly highs vs lows among tickers with at least $1M traded on July 1scalar · 2026-07-26 · 1×122,928
Market Recap: June 30, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×3Preview: a 13-point series, ending higher. Volume leaders two ways: top 6 by dollars traded, top 4 by shares traded (one reused-symbol listing excluded pending entity verification)table · 2026-07-26 · 10×6 Session check: SPY's observed minute-bar spanscalar · 2026-07-26 · 1×5860 The six busiest option contracts of June 30, by contracts tradedseries · 2026-07-26 · 6×7Preview: a 6-point series, ending lower. One row for the whole options day: volume, same-day expiry, SPY's put/call skew by moneyness, the holiday-shifted weekscalar · 2026-07-26 · 1×2010.06 The news feed on June 30: article count and the day's last headline for each name in this recapseries · 2026-07-26 · 7×5Preview: a 7-point series, ending lower. The Treasury curve, June 30 close vs June 29 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY's open-to-close move ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×40.68 The semiconductor and storage names: change vs Monday's close, range, and dollar volumetable · 2026-07-26 · 6×10 The ten S&P sector funds on June 30: change vs Monday's close, and how far each sat behind the leadertable · 2026-07-26 · 10×7 SPY / QQQ / DIA / IWM: June 30 vs the June 29 close, regular hourstable · 2026-07-26 · 4×8 Q2 2026 end to end: each index ETF from the April 1 open to the June 30 close, regular hoursseries · 2026-07-26 · 4×7Preview: a 4-point series, ending lower. Top 5 gainers and top 5 decliners among names with $10M+ traded on June 30 (one reused-symbol listing excluded)table · 2026-07-26 · 10×8 Crypto-adjacent financials: change vs Monday's close, range, and dollar volumetable · 2026-07-26 · 4×10 June 30's corporate calendar and information flow, in one row (the filing-index gap on display)scalar · 2026-07-26 · 1×12704 Advancers vs decliners among tickers with at least $1M traded on June 30scalar · 2026-07-26 · 1×93,349
Market Recap: June 29, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×4Preview: a 13-point series, roughly flat. 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
Next week on the calendar: closures, ex-dividends, splits, and the expiry pull

Next week on the calendar: closures, ex-dividends, splits, and the expiry pull

most recentas of scalar 1×6read in context →
closures next week
0
ex dividends next week
934
household ex div next week
0
splits next week
26
jul31 expiry pct of friday volume
14.2
latest short interest settlement
2026-07-15
the exact SQL behind every number 
SELECT
    (SELECT count() FROM global_markets.stocks_market_holidays WHERE date >= '2026-07-27' AND date <= '2026-07-31' AND status != 'open') AS closures_next_week,
    (SELECT count() FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-27' AND ex_dividend_date <= '2026-07-31') AS ex_dividends_next_week,
    (SELECT countIf(ticker IN ('AAPL', 'MSFT', 'JPM', 'KO', 'JNJ', 'XOM', 'CVX', 'PG', 'WMT', 'HD')) FROM global_markets.stocks_dividends WHERE ex_dividend_date >= '2026-07-27' AND ex_dividend_date <= '2026-07-31') AS household_ex_div_next_week,
    (SELECT count() FROM global_markets.stocks_splits WHERE execution_date >= '2026-07-27' AND execution_date <= '2026-07-31') AS splits_next_week,
    (SELECT round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260731') / sum(size), 1) FROM global_markets.options_trades WHERE sip_timestamp >= '2026-07-24 00:00:00' AND sip_timestamp < '2026-07-25 00:00:00') AS jul31_expiry_pct_of_friday_volume,
    (SELECT toString(max(settlement_date)) FROM global_markets.stocks_short_interest WHERE settlement_date <= '2026-07-24') AS latest_short_interest_settlement
More from this analysisMarket Recap: Week of July 20, 2026
Session verification: sessions, bars, holiday rows, up and down closes, next closure scalar 1×9 → The week's corporate calendar: dividends, splits, listings, news scalar 1×9 → SPY's week in trailing-year context (open-to-close weekly returns) scalar 1×5 → Weekly breadth: July 24 regular close vs July 17 regular close, names with $5M+ traded during the week scalar 1×6 → See all 2,170 queries →
$