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 9, 2026, The Day in Numbers
Named catalysts on file: news articles and SEC filings per name, Wednesday's close through Thursday'stable · 2026-07-26 · 9×5 Receipts: July 9 green/red counts across the fourteen names, and NVDA's two-day turnscalar · 2026-07-26 · 1×612 Fourteen chip names: gap at the open vs the rest of the day, July 9table · 2026-07-26 · 14×8 Liquid-tape breadth: July 9 advancer share vs July 8, $1M-traded filterscalar · 2026-07-26 · 1×84,263
Market Recap: July 8, 2026, The Day in Numbers
Shares per 30-minute ET bucket, regular hours, with % of the day's biggest bucketseries · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. Top 6 by dollars traded, top 4 by shares traded: July 8 regular hourstable · 2026-07-26 · 10×6 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×8919 SPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. Ex-divs, splits, SEC filings, news attentionscalar · 2026-07-26 · 1×1381 Treasury yields: July 8 vs July 7, populated maturities + 2s10sranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY / QQQ day move in trailing context (close-over-close, ~22 sessions)scalar · 2026-07-26 · 1×70.25 SPY's RTH average quoted spread in trailing-month contextscalar · 2026-07-26 · 1×72.202 SPY / QQQ / DIA / IWM: July 8 vs the July 7 close, regular hourstable · 2026-07-26 · 4×10 Rotation check: eight names, defensives, mega-caps, biotechtable · 2026-07-26 · 8×8 Stocks NBBO update count: July 8 vs July 7, with named-ticker updates (millions)scalar · 2026-07-26 · 1×8530.55 Options NBBO tape: total updates vs the stock tape, plus the SPY root slicescalar · 2026-07-26 · 1×39.62 Options tape: prints, contracts, call %, 0DTE share vs Tuesday, top contractscalar · 2026-07-26 · 1×1410.44 Receipts: July 8 and July 7 green/red counts across the same fourteen namesscalar · 2026-07-26 · 1×612 Fourteen chip names: prior close, day close, day range, dollar volume, low/high minute ETtable · 2026-07-26 · 14×10 Liquid-tape breadth: July 8 advancer share vs July 7, $1M-traded filterscalar · 2026-07-26 · 1×81,821
Market Recap: July 7, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. 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×5 SPY's option quotes on July 7: the whole root, and the near-the-money same-day touch through the air pocket against a midday controlscalar · 2026-07-26 · 1×13327.55 Session check: SPY's observed minute-bar span, the holiday table, and the next closure on the calendarscalar · 2026-07-26 · 1×8902 The touch through the air pocket: median quoted spread and quote rate, 10:36–10:48 ET vs a midday control (12 minutes each)table · 2026-07-26 · 10×9 One row for the whole options day: volume, call share, 0DTE, and the two contracts that bracketed SPY's closescalar · 2026-07-26 · 1×2410.6 July 7's corporate calendar and information flow, in one rowscalar · 2026-07-26 · 1×1580 The treasury curve: July 7 vs the July 6 print (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. QQQ and SPY: July 7 ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×7-1.82 SPY's update-weighted average quoted spread: July 7 ranked against the trailing month (rank 1 = tightest)scalar · 2026-07-26 · 1×71.809 SPY / QQQ / DIA / IWM: July 7 vs the July 6 close, regular hourstable · 2026-07-26 · 4×10 What rose while chips fell: and the day's loudest single printtable · 2026-07-26 · 8×8 The whole equity NBBO stream: July 7 vs July 6 update countsscalar · 2026-07-26 · 1×5492.76 The options NBBO stream: July 7 against July 6, and against the same session's equity quotesscalar · 2026-07-26 · 1×68.69B The chip complex on July 7: change vs Monday's close, range timing, and dollar volumetable · 2026-07-26 · 14×10 Advancers vs decliners among tickers with at least $1M traded on July 7scalar · 2026-07-26 · 1×72,091
Market Recap: July 6, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. 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×5 Session check: SPY's observed minute-bar span, the July 3 closure, and the next one on the calendarscalar · 2026-07-26 · 1×8917 The eleven sector ETFs: July 6 vs the July 2 close, split into gap and intradaytable · 2026-07-26 · 11×6 The touch at the gap open: median quoted spread and quote rate, 9:30–9:42 ET vs a midday control (12 minutes each)table · 2026-07-26 · 10×9 One row for the whole options day: volume, call share, and the Monday same-day expiryscalar · 2026-07-26 · 1×1610.53 Every split executed July 6, with its unadjusted close before and after (splits with no regular-session tape on both sides are dropped)table · 2026-07-26 · 12×7 The treasury curve: July 6 vs the July 2 print (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.34 SPY's update-weighted average quoted spread: July 6 ranked against the trailing month (rank 1 = tightest)scalar · 2026-07-26 · 1×71.815 SPY / QQQ / DIA / IWM: July 6 vs the July 2 close, regular hourstable · 2026-07-26 · 4×10 The whole equity NBBO stream: July 6 vs the July 2 session, and where Monday's quotes clusteredscalar · 2026-07-26 · 1×6391.96 The memory and storage names: change vs Thursday's close, range timing, and dollar volumetable · 2026-07-26 · 4×10 Megacap rotation: change vs Thursday's close, range timing, and dollar volumetable · 2026-07-26 · 4×10 July 6's corporate calendar and information flow, in one row (including the reverse-split wall behind a screener trap)scalar · 2026-07-26 · 1×12119 Advancers vs decliners among tickers with at least $1M traded on July 6scalar · 2026-07-26 · 1×73,861
Market Recap: July 2, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×3Preview: a 13-point series, roughly flat. 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 span, and the July 3 closure on the tapescalar · 2026-07-26 · 1×6886 Median quoted spread in basis points, regular hours: index ETFs, megacaps, and the memory namestable · 2026-07-26 · 8×6 One row for the whole options day: volume, same-day expiry, the holiday-shifted week, and the July monthlyscalar · 2026-07-26 · 1×1913.15 After the holiday: the next session, its ex-dividends and splits, the next scheduled closure, and the short-interest lagscalar · 2026-07-26 · 1×9390 The session's curve print: July 2 vs July 1 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. The receipt: the July 2 treasury print is on filescalar · 2026-07-26 · 1×21 SPY and QQQ ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×7-0.35 Was liquidity unusual? SPY's regular-hours median spread vs the trailing month of sessionsscalar · 2026-07-26 · 1×60.27 The eleven SPDR sector ETFs: July 2 close vs July 1 close, regular hourstable · 2026-07-26 · 11×6 SPY / QQQ / DIA / IWM: July 2 vs the July 1 close, regular hourstable · 2026-07-26 · 4×8 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.
page 2 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 →
$