STRASMORE/EXPLORE 3,256 QUERIES

Quote messages per second, four names, 10:30 to 11:00 a.m. ET

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-10-09, from REST Polling vs WebSockets for Market Data.

as of ranking 4×3read in context →
Quote messages per second, four names, 10:30 to 11:00 a.m. ET — 4 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbolmessages_per_secondbusiest_second_messages
SPY132.31356
NVDA73.71018
AAPL35.8427
KO18.8317
Rows × columns
4 × 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 Quote messages per second, four names, 10:30 to 11:00 a.m. ET, derived from the stored result.
ColumnTypeRangeNotes
symbol text 4 distinct values (AAPL, KO, NVDA…)
messages_per_second number 18.8 to 132.3
busiest_second_messages number 317 to 1,356

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
    symbol,
    round(sum(messages) / 1800.0, 1) AS messages_per_second,
    max(messages)                    AS busiest_second_messages
FROM
(
    SELECT
        ticker                    AS symbol,
        toDateTime(sip_timestamp) AS second_bucket,
        count()                   AS messages
    FROM global_markets.cache_stocks_quotes
    WHERE ticker IN ('AAPL', 'NVDA', 'SPY', 'KO')
      AND sip_timestamp >= '2026-09-15 14:30:00'
      AND sip_timestamp <  '2026-09-15 15:00:00'
    GROUP BY symbol, second_bucket
)
GROUP BY symbol
ORDER BY messages_per_second DESC
⌘/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 analysisREST Polling vs WebSockets for Market Data
NVDA quote updates per second, grouped by how busy the second was ranking 5×3 → AAPL opening minute: quote updates and distinct prices, second by second table 60×4 → AAPL trades per second, fifteen minute buckets through the session series 26×2 → KO: total cash dividends per share by year ranking 22×2 → Correlation of price levels against correlation of daily returns, same pairs ranking 15×4 → Pairwise correlation of daily returns, six large caps, Oct 2025 to Sep 2026 ranking 15×2 → See all 3,256 queries →