round-trip rules — 2 answered market questions

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

most recentas of 2026-09-15 series 25×2read in context →

VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included) — 25 rows by 2 columns, computed 2026-09-15 from US exchange, SIP and OPRA data.
et_time	last_price
01:00	698
01:30	697.72
02:00	697.8
02:30	698.64
03:00	697.5
03:30	697.28
04:00	698.27
04:30	700.28
05:00	700.52
05:30	701.21
06:00	701.1
06:30	700.81
07:00	700.49
07:30	700.58
08:00	700.24
08:30	699.35
09:00	699.61
09:30	700
10:00	699.77
10:30	699.71
11:00	699.71
11:30	699.75
12:00	699.59
12:30	699.67
13:00	699.66

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 → One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026 series 32×3 → The first active ETF share class: DFMC weekly closes since its March 2026 listing series 20×4 → See all 2,249 queries →