STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

What Is RVOL (Relative Volume)? How to Read It
SPY: median shares traded per minute, by 30-minute clock bucket (ET, last 30 days, extended hours)series · 2026-10-04 · 32×2Preview: a 16-point series, roughly flat. SPY: average share of full-day volume completed by each clock time (last 20 sessions)ranking · 2026-10-04 · 5×2Preview: 5 ranked values, smallest first. Top 10 by full-day RVOL: latest completed session (20-day ADV above 5M shares, full history required)series · 2026-10-04 · 10×5Preview: a 10-point series, ending lower. Full-day RVOL percentiles across high-volume US stocks and ETFs (20-day ADV above 5M shares), latest completed sessionranking · 2026-10-04 · 6×2Preview: 6 ranked values, smallest first. MU, the biggest-volume session of June 2026: time-adjusted vs. naive RVOL, plus the full-day figurescalar · 2026-10-04 · 1×832.8
Relative Volume Screener in SQL: Free API
Share of a session's volume completed by each half hour: SPY and KOseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Relative volume screener: top 20 by time adjusted RVOL at 11:00 a.m. ETtable · 2026-10-04 · 20×5 Cisco, September 22, 2026: naive RVOL against time adjusted RVOL through the sessionseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Share of the session completed by 11:00 a.m. ET, twelve household namesranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first.
Why Relative Volume Differs Between Platforms
Five relative-volume definitions on one AAPL session, at 10:30 a.m. ET and at the closeranking · 2026-09-28 · 5×3Preview: 5 ranked values, smallest first. One AAPL session, four lookbacks: full-day relative volume from daily barsranking · 2026-09-28 · 4×4Preview: 4 ranked values, largest first. How the session's volume piled up against the prior 10 sessions, checkpoint by checkpointseries · 2026-09-28 · 14×4Preview: a 14-point series, ending higher. Same session, same 10-session lookback: same-time basis vs full-day basis through the dayseries · 2026-09-28 · 14×3Preview: a 14-point series, ending higher.
SPY: median shares traded per minute, by 30-minute clock bucket (ET, last 30 days, extended hours)

SPY: median shares traded per minute, by 30-minute clock bucket (ET, last 30 days, extended hours)

most recentas of series 32×2read in context →
SPY: median shares traded per minute, by 30-minute clock bucket (ET, last 30 days, extended hours) — 32 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timemedian_minute_volume_k
04:000.6
04:300.4
05:000.4
05:300.4
06:000.4
06:300.4
07:001.4
07:301.4
08:002.6
08:303.2
09:003.5
09:3097.8
10:0076.2
10:3063.2
11:0052.1
11:3045.3
12:0039.2
12:3037.1
13:0034
13:3033.1
14:0044.5
14:3043.1
15:0056.1
15:30152
16:0022.5
16:302.2
17:000.6
17:300.4
18:000.7
18:300.4
19:000.3
19:300.5
the exact SQL behind every number 
SELECT formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
       round(quantileDeterministic(0.5)(toFloat64(volume), toUInt64(toUnixTimestamp(window_start))) / 1000, 1) AS median_minute_volume_k
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
  AND window_start >= now() - INTERVAL 30 DAY
  AND toDate(toTimeZone(window_start, 'America/New_York')) < toDate(toTimeZone(now(), 'America/New_York'))
GROUP BY et_time
HAVING et_time >= '04:00' AND et_time < '20:00'
ORDER BY et_time
More from this analysisWhat Is RVOL (Relative Volume)? How to Read It
Top 10 by full-day RVOL: latest completed session (20-day ADV above 5M shares, full history required) series 10×5 → Full-day RVOL percentiles across high-volume US stocks and ETFs (20-day ADV above 5M shares), latest completed session ranking 6×2 → SPY: average share of full-day volume completed by each clock time (last 20 sessions) ranking 5×2 → MU, the biggest-volume session of June 2026: time-adjusted vs. naive RVOL, plus the full-day figure scalar 1×8 → See all 3,256 queries →
$