STRASMORE/EXPLORE 2,170 QUERIES

One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-02, from Mutual Funds vs ETFs: What Actually Differs.

as of series 32×3read in context →
One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026 — 32 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timevoo_pricevolume
04:00685.818914.241196
04:30685.8174
05:00686.231057.855226
05:30685.91065.177594
06:00686.548200.181237
06:30686.471708
07:00685.8510609.392414
07:30685.320722.300312
08:00685.18509673.280664
08:30685.0443734.396262
09:00686.3232709.348633
09:30688.26381787.540939
10:00686.87319265.745788
10:30687.47150488.182263
11:00688.82157319.807839
11:30689.14147454.236192
12:00689.26116415.504579
12:30689.25111566.146267
13:00688.55102694.564332
13:30688.02110321.800433
14:00688.01186764.139898
14:30687.97129859.792631
15:00687.54265631.577303
15:30686.98386868.517453
16:00687.9259096.92596
16:30687.616808.165065
17:00687.237502.477034
17:30686.57367.972299
18:00685.6211842.400604
18:30685.667595.646928
19:00685.356669.750178
19:30686.265845.393648
Rows × columns
32 × 3
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026, derived from the stored result.
ColumnTypeRangeNotes
et_time date 04:00 to 19:30
voo_price number 685.04 to 689.26 US dollars
volume number 174 to 509,673.2807 count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number
WITH bars AS (
    SELECT toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE) AS bucket,
           argMax(close, window_start) AS last_price,
           sum(volume) AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'VOO'
      AND toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2026-07-22')
    GROUP BY bucket
)
SELECT formatDateTime(bucket, '%H:%i') AS et_time,
       round(last_price, 2) AS voo_price,
       shares AS volume
FROM bars
ORDER BY bucket

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMutual Funds vs ETFs: What Actually Differs
The first active ETF share class: DFMC weekly closes since its March 2026 listing series 20×4 Quoted bid-ask spread by fund: venue quotes, 11:00 to 13:59 ET, July 22, 2026 ranking 7×4 How far the price travels inside a day: seven ETFs, July 2026 sessions ranking 7×4 Short-term Treasury yields by month, the reference for fund borrowing costs series 36×3 Monthly cost of a near-the-money call, as a percent of share price series 18×3 Cash distributions over the trailing year, by declared schedule ranking 5×2 See all 2,170 queries →