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

Weekly Market Recap: The Week in Numbers
Where the volume went: most dollars traded over the past weekranking · 2026-08-25 · 8×2Preview: 8 ranked values, largest first. The eleven S&P 500 sectors over the past weekranking · 2026-08-25 · 11×2Preview: 11 ranked values, largest first. Biggest stock losers over the past weekranking · 2026-08-25 · 7×3Preview: 7 ranked values, smallest first. The major index ETFs over the past weekranking · 2026-08-25 · 4×4Preview: 4 ranked values, largest first. Biggest stock gainers over the past weekranking · 2026-08-25 · 7×3Preview: 7 ranked values, largest first. Daily market breadth: advancers vs decliners each session (names trading $500M+)series · 2026-08-25 · 5×3Preview: a 5-point series, ending higher.
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
Market Recap: H1 2026
Slope receipts: start, end, minimum, the spread never inverted this halfscalar · 2026-07-26 · 1×472 123 sessions in the half, verified from the tapescalar · 2026-07-26 · 1×1123 Median quoted spread by sector ETF, one representative session (June 29, 2026), regular hoursranking · 2026-07-26 · 11×4Preview: 11 ranked values, smallest first. The eleven sector ETFs: H1 2026 return, Q1 and Q2 split, and H1 dollar volumetable · 2026-07-26 · 11×5 Q2 regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,477.9 May: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,394.6 April: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,386.9 March: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,442.6 February: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,262.3 January: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,316.1 SPY median quoted spread on one labeled sample session per month (second Wednesdays), every NBBO updateseries · 2026-07-26 · 6×4Preview: a 6-point series, ending higher. SPY sessions up vs down across the half, one cheap receiptscalar · 2026-07-26 · 1×464 H1 2026: half, Q1, and Q2 returns for the four index ETFs, computed in one querytable · 2026-07-26 · 4×5 The leader set's half and Q2 returns plus half dollar volume: one ticker-filtered queryranking · 2026-07-26 · 6×4Preview: 6 ranked values, largest first. The half, month by month (SPY and QQQ, recomputed identically in one query)ranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. New listings per month across the halfranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. The 2s10s spread, every print of the halftable · 2026-07-26 · 124×2 Seven maturities: yield at the start of the half vs the end, and the changeranking · 2026-07-26 · 7×4Preview: 7 ranked values, smallest first. H1 2026's corporate calendar (all three month-end filing-index gaps disclosed)scalar · 2026-07-26 · 1×728,356 The rank receipts: DIA and IWM against every prior first half (rank 1 = best; self-excluded)table · 2026-07-26 · 2×6 The rank receipts: this half against every prior one (SPY and QQQ; rank 1 = best; self-excluded)table · 2026-07-26 · 2×6 Every first half on the tape: DIA and IWM, same arithmetictable · 2026-07-26 · 46×4 Every first half on the tape: SPY and QQQ, recomputed identically by year (per-year session counts shown)table · 2026-07-26 · 39×4
Market Recap: June 2026
Short-interest settlements on file: May 29, June 15, and June 30ranking · 2026-07-26 · 3×2Preview: 3 ranked values, smallest first. 21 sessions, verified from the tape (Juneteenth closure receipt included)scalar · 2026-07-26 · 1×321 Treasury yields through June: 10-year, 2-year, and the 2s10s spreadranking · 2026-07-26 · 21×4Preview: 16 ranked values, smallest first. SPY, all 21 June sessions: close and close-over-close changeseries · 2026-07-26 · 21×3Preview: a 16-point series, ending lower. SPY sessions up vs down across the month, one cheap receiptscalar · 2026-07-26 · 1×49 June 2026: open to close, range, and regular-hours turnover for the four index ETFstable · 2026-07-26 · 4×7 June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-26 · 1×31,477.9 June regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. Ex-dividend events by day through Juneranking · 2026-07-26 · 22×2Preview: 16 ranked values, largest first. June's corporate calendar: dividends, splits, listings, filings (June 30 index gap disclosed)scalar · 2026-07-26 · 1×66,651 SPY median quoted spread: the June sample session against May's (second Wednesdays)series · 2026-07-26 · 2×4Preview: a 2-point series, ending higher. May, recomputed identically for contrast (one scan)scalar · 2026-07-26 · 1×31,394.6 Monthly returns, January through June 2026, recomputed live (SPY and QQQ)ranking · 2026-07-26 · 12×4Preview: 12 ranked values, largest first. The rank receipt: this June against every prior one (rank 1 = best; self-excluded)scalar · 2026-07-26 · 1×5-1.2 Every June on the tape: SPY, recomputed identically by year (session counts shown)ranking · 2026-07-26 · 23×3Preview: 16 ranked values, smallest first. Advancers vs decliners for June (close vs the last May close), liquidity filter disclosedscalar · 2026-07-26 · 1×44,240
Market Recap: Q2 2026
62 sessions in the quarter, verified from the tape, month by monthscalar · 2026-07-16 · 1×462 The 2s10s spread and the 10-year through Q2, dailytable · 2026-07-16 · 63×3 SPY median quoted spread on one labeled sample session per month of the quarter (second Wednesdays)series · 2026-07-16 · 3×4Preview: a 3-point series, ending higher. SPY sessions up vs down across the quarter, one cheap receiptscalar · 2026-07-16 · 1×436 June: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,477.9 May: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,394.6 April: whole-tape options contract volume and same-day-expiry share (one scan)scalar · 2026-07-16 · 1×31,386.9 Q2 month by month: April, May, June (SPY and QQQ, recomputed identically)ranking · 2026-07-16 · 6×4Preview: 6 ranked values, largest first. Q2 regular-hours dollar volume, whole tape (one reused-symbol listing excluded pending entity verification)ranking · 2026-07-16 · 8×3Preview: 8 ranked values, largest first. Listings, splits, and ex-dividend events by month through the quarterranking · 2026-07-16 · 3×4Preview: 3 ranked values, smallest first. Q2's corporate calendar (the June 30 filing-index gap disclosed)scalar · 2026-07-16 · 1×615,402 Q2 2026 returns for the four index ETFs, with Q1 recomputed live for contrastranking · 2026-07-16 · 4×4Preview: 4 ranked values, smallest first. The rank receipts: this quarter against every prior second quarter (rank 1 = best; self-excluded)table · 2026-07-16 · 2×6 Every second quarter on the tape: SPY and QQQ, recomputed identically by year (session counts shown)table · 2026-07-16 · 40×4
Where the volume went: most dollars traded over the past week

Where the volume went: most dollars traded over the past week

most recentas of ranking 8×2read in context →
Where the volume went: most dollars traded over the past week — 8 rows by 2 columns, computed from US exchange, SIP and OPRA data.
tickerweek_dollar_bn
QQQ55.4
SPY52.6
MU50.9
SNDK47.9
NVDA35.3
AAPL25
MRNA24.4
META21
the exact SQL behind every number 
WITH sess AS (
    SELECT ticker, toDate(toTimeZone(window_start, 'America/New_York')) AS d,
        sum(toFloat64(close) * toFloat64(volume)) AS dv
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE window_start >= now() - INTERVAL 12 DAY AND ticker NOT IN ('SPCX','SOXL','SOXS','TQQQ','SQQQ','NVDL','NVDS','NVD','TSLL','TSLQ','TSLZ','SPXL','SPXS','UPRO','SPXU','LABU','LABD','FAS','FAZ','TNA','TZA','YINN','YANG','UDOW','SDOW','BOIL','KOLD','UCO','SCO','USD','SSO','SDS','QLD','QID','ERX','ERY','DRN','DRV','CURE','SOXY','MUU','SNXX','UVXY','SVXY','UVIX','SVIX','BULZ','WEBL','WEBS','DPST','DRIP','GUSH','AGQ','ZSL','BITX','ETHU','MSTX','MSTU','CONL','DUST','JNUG','JDST','NUGT') AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60 + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker, d
),
wk AS (SELECT ticker, sum(dv) AS wd FROM sess WHERE d >= (SELECT max(d) FROM sess) - 6 GROUP BY ticker)
SELECT ticker, round(wd / 1e9, 1) AS week_dollar_bn FROM wk ORDER BY wd DESC LIMIT 8
More from this analysisWeekly Market Recap: The Week in Numbers
The eleven S&P 500 sectors over the past week ranking 11×2 → Biggest stock losers over the past week ranking 7×3 → Biggest stock gainers over the past week ranking 7×3 → The major index ETFs over the past week ranking 4×4 → See all 2,170 queries →
$