STRASMORE/EXPLORE 2,170 QUERIES

Prints per 15-minute bucket, one full session

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-13, from Self-Match Prevention and Wash Trades.

as of series 64×2read in context →
Prints per 15-minute bucket, one full session — 64 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timetrade_count
04:009402
04:15396
04:30565
04:45671
05:00389
05:15462
05:30436
05:45347
06:00448
06:15359
06:30334
06:45452
07:00958
07:15675
07:30775
07:45972
08:00624
08:15629
08:301882
08:451132
09:001257
09:151255
09:3088813
09:4550105
10:0047616
10:1547896
10:3056560
10:4543196
11:0040476
11:1539131
11:3037425
11:4545348
12:0037115
12:1526888
12:3024226
12:4523894
13:0020116
13:1521482
13:3022375
13:4531609
14:0026873
14:1523193
14:3021945
14:4523308
15:0024243
15:1530349
15:3026734
15:4567977
16:002305
16:151030
16:30956
16:451265
17:001699
17:151131
17:301169
17:451297
18:001372
18:151021
18:30920
18:451098
19:001108
19:151232
19:301330
19:451345
Rows × columns
64 × 2
Period covered
to
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 Prints per 15-minute bucket, one full session, derived from the stored result.
ColumnTypeRangeNotes
et_time date 04:00 to 19:45
trade_count number 334 to 88,813 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 , and the query below is what returned them.

the exact SQL behind every number 
SELECT
    formatDateTime(toStartOfInterval(toTimeZone(sip_timestamp, 'America/New_York'), INTERVAL 15 MINUTE), '%H:%i') AS et_time,
    count() AS trade_count
FROM global_markets.stocks_trades
WHERE ticker = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-06-10 08:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-06-11 04:00:00', 'UTC')
GROUP BY et_time
HAVING count() >= 200
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 analysisSelf-Match Prevention and Wash Trades
Option contracts with volume on one underlying, June 2026 series 21×3 → Trade condition flags on one full session ranking 10×3 → Venues quoting and printing the same stock in one 15-minute window ranking 6×3 → Average shares per trade print, June 2026 ranking 8×2 → Quote updates per second and average quoted spread, ten minutes on 17 June 2026 ranking 5×3 → AAPL option prints by contract count, 17 June 2026 ranking 5×2 → See all 2,170 queries →