SPY intraday volume curve vs a flat TWAP schedule, June to August 2026

Name: SPY intraday volume curve vs a flat TWAP schedule, June to August 2026
Creator: Strasmore
Published: 2026-09-28
License: https://www.strasmore.com/terms/

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-09-28, from TWAP vs VWAP vs POV Orders Explained.

as of 2026-09-28 series 13×4read in context →

SPY intraday volume curve vs a flat TWAP schedule, June to August 2026 — 13 rows by 4 columns, computed 2026-09-28 from US exchange, SIP and OPRA data.
et_time	avg_volume_millions	vwap_share_pct	twap_share_pct
09:30	4.61	11.01	7.69
10:00	3.33	7.97	7.69
10:30	2.79	6.66	7.69
11:00	2.47	5.89	7.69
11:30	2.48	5.93	7.69
12:00	2.2	5.25	7.69
12:30	1.97	4.7	7.69
13:00	2.04	4.88	7.69
13:30	1.87	4.47	7.69
14:00	2.28	5.45	7.69
14:30	2.46	5.88	7.69
15:00	3.14	7.52	7.69
15:30	10.21	24.39	7.69

Rows × columns: 13 × 4
Computed: 2026-09-28
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 SPY intraday volume curve vs a flat TWAP schedule, June to August 2026, derived from the stored result.
Column	Type	Range	Notes
`et_time`	text	13 distinct values (09:30, 10:00, 10:30…)
`avg_volume_millions`	number	1.87 to 10.21	count
`vwap_share_pct`	number	4.47 to 24.39	percent
`twap_share_pct`	number	every row is 7.69	percent

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 2026-09-28, and the query below is what returned them.

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 bars AS
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))           AS et_date,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York'))   AS minute_of_day,
        toFloat64(volume)                                              AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 00:00:00', 'UTC')
      AND window_start <  toDateTime('2026-09-01 00:00:00', 'UTC')
    UNION ALL
    SELECT
        toDate(toTimeZone(sip_timestamp, 'America/New_York'))          AS et_date,
        959                                                            AS minute_of_day,
        toFloat64(maxIf(size, has(conditions, 8)))                     AS shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'SPY'
      AND sip_timestamp >= toDateTime('2026-06-01 00:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-09-01 00:00:00', 'UTC')
      AND toHour(sip_timestamp, 'America/New_York') IN (13, 16)
      AND toMinute(sip_timestamp, 'America/New_York') < 10
    GROUP BY et_date
    HAVING countIf(has(conditions, 8)) > 0
),
per_bucket AS
(
    SELECT
        formatDateTime(toDateTime(intDiv(minute_of_day, 30) * 30 * 60, 'UTC'), '%H:%i') AS et_time,
        sum(shares)                                                                 AS bucket_shares,
        countDistinct(et_date)                                                      AS sessions
    FROM bars
    WHERE minute_of_day >= 570
      AND minute_of_day <  960
    GROUP BY et_time
)
SELECT
    b.et_time                                          AS et_time,
    round(b.bucket_shares / b.sessions / 1e6, 2)       AS avg_volume_millions,
    round(100 * b.bucket_shares / t.window_shares, 2)  AS vwap_share_pct,
    round(100 / t.bucket_count, 2)                     AS twap_share_pct
FROM per_bucket AS b
CROSS JOIN
(
    SELECT
        sum(bucket_shares) AS window_shares,
        count()            AS bucket_count
    FROM per_bucket
) AS t
ORDER BY et_time

SQL to run

WITH bars AS
(
    SELECT
        toDate(toTimeZone(window_start, 'America/New_York'))           AS et_date,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York'))   AS minute_of_day,
        toFloat64(volume)                                              AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 00:00:00', 'UTC')
      AND window_start <  toDateTime('2026-09-01 00:00:00', 'UTC')
    UNION ALL
    SELECT
        toDate(toTimeZone(sip_timestamp, 'America/New_York'))          AS et_date,
        959                                                            AS minute_of_day,
        toFloat64(maxIf(size, has(conditions, 8)))                     AS shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'SPY'
      AND sip_timestamp >= toDateTime('2026-06-01 00:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-09-01 00:00:00', 'UTC')
      AND toHour(sip_timestamp, 'America/New_York') IN (13, 16)
      AND toMinute(sip_timestamp, 'America/New_York') < 10
    GROUP BY et_date
    HAVING countIf(has(conditions, 8)) > 0
),
per_bucket AS
(
    SELECT
        formatDateTime(toDateTime(intDiv(minute_of_day, 30) * 30 * 60, 'UTC'), '%H:%i') AS et_time,
        sum(shares)                                                                 AS bucket_shares,
        countDistinct(et_date)                                                      AS sessions
    FROM bars
    WHERE minute_of_day >= 570
      AND minute_of_day <  960
    GROUP BY et_time
)
SELECT
    b.et_time                                          AS et_time,
    round(b.bucket_shares / b.sessions / 1e6, 2)       AS avg_volume_millions,
    round(100 * b.bucket_shares / t.window_shares, 2)  AS vwap_share_pct,
    round(100 / t.bucket_count, 2)                     AS twap_share_pct
FROM per_bucket AS b
CROSS JOIN
(
    SELECT
        sum(bucket_shares) AS window_shares,
        count()            AS bucket_count
    FROM per_bucket
) AS t
ORDER BY et_time

⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent

More from this analysisTWAP vs VWAP vs POV Orders Explained

What a 10% participation order on AAPL could fill each half hour, August 12, 2026 series 13×4 → SPY: median, lowest and highest share of the day's volume per half hour, June to August 2026 series 13×4 → How far volume falls from the open to the 12:30 half hour, five liquid names table 5×6 → Average shares per print, monthly, MSFT and KO series 90×4 → Share of SPY's regular-session volume by five-minute ET bucket series 79×2 → AAPL price vs. running VWAP: July 2, 2026 regular session, sampled every 5 minutes series 78×3 → See all 3,293 queries →