Book events per three second interval across five household names (10:00 to 10:30 a.m. ET, 16 September 2026)

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
    q.ticker                             AS symbol,
    q.quote_updates_per_3s_window        AS quote_updates_per_3s_window,
    round(q.quote_updates / t.trades, 1) AS quote_updates_per_trade
FROM
(
    SELECT
        ticker,
        count()                                                                            AS quote_updates,
        round(count() / uniqExact(toStartOfInterval(sip_timestamp, INTERVAL 3 SECOND)), 1) AS quote_updates_per_3s_window
    FROM global_markets.cache_stocks_quotes
    WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
      AND sip_timestamp >= '2026-09-16 14:00:00'
      AND sip_timestamp <  '2026-09-16 14:30:00'
    GROUP BY ticker
) AS q
INNER JOIN
(
    SELECT
        ticker,
        count() AS trades
    FROM global_markets.stocks_trades
    WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
      AND sip_timestamp >= '2026-09-16 14:00:00'
      AND sip_timestamp <  '2026-09-16 14:30:00'
    GROUP BY ticker
) AS t ON q.ticker = t.ticker
ORDER BY quote_updates_per_3s_window DESC