How fast the tape drains a queue, by time of day (AAPL, June 2026)

Name: How fast the tape drains a queue, by time of day (AAPL, June 2026)
Creator: Strasmore
Published: 2026-08-14
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-08-14, from Does Modifying an Order Lose Queue Priority?.

as of 2026-08-14 series 26×3read in context →

How fast the tape drains a queue, by time of day (AAPL, June 2026) — 26 rows by 3 columns, computed 2026-08-14 from US exchange, SIP and OPRA data.
et_time	avg_k_shares_per_min	median_k_shares_per_min
09:30	290.6	182.8
09:45	149.5	119.9
10:00	137.4	109.2
10:15	112.1	89.8
10:30	107.7	87.7
10:45	103.4	82.6
11:00	89.2	76.7
11:15	85.2	69.6
11:30	97.5	78.8
11:45	82.3	63.8
12:00	84.6	62
12:15	85	52.9
12:30	84.1	57.3
12:45	81.7	61.2
13:00	80.4	57.1
13:15	78.5	54.2
13:30	83.1	58.1
13:45	80.1	54.5
14:00	85.1	58.2
14:15	72.1	51.9
14:30	80	59.8
14:45	83.4	59.7
15:00	89.1	70.8
15:15	103.2	77.3
15:30	121.6	94.4
15:45	358	220.9

Rows × columns: 26 × 3
Period covered: 09:30 to 15:45
Computed: 2026-08-14
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 How fast the tape drains a queue, by time of day (AAPL, June 2026), derived from the stored result.
Column	Type	Range	Notes
`et_time`	date	09:30 to 15:45
`avg_k_shares_per_min`	number	72.1 to 358	count
`median_k_shares_per_min`	number	51.9 to 220.9	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 2026-08-14, and the query below is what returned them.

the exact SQL behind every number

SELECT
    formatDateTime(toStartOfFifteenMinutes(et), '%H:%i')                    AS et_time,
    round(toFloat64(avg(volume)) / 1000, 1)                                 AS avg_k_shares_per_min,
    round(quantileDeterministic(0.5)(toFloat64(volume),
                                     toUInt64(toUnixTimestamp(et))) / 1000, 1) AS median_k_shares_per_min
FROM
(
    SELECT
        toTimeZone(window_start, 'America/New_York') AS et,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= '2026-06-01'
      AND window_start <  '2026-07-01'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
)
GROUP BY et_time
ORDER BY et_time

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 analysisDoes Modifying an Order Lose Queue Priority?

Distinct best bid prices per quarter hour (AAPL and KO, 10 June 2026) series 26×3 → Share of one minute windows carrying at least N shares (June 2026) ranking 9×3 → How often the quoted spread sits at a single cent (10 June 2026 session) ranking 6×3 → The best bid and the price levels it visited, AAPL, 15 minute buckets series 24×3 → Top of book messages against prints on the tape, AAPL, June 10 2026 series 8×4 → Average shares per trade print, June 2026 ranking 8×2 → See all 2,173 queries →