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 30, 2026, The Day in Numbers
Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-02 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 30table · 2026-08-02 · 7×5 July 31 and August 3 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-02 · 1×60 Ex-dividends, splits, listings, news, and the July 30 SEC filing mixscalar · 2026-08-02 · 1×14200 Treasury curve prints on file, July 27 through July 30series · 2026-08-02 · 4×5Preview: a 4-point series, ending higher. SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-02 · 1×40.27 Stocks NBBO update count: July 30 vs July 29, with named-ticker updates (millions)scalar · 2026-08-02 · 1×6560.75 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 30scalar · 2026-08-02 · 1×310.32 Top 6 by dollars traded, top 4 by shares traded: July 30 regular hourstable · 2026-08-01 · 10×5 SPY day move in trailing context (open-to-close, June 30 through July 30)scalar · 2026-08-01 · 1×40.77 Sector ETFs, July 30 close vs July 29 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 30 vs the July 29 close, regular hourstable · 2026-08-01 · 4×10 Options tape: contracts, call share, same-day share vs Wednesday, busiest SPY contractscalar · 2026-08-01 · 1×1210.93 Eight mega-caps: change vs July 29 and regular-hours dollars, July 30table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 30 close vs July 29 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 30 close vs July 29 close, $1M-traded filterscalar · 2026-08-01 · 1×63,782
Market Recap: July 29, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 29 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 29table · 2026-08-01 · 7×5 July 30 and 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 29 SEC filing mixscalar · 2026-08-01 · 1×1485 Treasury curve prints on file, July 24 through July 29series · 2026-08-01 · 4×5Preview: a 4-point series, ending higher. SPY day move in trailing context (open-to-close, June 29 through July 29)scalar · 2026-08-01 · 1×4-1.41 SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 29 close vs July 28 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 29 vs the July 28 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 29 vs July 28, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6722.65 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 29scalar · 2026-08-01 · 1×313.55 Options tape: contracts, call share, same-day share vs Tuesday, busiest SPY contractscalar · 2026-08-01 · 1×1211.03 Eight mega-caps: change vs July 28 and regular-hours dollars, July 29table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 29 close vs July 28 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 29 close vs July 28 close, $1M-traded filterscalar · 2026-08-01 · 1×61,652
Market Recap: July 28, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 28 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 28table · 2026-08-01 · 7×5 July 29 through 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 28 SEC filing mixscalar · 2026-08-01 · 1×14147 Treasury curve prints on file, July 23 through July 28series · 2026-08-01 · 4×5Preview: a 4-point series, ending higher. SPY day move in trailing context (open-to-close, June 29 through July 28)scalar · 2026-08-01 · 1×40.21 SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 28 close vs July 27 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 28 vs the July 27 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 28 vs July 27, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6536.07 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 28scalar · 2026-08-01 · 1×310.23 Options tape: contracts, call share, same-day share vs Monday, busiest SPY contractscalar · 2026-08-01 · 1×1210.07 Eight mega-caps: change vs July 27 and regular-hours dollars, July 28table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 28 close vs July 27 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 28 close vs July 27 close, $1M-traded filterscalar · 2026-08-01 · 1×63,519
Market Recap: July 27, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 27 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 27table · 2026-08-01 · 7×5 July 28 through 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 27 SEC filing mixscalar · 2026-08-01 · 1×1491 Treasury curve prints on file, July 22 through July 27series · 2026-08-01 · 4×5Preview: a 4-point series, ending lower. SPY day move in trailing context (open-to-close, June 26 through July 27)scalar · 2026-08-01 · 1×4-0.79 SPY's median spread ranked against every July session through the 27th, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 27 close vs July 24 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 27 vs the July 24 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 27 vs July 24, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6553.53 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 27scalar · 2026-08-01 · 1×310.38 Options tape: contracts, call share, same-day share vs Friday, busiest SPY contractscalar · 2026-08-01 · 1×1211.07 Eight mega-caps: change vs July 24 and regular-hours dollars, July 27table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 27 close vs July 24 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 27 close vs July 24 close, $1M-traded filterscalar · 2026-08-01 · 1×63,880
Market Recap: July 10, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 10 regular hourstable · 2026-07-26 · 10×5 SK Hynix's first session: the listing record vs the tape, July 10, 2026scalar · 2026-07-26 · 1×8158.14 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×7390 SPY / QQQ / NVDA / META / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. NVDA and META in the news feed on July 10: every company-named headlinetable · 2026-07-26 · 5×3 The week of July 13–17: closures, ex-dividends, splits, the monthly expiry, and the short-interest lagscalar · 2026-07-26 · 1×80 Ex-divs, splits, news, and the July 10 SEC filing mixscalar · 2026-07-26 · 1×16153 Treasury print status: July 9 and July 10 rows on record, and the July 8 curve (latest at authoring)scalar · 2026-07-26 · 1×61 SPY day move in trailing context (~22 sessions, open-to-close)scalar · 2026-07-26 · 1×40.38 The eleven SPDR sector ETFs: July 10 close vs July 9 close, regular hourstable · 2026-07-26 · 11×5 SPY / QQQ / DIA / IWM: July 10 vs the July 9 close, regular hourstable · 2026-07-26 · 4×10 Stocks NBBO update count: July 10 vs July 9, with named-ticker updates (millions)scalar · 2026-07-26 · 1×6402.21 Options NBBO tape: total updates vs the stock tape, plus the SPY root slicescalar · 2026-07-26 · 1×36.73 Options tape: contracts, call %, 0DTE share vs Thursday, top contract, Friday expiry dayscalar · 2026-07-26 · 1×1410.56 Ten names that defined the session: gap, intraday, close, dollars, July 10table · 2026-07-26 · 10×8 2026's five largest US listings by dollars raisedranking · 2026-07-26 · 5×3Preview: 5 ranked values, largest first. SEC filings per day, week of July 6 to July 10series · 2026-07-26 · 5×3Preview: a 5-point series, ending lower. Liquid-tape breadth: July 10 advancer share vs July 9, $1M-traded filterscalar · 2026-07-26 · 1×53,191
Market Recap: July 9, 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 9 regular hourstable · 2026-07-26 · 10×6 SPY same-day (0DTE) options: contracts by strike distance from the closing priceranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first. Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×9885 SPY / QQQ / NVDA / TSLA / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. On deck: the next session, its ex-dividend slate, the SPY expiry ladder, and the short-interest clockscalar · 2026-07-26 · 1×80 Ex-divs, splits, SEC filings, news attentionscalar · 2026-07-26 · 1×14127 The week so far: index moves and advancer share for each completed sessionseries · 2026-07-26 · 4×5Preview: a 4-point series, ending lower. Treasury print status: July 9 rows on record, and the July 8 curve (latest at authoring)scalar · 2026-07-26 · 1×61 SPY / QQQ day move in trailing context (~22 sessions)scalar · 2026-07-26 · 1×71.67 SPY's RTH average quoted spread in trailing-month contextscalar · 2026-07-26 · 1×62.071 Eight declared sector baskets, three names each: July 9 close-over-close, equal-weightedtable · 2026-07-26 · 8×6 SPY / QQQ / DIA / IWM: July 9 vs the July 8 close, regular hourstable · 2026-07-26 · 4×10 Eight mega-caps and defensives: gap at the open vs the rest of the day, July 9table · 2026-07-26 · 8×8 Stocks NBBO update count: July 9 vs July 8, with named-ticker updates (millions)scalar · 2026-07-26 · 1×8383.44 Premarket path, 4:00-9:29 am ET: last premarket print vs Wednesday's close, and the open that followedtable · 2026-07-26 · 6×8 Options NBBO tape: total updates vs the stock tape, plus the SPY root slicescalar · 2026-07-26 · 1×36.9 Options tape: prints, contracts, call %, 0DTE share vs Wednesday, top contractsscalar · 2026-07-26 · 1×229.99
page 1 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 →
$