STRASMORE/EXPLORE 2,549 QUERIES

session_speed

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-24, from latency-models-in-hft-backtests.

as of series 78×2read in context →
session_speed — 78 rows by 2 columns, computed from US exchange, SIP and OPRA data.
et_timetrades_per_second
09:30109.5
09:3548.6
09:4037.5
09:4538.7
09:5031.7
09:5537.2
10:0045.4
10:0542.2
10:1041.1
10:1536.9
10:2041.2
10:2538.7
10:3044.7
10:3539.4
10:4045.6
10:4535.7
10:5038.9
10:5544.6
11:0038.2
11:0536.6
11:1039.8
11:1537
11:2036.4
11:2534.7
11:3034.9
11:3532.3
11:4034.8
11:4531.6
11:5036.3
11:5533.9
12:0031.6
12:0535.8
12:1031.6
12:1516.2
12:2021.6
12:2516.4
12:3017.1
12:3519.1
12:4019.1
12:4517.7
12:5017.2
12:5517.8
13:0014.3
13:0514.2
13:1011.8
13:1510.7
13:2011.5
13:2512.8
13:3015.1
13:3512.5
13:4011.8
13:4514.5
13:5012.6
13:5518.5
14:0015.2
14:0515
14:1014.3
14:1514.3
14:2014
14:2515.1
14:3012.8
14:3514.9
14:4016.8
14:4515
14:5014.9
14:5516.3
15:0014.7
15:0514.2
15:1015.3
15:1520.7
15:2018.1
15:2518.3
15:3022.9
15:3521.7
15:4025.6
15:4529.3
15:5072.7
15:55112
Rows × columns
78 × 2
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 session_speed, derived from the stored result.
ColumnTypeRangeNotes
et_time text 78 distinct values (09:30, 09:35, 09:40…)
trades_per_second number 10.7 to 112 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.

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
    formatDateTime(toStartOfFiveMinute(toTimeZone(window_start, 'America/New_York')), '%H:%i') AS et_time,
    round(sum(transactions) / 300, 1)                                                          AS trades_per_second
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'AAPL'
  AND window_start >= '2026-09-15 13:30:00'
  AND window_start <  '2026-09-15 20:00:00'
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 analysislatency-models-in-hft-backtests
quote_staleness ranking 9×2 → book_speed ranking 5×3 → mid_drift ranking 4×2 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → 3m10y and 2s10s spreads, monthly averages over twenty years series 241×4 → See all 2,549 queries →