STRASMORE/EXPLORE 3,293 QUERIES

Share of monthly volume by 15-minute ET clock slice, SPY and AAPL

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-11-07, from Does the PDT Rule Apply to Crypto and Futures?.

as of series 64×3read in context →
Share of monthly volume by 15-minute ET clock slice, SPY and AAPL — 64 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timespy_volume_pctaapl_volume_pct
04:000.2140.317
04:150.0340.068
04:300.040.052
04:450.0390.052
05:000.0410.04
05:150.030.052
05:300.030.056
05:450.0280.056
06:000.0360.038
06:150.040.036
06:300.0720.047
06:450.0570.039
07:000.1380.193
07:150.0990.087
07:300.1130.145
07:450.1930.137
08:000.2340.192
08:150.2040.32
08:300.4370.338
08:450.2540.25
09:000.2350.219
09:150.440.433
09:305.95312.305
09:453.8515.246
10:003.264.508
10:153.2283.646
10:303.0663.47
10:452.8373.287
11:002.7073.274
11:152.6512.677
11:302.7263.071
11:452.1052.252
12:002.0092.545
12:151.7922.175
12:301.8422.197
12:452.3332.267
13:002.0392.408
13:151.8542.148
13:301.9612.129
13:452.3022.311
14:002.5472.357
14:152.2542.3
14:302.6241.888
14:452.7782.277
15:003.1722.85
15:153.6452.876
15:304.2123.5
15:4515.2989.725
16:006.314.849
16:153.9890.358
16:300.4130.633
16:450.4450.303
17:000.1050.096
17:150.0830.247
17:300.0660.245
17:450.0670.11
18:000.1710.072
18:150.0720.064
18:300.0560.042
18:450.0340.041
19:000.0340.021
19:150.0310.018
19:300.0330.019
19:450.0390.027
Rows × columns
64 × 3
Computed
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 Share of monthly volume by 15-minute ET clock slice, SPY and AAPL, derived from the stored result.
ColumnTypeRangeNotes
et_time text 64 distinct values (04:00, 04:15, 04:30…)
spy_volume_pct number 0.028 to 15.298 percent
aapl_volume_pct number 0.018 to 12.305 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 , 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.

SELECT
    et_time,
    round(100 * spy_vol  / sum(spy_vol)  OVER (), 3) AS spy_volume_pct,
    round(100 * aapl_vol / sum(aapl_vol) OVER (), 3) AS aapl_volume_pct
FROM
(
    SELECT
        formatDateTime(
            toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 15 MINUTE),
            '%H:%i')                              AS et_time,
        toFloat64(sumIf(volume, ticker = 'SPY'))  AS spy_vol,
        toFloat64(sumIf(volume, ticker = 'AAPL')) AS aapl_vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'AAPL')
      AND window_start >= today() - 30
      AND window_start <  today() - 2
    GROUP BY et_time
)
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.

More from this analysisDoes the PDT Rule Apply to Crypto and Futures?
Calendar days spanned by each rolling five-session window series 79×3 → Regular session, premarket and after-hours share of volume ranking 4×4 → SPY contract volume by days to expiry, September 2026 ranking 4×3 → VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included) series 30×2 → Distinct SPY expiration dates traded each week series 13×3 → Share of August 2026 options volume expiring within five days, by underlying ranking 6×2 → See all 3,293 queries →