US Market Volume By Hour For Lagos Time (WAT)
US market volume by hour for Lagos time: which WAT hour thick, which one dead, plus where the closing auction dey land late for your night.
US market volume by hour for Lagos time pack inside one evening window: 14:30 till 21:00 WAT when America dey run summer time, and 15:30 till 22:00 WAT when dem fall back to winter time. WAT no dey shift at all. Na the New York clock dey slide, and e slide twice every year. Inside that window the volume no spread evenly: e burst for the open, e die for the middle of the US afternoon, then e jump again when the closing auction print late for your night.
This post teach you the clock and the shape of the liquidity. Nothing here na strategy or advice, just where the trading dey happen on a Lagos wall clock.
US session for WAT clock: the two cases
Regular New York session na 9:30 a.m. till 4:00 p.m. ET, six and half hours. WAT sit for UTC+1 the whole year, and Nigeria no dey do daylight saving. New York sit for UTC-4 during dem summer (dem call am EDT) and UTC-5 during dem winter (EST). Join the two and you get two clocks, nothing in between:
- US summer time, from the second Sunday of March till the first Sunday of November: open 14:30 WAT, close 21:00 WAT.
- US winter time, from the first Sunday of November till the second Sunday of March: open 15:30 WAT, close 22:00 WAT.
The extended hours dey slide the same way. US premarket and after-hours trading open from 4:00 a.m. ET, wey na 09:00 WAT during US summer time, and the after-hours tape no close till 01:00 WAT. Note that 01:00 WAT na already the next calendar day for Lagos, even though na still the same American session day. Na this one dey confuse people wey dey log their trades by date.
Where the volume dey thick on your Lagos clock
The panel below take four of the most traded US names, SPY, AAPL, MSFT and NVDA, and break their minute bar volume from June till September 2026 into hour buckets. Every hour carry two labels, one for Lagos and one for New York, and the share column show how much of the full tape day (premarket and after-hours included) land inside that hour. The whole window sit inside US summer time, so the WAT labels no jump midway.
| wat_time | et_time | share_of_volume_pct | avg_volume_m |
|---|---|---|---|
| 09:00 | 04:00 | 0.48 | 1.1 |
| 10:00 | 05:00 | 0.15 | 0.3 |
| 11:00 | 06:00 | 0.17 | 0.4 |
| 12:00 | 07:00 | 0.65 | 1.4 |
| 13:00 | 08:00 | 0.97 | 2.2 |
| 14:00 | 09:00 | 15.41 | 34.4 |
| 15:00 | 10:00 | 16 | 35.7 |
| 16:00 | 11:00 | 12.04 | 26.9 |
| 17:00 | 12:00 | 9.92 | 22.2 |
| 18:00 | 13:00 | 8.65 | 19.3 |
| 19:00 | 14:00 | 9.22 | 20.6 |
| 20:00 | 15:00 | 19.34 | 43.2 |
| 21:00 | 16:00 | 5.64 | 12.6 |
| 22:00 | 17:00 | 0.86 | 1.9 |
| 23:00 | 18:00 | 0.3 | 0.7 |
| 00:00 | 19:00 | 0.19 | 0.4 |
The exact SQL behind every number
WITH bars AS
(
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
toHour(toTimeZone(window_start, 'America/New_York')) AS et_hour,
toStartOfHour(window_start) AS bucket_ts,
volume
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'NVDA')
AND window_start >= '2026-06-01 00:00:00'
AND window_start < '2026-10-01 00:00:00'
),
tape_day AS
(
SELECT sum(volume) AS full_day_volume FROM bars
)
SELECT
formatDateTime(toTimeZone(min(bucket_ts), 'Africa/Lagos'), '%H:%i') AS wat_time,
formatDateTime(toTimeZone(min(bucket_ts), 'America/New_York'), '%H:%i') AS et_time,
round(sum(volume) / (SELECT full_day_volume FROM tape_day) * 100, 2) AS share_of_volume_pct,
round(sum(volume) / countDistinct(session_date) / 1000000, 1) AS avg_volume_m
FROM bars
GROUP BY et_hour
ORDER BY et_hourThe tape print bars inside 16 different WAT hours. The first one, 09:00 WAT, carry 0.48% of the whole day, and the last one, 00:00 WAT, carry 0.19%. Look the chart and you go see say the volume no dey waka from morning: for Lagos morning and early afternoon the bars flat like pancake, and the real trading only start to pile up from the time New York ring bell.
Half hour by half hour: open burst, midday die off, closing spike
Hour buckets too wide to show you the two spikes, so this next panel zoom into half hours, from the 9:30 a.m. ET open through the 4:00 p.m. ET cross and the first half hour after am. Same four names, same four months.
| wat_time | et_time | share_of_volume_pct | avg_volume_m |
|---|---|---|---|
| 14:30 | 09:30 | 14.77 | 33 |
| 15:00 | 10:00 | 8.86 | 19.8 |
| 15:30 | 10:30 | 7.14 | 16 |
| 16:00 | 11:00 | 6.45 | 14.4 |
| 16:30 | 11:30 | 5.59 | 12.5 |
| 17:00 | 12:00 | 5.19 | 11.6 |
| 17:30 | 12:30 | 4.73 | 10.6 |
| 18:00 | 13:00 | 4.47 | 10 |
| 18:30 | 13:30 | 4.18 | 9.3 |
| 19:00 | 14:00 | 4.48 | 10 |
| 19:30 | 14:30 | 4.74 | 10.6 |
| 20:00 | 15:00 | 5.72 | 12.8 |
| 20:30 | 15:30 | 13.62 | 30.4 |
| 21:00 | 16:00 | 4.99 | 11.1 |
The exact SQL behind every number
WITH bars AS
(
SELECT
toDate(toTimeZone(window_start, 'America/New_York')) AS session_date,
toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute_of_day,
toStartOfInterval(window_start, INTERVAL 30 MINUTE) AS bucket_ts,
volume
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker IN ('SPY', 'AAPL', 'MSFT', 'NVDA')
AND window_start >= '2026-06-01 00:00:00'
AND window_start < '2026-10-01 00:00:00'
),
tape_day AS
(
SELECT sum(volume) AS full_day_volume FROM bars
)
SELECT
formatDateTime(toTimeZone(min(bucket_ts), 'Africa/Lagos'), '%H:%i') AS wat_time,
formatDateTime(toTimeZone(min(bucket_ts), 'America/New_York'), '%H:%i') AS et_time,
round(sum(volume) / (SELECT full_day_volume FROM tape_day) * 100, 2) AS share_of_volume_pct,
round(sum(volume) / countDistinct(session_date) / 1000000, 1) AS avg_volume_m
FROM bars
WHERE et_minute_of_day >= 570
AND et_minute_of_day < 990
GROUP BY intDiv(et_minute_of_day, 30)
ORDER BY intDiv(et_minute_of_day, 30)Start from the top row. The opening half hour, 14:30 WAT (09:30 New York), carry 14.77% of the full day volume on its own, wey work out to about 33 million shares across the four names every session. Na the thickest part of the Lagos afternoon, and na also the part wey land inside work hours for plenty people.
From there the thing drop steady. By 17:00 WAT the half hour hold only 5.19%. That quiet stretch na the same lunchtime lull wey we break down for why trading volume dey die for midday, except for your clock e no happen for lunchtime at all. E happen for your evening.
Then the tape wake up again. The 20:30 WAT bucket carry 13.62%, and the bucket wey hold the 4:00 p.m. ET cross, 21:00 WAT, carry 4.99% with about 11.1 million shares. That one na the closing auction print showing up as one big block of volume for your night. If you dey compare any single day against normal, average daily volume and relative volume na the two yardsticks wey match this kind clock work.
Why order wey you type by 19:00 WAT sit for the deadest part
19:00 WAT na 2:00 p.m. in New York during US summer time. Na the stretch after the morning crowd finish and before the closing crowd show face. Inside the panel above, the 19:00 WAT half hour hold 4.48% of the day. Compare am with the 14.77% wey the open bucket carry and you see the gap.
When volume thin like that, two things dey happen for the book. Fewer shares dey sitting on each price level, so the same size order dey chop more price levels before e fill. And the quote dey wider, wey mean the gap between wetin buyer dey offer and wetin seller dey ask grow. Na the second one you fit measure directly.
Wetin the clock cost you for spread
The bid-ask spread na the toll you pay to enter and exit sharp sharp. This panel take one pinned session, Wednesday 10 June 2026, and average SPY quoted spread for every half hour from 09:00 ET till 16:30 ET, with the Lagos clock label on top.
| wat_time | et_time | avg_spread_cents | avg_spread_bps |
|---|---|---|---|
| 14:00 | 09:00 | 6.24 | 0.85 |
| 14:30 | 09:30 | 2.75 | 0.37 |
| 15:00 | 10:00 | 2.61 | 0.35 |
| 15:30 | 10:30 | 2.68 | 0.37 |
| 16:00 | 11:00 | 2.92 | 0.4 |
| 16:30 | 11:30 | 3.65 | 0.5 |
| 17:00 | 12:00 | 3.21 | 0.44 |
| 17:30 | 12:30 | 3.33 | 0.46 |
| 18:00 | 13:00 | 2.89 | 0.4 |
| 18:30 | 13:30 | 2.98 | 0.41 |
| 19:00 | 14:00 | 2.85 | 0.39 |
| 19:30 | 14:30 | 2.78 | 0.38 |
| 20:00 | 15:00 | 2.39 | 0.33 |
| 20:30 | 15:30 | 2.26 | 0.31 |
| 21:00 | 16:00 | 6.7 | 0.92 |
| 21:30 | 16:30 | 7.5 | 1.04 |
The exact SQL behind every number
SELECT
formatDateTime(toTimeZone(toStartOfInterval(sip_timestamp, INTERVAL 30 MINUTE), 'Africa/Lagos'), '%H:%i') AS wat_time,
formatDateTime(toTimeZone(toStartOfInterval(sip_timestamp, INTERVAL 30 MINUTE), 'America/New_York'), '%H:%i') AS et_time,
round(avg(toFloat64(ask_price - bid_price)) * 100, 2) AS avg_spread_cents,
round(avg(toFloat64(ask_price - bid_price) / toFloat64(ask_price + bid_price) * 2) * 10000, 2) AS avg_spread_bps
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'SPY'
AND sip_timestamp >= '2026-06-10 13:00:00'
AND sip_timestamp < '2026-06-10 21:00:00'
AND bid_price > 0
AND ask_price > bid_price
GROUP BY toStartOfInterval(sip_timestamp, INTERVAL 30 MINUTE)
ORDER BY toStartOfInterval(sip_timestamp, INTERVAL 30 MINUTE)For 14:00 WAT, before New York open, SPY quote average 6.24 cents wide, wey na 0.85 basis points of the price. For 17:00 WAT, deep inside the US session, the same average land 3.21 cents. By 21:30 WAT, after the American close, e sit 7.5 cents. The chart draw the full shape across 16 half hours of that one day. SPY na one of the tightest names on the tape, so treat these numbers as the floor. A thinner stock go show you wider gaps for the same hours.
The DST switch: how your WAT hour move twice a year
You no need to trust the arithmetic. The data itself show the switch. This panel find the single busiest 30 minutes of SPY volume for each month from December 2025 till September 2026, then print that moment on both clocks and the gap between dem.
| month | month_label | busiest_30min_wat | busiest_30min_et | lagos_minus_ny_hours |
|---|---|---|---|---|
| 2025-12 | Dec 2025 | 22:00 | 16:00 | 6 |
| 2026-01 | Jan 2026 | 21:30 | 15:30 | 6 |
| 2026-02 | Feb 2026 | 21:30 | 15:30 | 6 |
| 2026-03 | Mar 2026 | 20:30 | 15:30 | 5 |
| 2026-04 | Apr 2026 | 20:30 | 15:30 | 5 |
| 2026-05 | May 2026 | 20:30 | 15:30 | 5 |
| 2026-06 | Jun 2026 | 20:30 | 15:30 | 5 |
| 2026-07 | Jul 2026 | 20:30 | 15:30 | 5 |
| 2026-08 | Aug 2026 | 20:30 | 15:30 | 5 |
| 2026-09 | Sep 2026 | 20:30 | 15:30 | 5 |
The exact SQL behind every number
WITH buckets AS
(
SELECT
toStartOfInterval(window_start, INTERVAL 30 MINUTE) AS bucket,
sum(volume) AS bucket_volume
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= '2025-12-01 00:00:00'
AND window_start < '2026-10-01 00:00:00'
GROUP BY bucket
),
monthly AS
(
SELECT
toStartOfMonth(bucket) AS month_start,
argMax(bucket, bucket_volume) AS top_bucket,
max(bucket_volume) AS top_volume
FROM buckets
GROUP BY month_start
)
SELECT
formatDateTime(month_start, '%Y-%m') AS month,
formatDateTime(month_start, '%b %Y') AS month_label,
formatDateTime(toTimeZone(top_bucket, 'Africa/Lagos'), '%H:%i') AS busiest_30min_wat,
formatDateTime(toTimeZone(top_bucket, 'America/New_York'), '%H:%i') AS busiest_30min_et,
modulo(toHour(toTimeZone(top_bucket, 'Africa/Lagos'))
- toHour(toTimeZone(top_bucket, 'America/New_York')) + 24, 24) AS lagos_minus_ny_hours
FROM monthly
ORDER BY month_startFor Dec 2025, the busiest half hour of the month land 22:00 WAT, wey na 16:00 for New York, so Lagos dey 6 hours ahead. By Sep 2026 the busiest half hour land 20:30 WAT for the same 15:30 New York time, and the gap na 5 hours. Nothing change for Lagos. New York just move their clock, and the step for the chart show you the exact month the thing happen.
Data notes
The hour and half hour panels use consolidated minute bars for SPY, AAPL, MSFT and NVDA between 1 June 2026 and 30 September 2026, a window wey sit fully inside US summer time, so no WAT label inside am shift midway. Share columns divide by the full tape day, premarket and after-hours included, so the session buckets no add up to 100%. The last bucket of the session panel cover 4:00 p.m. till 4:30 p.m. ET, wey na where the closing cross print sit, so e mix the auction with the first minutes of after-hours trading. The spread panel pin one single session, 10 June 2026, and skip any quote where ask no dey above bid, so locked and crossed quotes no enter the average.
FAQ
Wetin time US stock market dey open and close for Lagos time?
During US summer time the regular session run 14:30 till 21:00 WAT. During US winter time e run 15:30 till 22:00 WAT. The reason na simple: WAT no dey do daylight saving, while New York move their clock forward in March and back in November.
Which WAT hour carry the most US volume?
The two thick stretches na the opening half hour, 14:30 WAT during US summer time, and the last stretch before and inside the 4:00 p.m. ET close, wey land 20:30 till 21:30 WAT. The panels on this page show the exact share each half hour carry.
Why 19:00 WAT dey so quiet?
19:00 WAT na around 2:00 p.m. in New York during US summer time, the gap between the morning crowd and the closing crowd. The half hour volume for that stretch measure far below the open, and quoted spreads for thinner names dey wider for the same window.
If I get 9 to 5 work, which part of the US day I even go see?
The US open land inside work hours for Lagos, but the closing auction and the last hour land for your evening, from about 20:00 WAT in US summer time and 21:00 WAT in winter. Na the data decide wey part thick; wetin you do with your own evening na your call.
Every panel here carry the exact SQL under am, open any one make you see how the number come. If you wan run the same hour by hour count on your own ticker and your own clock, ask the question in plain English on the Strasmore terminal.