Wetin be VWAP? Volume-Weighted Average Price
VWAP na di average price wey dem really pay for each share for one trading day. E dey weight every price by di shares wey dem trade, so heavy minutes count pass quiet ones. E dey reset
VWAP na volume-weighted average price: di average price wey dem really pay for each share for one trading session, wey dem calculate as total dollars wey dem trade divide by total shares wey dem trade, e dey start fresh every day. Minutes wey get heavy trading dey count pass quiet ones, and na im make VWAP be di standard answer to "where dis stock really change hands today?" Every figure for dis page come from one stored query wey dem fit inspect over real minute bars and individual trades.
Wetin VWAP mean for stocks?
Stock chart dey show price for every minute, but all dose prices no dey equally important: one minute fit see hundreds of thousands of shares change hands, anoda one na small fraction of dat. Simple average of di minute prices go treat both di same. VWAP dey weight every price by di shares wey dem trade for am, so di average go land where di real trading happen.
Put am different way, VWAP na di average per share, no be di average per minute. If you fit line up every share wey trade today and ask each one wetin e go for, VWAP na di mean of dose answers.
Two properties follow from di definition: VWAP na per stock — Apple own no dey tell you anytin about Microsoft own — and per session, with di running totals dey start again from zero at di next open.
How dem dey calculate VWAP?
Di formula short:
- Multiply each minute bar price by im share volume.
- Add dose products up across di session.
- Divide by di total shares wey dem trade.
One small example: suppose one stock trade exactly two times today — 100 shares at $10.00, den 900 shares at $11.00. Di simple average of di two prices na $10.50. But 900 of di 1,000 shares change hands at $11.00, and di average dollar wey dem pay per share come out to (100 × $10.00 + 900 × $11.00) ÷ 1,000 = $10.90. Dat $10.90 na di VWAP — e pull toward $11 by di size of di second trade.
For practice, nobody dey add up millions of trades by hand; di standard shortcut dey use one-minute bars — each minute price times im volume, sum am and divide by total volume. Two convention notes. First, every figure for dis page dey use regular-session minute bars only, from di 9:30 a.m. open through di final bar at 3:59 p.m. ET — di 4:00 p.m. closing auction dey print just after dat bar and e dey outside dese figures, while di full-day benchmark VWAPs wey institutions dey use grade executions against generally dey include am. Second, many charting platforms dey start dia day-VWAP from di 4:00 a.m. premarket instead. Each convention dey give different number for di same stock on di same day.
VWAP for one real trading day
Now di real tin: Apple on July 2, 2026 — one verified full session (390 one-minute bars for our data) and di last complete trading day before di Independence Day closure on di market holiday schedule. Di chart dey sample price and running VWAP every five minutes.
The exact SQL behind every number
SELECT et_time, price, running_vwap
FROM (
SELECT window_start,
formatDateTime(toTimeZone(window_start, 'America/New_York'), '%H:%i') AS et_time,
round(close, 2) AS price,
round(sum(close * volume) OVER (ORDER BY window_start)
/ sum(volume) OVER (ORDER BY window_start), 2) AS running_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')
)
WHERE toMinute(window_start) % 5 = 4
ORDER BY window_startAt 09:34 ET, di first sampled bar, price ($298.2) and running VWAP ($298.09) dey nearly on top of each oda — only few minutes of volume don accumulate. By di final bar di price stand at $308.22 while di running VWAP settle at $305.99: di session VWAP. Di VWAP line dey steady as di day dey age — by afternoon e don carry hours of accumulated volume, and no single minute fit move am far.
One more number dey show di weighting: di first half hour alone carry 14.9% of di session volume, roughly double im share of di 390-minute session clock — and dose early, heavy bars print at prices below where di afternoon trade. Volume dey bunch at di open and again as di 4:00 p.m. closing auction dey approach — di same U-shaped intraday pattern wey relative volume readings gats adjust for — and VWAP dey hand di busy stretches e cover di extra weight wey dia share count earn.
VWAP vs. moving average
Moving average still dey smooth price, and people often dey confuse di two. Di differences na mechanical:
- Simple moving average dey take di last N closing prices and give each one equal vote, volume ignored. E dey slide: 20-minute moving average at 2:00 p.m. dey cover 1:40 to 2:00 and notin else.
- VWAP dey accumulate from di opening bell, dey weight every bar by shares wey dem trade, and dey reset at di next open. E dey answer different question — no be "wetin di price dey do lately?" but "wetin di average buyer don pay today?"
Di gap between weighted and unweighted na di whole lesson, and one row of data dey show am:
The exact SQL behind every number
SELECT formatDateTime(toDate(toTimeZone(min(window_start), 'America/New_York')), '%Y-%m-%d') AS session_date,
count() AS minute_bars,
round(sum(close * volume) / sum(volume), 2) AS session_vwap,
round(avg(close), 2) AS unweighted_avg_price,
round(argMax(close, window_start), 2) AS final_minute_price,
round((avg(close) - sum(close * volume) / sum(volume)) * 100) AS avg_premium_cents,
round(toFloat64(sum(volume)) / 1e6) AS total_volume_millions,
round(sumIf(toFloat64(volume), window_start < toDateTime('2026-07-02 10:00:00', 'America/New_York'))
/ toFloat64(sum(volume)) * 100, 1) AS first_30min_volume_pct
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')Averaging Apple 390 minute closes with equal weight dey give $306.54. Weighting di same closes by each minute volume dey give $305.99 — 55 cents lower. Same day, same bars, same 60 million shares; di only change na counting shares instead of minutes. Di sign matter: equal-weight average wey sit above di VWAP mean say di heavy-volume minutes trade below di day typical price. Di final minute bar of di session print $308.22 — di official close land moments later, for di closing auction.
How accurate VWAP from minute bars be?
VWAP dey defined over trades, and minute bars na approximation — wetin di shortcut cost? Most explainers no dey ever check. Here na di same session VWAP wey dem compute di long way, from every individual trade print on di consolidated tape, next to di minute-bar version. (Official and vendor VWAPs still dey drop handful of condition-coded prints, like average-price trades, so platforms fit differ by small.)
The exact SQL behind every number
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_barsAcross 1.1 million individual trades, di trade-level VWAP na $305.9162; di minute-bar shortcut give $305.9908. Di two land 7.5 cents apart — 2.4 basis points (hundredths of a percent) of di share price. For session reference line on dis day, di minute-bar shortcut stay within dime of di trade-by-trade figure.
VWAP dey di same for every stock?
No market-wide VWAP dey; every stock dey get im own each session. Here na di same July 2 session across five household names, each with verified full 390-bar session:
The exact SQL behind every number
SELECT ticker,
round(sum(close * volume) / sum(volume), 2) AS session_vwap,
round(argMax(close, window_start), 2) AS final_minute_price,
round((argMax(close, window_start) - sum(close * volume) / sum(volume))
/ (sum(close * volume) / sum(volume)) * 100, 2) AS final_vs_vwap_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'KO')
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')
GROUP BY ticker
HAVING count() = 390
ORDER BY indexOf(['AAPL', 'MSFT', 'NVDA', 'TSLA', 'KO'], ticker)Coca-Cola session VWAP print $82.96; Tesla own print $399.64. Di final-minute finishes split too: Apple end 0.73% above im VWAP and Coca-Cola 1.23% above, Microsoft end almost exactly on im own (0.07%), while Nvidia and Tesla end below dia own (-0.32% and -1.71%). Five stocks, one day, five different answers.
Who dey use VWAP, and for wetin?
Institutions dey grade executions. Fund wey dey buy large position no fit fill at one price; e dey get average. Di day VWAP na di yardstick: buy order wey fill below VWAP pay less dan dat day average dollar. Execution desks dey report slippage versus VWAP di way students dey report grades — typically against full-day benchmark wey include di closing auction print.
Execution algorithms. Brokers dey offer VWAP algos — programs wey dey slice one large parent order into hundreds of small child orders across di session, sized to di day typical volume pattern, dey aim to fill near di benchmark instead of push di price. Each child order still dey pay di bid-ask spread, and di counterparty on many of dose fills na market maker wey dey quote both sides.
Day traders — di VWAP indicator as intraday reference line. Intraday traders dey keep am on chart as di day average-cost line: price above VWAP mean say recent buyers pay more dan di session average; price below, less. Observation about where trading don already happen — no be prediction of where price go next.
Anchored VWAP, common variant: identical arithmetic, different starting point — di accumulation dey start at bar wey di trader pick (earnings release, IPO day, notable high or low) instead of di open.
FAQ
VWAP na moving average?
No. Moving average dey slide fixed lookback window and dey give every bar equal vote regardless of volume. VWAP dey start at di session open, dey weight each bar by shares wey dem trade, and dey reset every day. On July 2, 2026, equal-weight average of Apple minute closes sit 55 cents above im VWAP on identical bars.
VWAP dey include premarket and after-hours trading?
E depend on di platform. Dis page dey use regular-session minute bars only, through di final bar at 3:59 p.m. ET — di 4:00 p.m. closing cross dey print after dat bar, and full-day benchmark VWAPs generally dey include am. Many charting apps dey accumulate from di 4:00 a.m. premarket instead; check di platform setting before you compare numbers.
Wetin e mean when stock dey trade above VWAP?
E mean say di current price high pass di average price wey dem pay per share so far dat session. On July 2, 2026, Apple end di final minute of di regular session 0.73% above im session VWAP while Tesla end below im own. Di comparison dey describe di session trading; e no dey forecast di next move.
Wetin e mean when stock dey trade below VWAP?
E mean say di current price low pass di average price wey dem pay per share so far dat session. On July 2, 2026, Tesla end di final minute of di regular session below im session VWAP (-1.71%) while Apple end above im own. Di comparison dey describe di session trading; e no dey forecast di next move.
Wetin VWAP stand for?
VWAP stand for volume-weighted average price: di average price wey stock trade at over di session, with every trade weighted by im share volume. Large trades dey move am more dan small ones — di property wey make am di standard benchmark for execution quality.
Wetin be anchored VWAP?
Di same calculation wey dem start from chosen bar instead of di session open — earnings report, IPO, swing high or low. Di line dey track di average price wey everybody wey don trade since dat event pay.
Every panel above dey ship with di exact SQL wey produce am — expand any panel to audit di numbers. To compute VWAP for any ticker and session, ask di question for plain English on di Strasmore terminal.