3,256 answered market questions

WITH venue_volume AS
(
    SELECT
        toString(exchange) AS exchange_id,
        sum(size)          AS contracts
    FROM global_markets.options_trades
    WHERE underlying_symbol = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-09-15 00:00:00')
      AND sip_timestamp <  toDateTime('2026-09-16 00:00:00')
    GROUP BY exchange_id
),
venue_names AS
(
    SELECT
        toString(id) AS exchange_id,
        any(acronym) AS code,
        any(name)    AS full_name
    FROM global_markets.stocks_exchanges
    WHERE asset_class = 'options'
    GROUP BY exchange_id
)
SELECT
    coalesce(nullIf(n.code, ''), nullIf(n.full_name, ''), concat('ID ', v.exchange_id)) AS venue,
    round(toFloat64(v.contracts) / 1000, 1)                                             AS contracts_thousands,
    round(100 * toFloat64(v.contracts) / sum(toFloat64(v.contracts)) OVER (), 1)        AS share_pct
FROM venue_volume AS v
LEFT JOIN venue_names AS n USING (exchange_id)
ORDER BY share_pct DESC