The receipt: VWAP from every individual trade vs. the minute-bar shortcut (AAPL, July 2, 2026)

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH every_trade AS (
    SELECT round(sum(price * size) / sum(size), 4) AS trade_vwap,
           round(count() / 1e6, 1) AS trades_millions
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-07-02 09:30:00', 'America/New_York')
      AND sip_timestamp < toDateTime('2026-07-02 16:00:00', 'America/New_York')
),
minute_bars AS (
    SELECT round(sum(close * volume) / sum(volume), 4) AS bar_vwap
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= toDateTime('2026-07-02 09:30:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-02 16:00:00', 'America/New_York')
)
SELECT every_trade.trade_vwap AS trade_level_vwap,
       minute_bars.bar_vwap AS minute_bar_vwap,
       round(abs(every_trade.trade_vwap - minute_bars.bar_vwap) * 100, 1) AS gap_cents,
       round(abs(every_trade.trade_vwap - minute_bars.bar_vwap) / every_trade.trade_vwap * 10000, 1) AS gap_bps,
       every_trade.trades_millions
FROM every_trade, minute_bars