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

3,293 answered market questions

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

Can You Day Trade an Index Fund? ETFs vs Funds
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)series · 2026-10-24 · 32×2Preview: a 16-point series, ending lower. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-10-24 · 3×3Preview: 3 ranked values, smallest first.
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)

VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)

most recentas of series 32×2read in context →
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included) — 32 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timelast_price
04:00703.95
04:30702.93
05:00703.13
05:30703.29
06:00704.03
06:30703.84
07:00703.08
07:30703.96
08:00704.45
08:30704.01
09:00704.46
09:30705.13
10:00701.66
10:30701.66
11:00701.73
11:30702.98
12:00703.54
12:30702.05
13:00701.68
13:30701.1
14:00700.79
14:30700.14
15:00701.44
15:30702.3
16:00702.49
16:30702.1
17:00702.46
17:30702.28
18:00702.87
18:30702.75
19:00702.12
19:30702.34
the exact SQL behind every number 
SELECT formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
       round(argMax(toFloat64(close), window_start), 2) AS last_price
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'VOO'
  AND window_start >= today() - 21
  AND window_start < today()
  AND toDate(toTimeZone(window_start, 'America/New_York')) = (
      SELECT max(toDate(toTimeZone(window_start, 'America/New_York')))
      FROM global_markets.delayed_stocks_minute_aggs
      WHERE ticker = 'VOO'
        AND window_start >= today() - 21
        AND window_start < today()
  )
GROUP BY et_time
ORDER BY et_time
More from this analysisCan You Day Trade an Index Fund? ETFs vs Funds
Typical quoted spread on the three largest S&P 500 ETFs, trailing five days ranking 3×3 → SPY five-minute price marks across one full session series 78×2 → Calendar days spanned by each rolling five-session window series 78×3 → Share of monthly volume by 15-minute ET clock slice, SPY and AAPL series 64×3 → See all 3,293 queries →
$