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: Week of July 20, 2026
Next week on the calendar: closures, ex-dividends, splits, and the expiry pullscalar · 2026-08-12 · 1×60 SPY median quoted spread and NBBO updates per session, regular hours, July 20-24series · 2026-08-12 · 5×5Preview: a 5-point series, ending higher. SPY by session: close, change, and share volume, July 20-24series · 2026-08-12 · 5×4Preview: a 5-point series, roughly flat. Options contracts, same-day share, and call share by session, July 20-24series · 2026-08-12 · 5×5Preview: a 5-point series, ending higher. SEC filings by session and form type, July 20-24series · 2026-08-12 · 5×5Preview: a 5-point series, roughly flat. Advancers and decliners per session, names with $5M+ traded, July 20-24series · 2026-08-12 · 5×5Preview: a 5-point series, roughly flat. Top names by regular-hours dollar volume, full week July 20-24ranking · 2026-08-12 · 8×3Preview: 8 ranked values, largest first. Daily short-volume file coverage: tickers on file and short shares, July 20-24series · 2026-08-12 · 5×4Preview: a 5-point series, roughly flat. Session verification: sessions, bars, holiday rows, up and down closes, next closurescalar · 2026-08-12 · 1×95 The week's corporate calendar: dividends, splits, listings, newsscalar · 2026-08-12 · 1×917,144 SPY's week in trailing-year context (open-to-close weekly returns)scalar · 2026-08-12 · 1×5-1.1 SPY / QQQ / DIA / IWM: week of July 20 vs the July 17 close, with the prior week's changetable · 2026-08-12 · 4×5 Sector ETFs, full-week change: July 24 close vs July 17 closeranking · 2026-08-12 · 11×3Preview: 11 ranked values, largest first. Treasury curve by session, July 17 print through July 24series · 2026-08-12 · 6×6Preview: a 6-point series, ending higher. Weekly movers: ten biggest gainers and decliners, regular-hours closes, $5M+ traded, splits excludedtable · 2026-08-12 · 20×6 Weekly breadth: July 24 regular close vs July 17 regular close, names with $5M+ traded during the weekscalar · 2026-08-12 · 1×62,437
SPCX: The Week It Went Underwater
Print-size anatomy and quote census: full weekscalar · 2026-07-26 · 1×55.52 The symbol's trading history by month: the gap and the new entity's arrivalseries · 2026-07-26 · 12×5Preview: a 12-point series, ending higher. Median quoted spread by session, regular hours (bps of midpoint)series · 2026-07-26 · 5×3Preview: a 5-point series, ending lower. FINRA daily short volume during the week: short shares and their off-exchange shareranking · 2026-07-26 · 4×4Preview: 4 ranked values, largest first. The new entity's short-interest prints to date, with implied days-to-covertable · 2026-07-26 · 2×5 SPCX by session: close, change, shares, dollarsseries · 2026-07-26 · 5×5Preview: a 5-point series, ending lower. SPCX, week of July 6, 2026: the slide, receiptedscalar · 2026-07-26 · 1×14161.86 Rank receipt: the week's dollar volume against every other tickerscalar · 2026-07-26 · 1×311 Options on the new entity, full week: contracts, put-call, busiest contractscalar · 2026-07-26 · 1×43.14 The week's contracts by strike bucket ($20 buckets; tails capped at $80 and $240)table · 2026-07-26 · 9×6 The week's news flow: counts, plus the three storyline receipts, quoted verbatimscalar · 2026-07-26 · 1×951 The week's heaviest tickers by regular-hours dollar volume: where the newcomer now sitsranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. Large recent debuts, first month on one ruler: first trade to the day-28 close (ET regular hours)table · 2026-07-26 · 7×8 Every week of the new entity's life: open-to-close return and RTH dollars (entity-bounded)ranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first.
NVDA: Sit-Out, Then Surge, Week of July 6
Print-size anatomy and quote census: NVDA, full weekscalar · 2026-07-26 · 1×512.17 NVDA median quoted spread by session, regular hours (bps of midpoint)series · 2026-07-26 · 5×3Preview: a 5-point series, ending higher. FINRA daily short volume, NVDA: with the file-completeness caveatranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. NVDA by session: close, change, shares, dollarsseries · 2026-07-26 · 5×5Preview: a 5-point series, ending higher. NVDA, week of July 6, 2026: open to close, extremes with receipts, volumescalar · 2026-07-26 · 1×14194.51 Rank receipt: NVDA's weekly dollar volume against every other ticker, plus the Friday-only rankscalar · 2026-07-26 · 1×73 NVDA position check as of Friday's close: trailing-year extremes and moving averagesscalar · 2026-07-26 · 1×12210.96 NVDA options, full week: totals, put-call vs trailing baseline, strikes and expiries decodedscalar · 2026-07-26 · 1×1117.28 News-feed attention: articles tagged NVDA during the week, decodedscalar · 2026-07-26 · 1×1186 The week's heaviest tickers by regular-hours dollar volumeranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. NVDA vs the chip complex: close-over-close % change by sessionseries · 2026-07-26 · 5×6Preview: a 5-point series, ending lower. NVDA weekly returns, trailing ~26 weeks (open-to-close per week): where this week rankstable · 2026-07-26 · 27×3
Market Recap: Week of July 6, 2026
Next week on the calendar: closures, ex-dividends, and the monthly expiry's pullscalar · 2026-07-26 · 1×40 SPY by session: close, change, and share volume, July 6-10series · 2026-07-26 · 5×4Preview: a 5-point series, ending lower. Options contracts and 0DTE share by session, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. What the news feed actually carried, verbatim (The Motley Fool, rout day and bounce day)table · 2026-07-26 · 2×3 SEC filings by session and form type, July 6-10table · 2026-07-26 · 5×5 SK Hynix's SEC paper trail into its July 10 US listingtable · 2026-07-26 · 9×2 SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026scalar · 2026-07-26 · 1×14158.14 Top names by regular-hours dollar volume, full week July 6-10ranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. Tuesday's rout: INTC and TER, July 7 close vs July 6 closeranking · 2026-07-26 · 2×2Preview: 2 ranked values, largest first. Daily short-volume file coverage: tickers on file and total short shares, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, largest first. Session verification: five sessions, no holiday, next scheduled closurescalar · 2026-07-26 · 1×65 Feed coverage by day: articles tagging NVDA, MU, INTC, TER, July 6-10table · 2026-07-26 · 5×5 The week's corporate calendar: filings, dividends, splits, newsscalar · 2026-07-26 · 1×1018,353 SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks)scalar · 2026-07-26 · 1×50.82 SPY / QQQ / DIA / IWM: week of July 6 vs the July 2 close, with the prior week's changetable · 2026-07-26 · 4×5 Sector ETFs, full-week change: July 10 close vs July 2 closeranking · 2026-07-26 · 10×2Preview: 10 ranked values, smallest first. Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on filescalar · 2026-07-26 · 1×67 Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excludedtable · 2026-07-26 · 20×5 The chip complex's full-week change: July 10 close vs July 2 close, fourteen namesranking · 2026-07-26 · 14×2Preview: 14 ranked values, smallest first. Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the weekscalar · 2026-07-26 · 1×43,015
Market Recap: Week of June 29, 2026
Session by session: SPY close, change, and full-day volumeseries · 2026-07-26 · 4×4Preview: a 4-point series, roughly flat. Contracts traded during the week, by expiry date (single-pass scan; batch-generated)ranking · 2026-07-26 · 6×3Preview: 6 ranked values, largest first. Regular-hours dollar volume, week of June 29 (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. FINRA off-exchange short volume by session: coverage and marked-short shareranking · 2026-07-26 · 4×4Preview: 4 ranked values, smallest first. The session receipt: four traded days, one Friday closure, verified from the tapescalar · 2026-07-26 · 1×34 The week's corporate calendar: with the June 30 filing-index gap on displayscalar · 2026-07-26 · 1×82,221 This week against the trailing year of weeks: SPY, open-to-close within each week (rank 1 = best; short weeks excluded)scalar · 2026-07-26 · 1×51.12 Week-over-week: the four index ETFs against the prior Friday's closetable · 2026-07-26 · 4×5 Treasury yields through the week (July 2 print not yet ingested at generation)ranking · 2026-07-26 · 5×4Preview: 5 ranked values, smallest first. Advancers and decliners on the week, with the liquidity filter disclosedscalar · 2026-07-26 · 1×55,049
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 →
$