Distinct venues printing AAPL inside the same second, minute by minute

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(toTimeZone(minute_utc, 'America/New_York'), '%H:%i') AS et_time,
    max(venues_printing)                                               AS max_venues_in_a_second,
    round(avg(venues_printing), 1)                                     AS avg_venues_in_a_second
FROM
(
    SELECT
        toStartOfMinute(toDateTime(sip_timestamp)) AS minute_utc,
        toDateTime(sip_timestamp)                  AS second_utc,
        uniqExact(exchange)                        AS venues_printing
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= '2026-06-10 14:00:00'
      AND sip_timestamp <  '2026-06-10 14:30:00'
    GROUP BY minute_utc, second_utc
)
GROUP BY minute_utc
ORDER BY minute_utc