2,170 answered market questions

WITH
    by_venue AS
    (
        SELECT
            toInt32(exchange) AS venue_code,
            sum(size)         AS shares,
            count()           AS prints
        FROM global_markets.stocks_trades
        WHERE ticker = 'AAPL'
          AND sip_timestamp >= '2026-07-15 04:00:00'
          AND sip_timestamp <  '2026-07-16 04:00:00'
        GROUP BY venue_code
    ),
    venue_names AS
    (
        SELECT
            toInt32(id) AS venue_code,
            any(name)   AS venue_name
        FROM global_markets.stocks_exchanges
        WHERE asset_class = 'stocks'
        GROUP BY venue_code
    )
SELECT
    if(empty(n.venue_name), concat('Participant ', toString(v.venue_code)), n.venue_name) AS venue,
    round(100 * v.shares / sum(v.shares) OVER (), 2)                                     AS pct_of_shares,
    toUInt32(round(v.shares / v.prints))                                                 AS avg_trade_size
FROM by_venue AS v
LEFT JOIN venue_names AS n USING (venue_code)
ORDER BY v.shares DESC
LIMIT 12