3,256 answered market questions

WITH per_venue AS
(
    SELECT
        underlying_symbol AS symbol,
        exchange,
        count()           AS prints
    FROM global_markets.options_trades
    WHERE underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO')
      AND sip_timestamp >= '2026-09-16 00:00:00'
      AND sip_timestamp <  '2026-09-17 00:00:00'
    GROUP BY symbol, exchange
)
SELECT
    symbol,
    count()                                   AS venues_printing,
    round(100 * max(prints) / sum(prints), 1) AS busiest_venue_share_pct
FROM per_venue
GROUP BY symbol
ORDER BY venues_printing DESC, busiest_venue_share_pct ASC