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.
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 →
$