2,358 answered market questions

SELECT
    coalesce(nullIf(e.venue, ''), concat('exchange ', toString(t.exchange_id))) AS venue,
    toString(t.exchange_id)                                                     AS exchange_id,
    t.print_count                                                               AS print_count,
    formatReadableQuantity(t.print_count)                                       AS prints_label,
    round(100 * t.print_count / sum(t.print_count) OVER (), 1)                  AS share_pct
FROM
(
    SELECT
        toUInt32(exchange) AS exchange_id,
        count()            AS print_count
    FROM global_markets.options_trades
    WHERE underlying_symbol = 'SPY'
      AND sip_timestamp >= '2025-05-15 00:00:00'
      AND sip_timestamp <  '2025-05-16 00:00:00'
    GROUP BY exchange_id
) AS t
LEFT JOIN
(
    SELECT
        toUInt32(id) AS exchange_id,
        any(name)    AS venue
    FROM global_markets.stocks_exchanges
    WHERE asset_class = 'options'
    GROUP BY exchange_id
) AS e ON t.exchange_id = e.exchange_id
ORDER BY print_count DESC