STRASMORE/EXPLORE 2,173 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,173 answered market questions

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

Stop Order vs Stop-Limit Order: How Each Fills
Average one-minute high-low range by time of dayseries · 2026-08-08 · 13×3Preview: a 13-point series, ending lower. Sessions that gapped through a 2% stop, and whether the limit price tradedranking · 2026-08-08 · 5×3Preview: 5 ranked values, smallest first. NVDA's largest gap-down opens and the 30 minutes that followedseries · 2026-08-08 · 8×3Preview: a 8-point series, ending higher. How often each stock opened below the prior closeranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first.
The Sub-Penny Rule and Price Improvement
What one cent is worth, by share price bandranking · 2026-08-07 · 8×3Preview: 8 ranked values, smallest first. The penny tick and the quoted gap, in basis pointstable · 2026-08-07 · 7×5 Share of prints that landed on a sub-penny priceranking · 2026-08-07 · 7×3Preview: 7 ranked values, largest first. AAPL sub-penny print rate by trade size, 17 June 2026ranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first.
Time in Force Explained: Day, GTC, IOC, FOK
SPY share volume by ET clock hour, June 2026series · 2026-08-07 · 16×2Preview: a 16-point series, roughly flat. Print sizes across five names, 10:00 to 11:00 a.m. ET on 2026-06-10ranking · 2026-08-07 · 5×3Preview: 5 ranked values, largest first. US stock splits per month, forward and reverseseries · 2026-08-07 · 12×3Preview: a 12-point series, ending higher. SPY volume per minute into the close, June 2026 session averageseries · 2026-08-07 · 16×2Preview: a 16-point series, roughly flat.
Average one-minute high-low range by time of day

Average one-minute high-low range by time of day

most recentas of series 13×3read in context →
Average one-minute high-low range by time of day — 13 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timenvda_range_bpsspy_range_bps
09:3028.57
10:0018.86.2
10:3015.75.4
11:0013.64.8
11:30124.5
12:0010.94
12:30103.9
13:009.63.8
13:309.13.6
14:009.13.6
14:308.93.6
15:009.53.5
15:30124.3
the exact SQL behind every number 
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
    round(avgIf(10000 * (toFloat64(high) - toFloat64(low)) / toFloat64(close), ticker = 'NVDA'), 1) AS nvda_range_bps,
    round(avgIf(10000 * (toFloat64(high) - toFloat64(low)) / toFloat64(close), ticker = 'SPY'), 1)  AS spy_range_bps
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('NVDA', 'SPY')
  AND window_start >= '2025-08-01'
  AND window_start <  '2026-08-01'
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
  AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
       + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
GROUP BY et_time
HAVING countIf(ticker = 'NVDA') > 0
   AND countIf(ticker = 'SPY') > 0
ORDER BY et_time
More from this analysisStop Order vs Stop-Limit Order: How Each Fills
NVDA's largest gap-down opens and the 30 minutes that followed series 8×3 → Sessions that gapped through a 2% stop, and whether the limit price traded ranking 5×3 → How often each stock opened below the prior close ranking 5×3 → Average shares per print, monthly, MSFT and KO series 90×4 → See all 2,173 queries →
$