3,256 answered market questions

SELECT
    venue,
    round(100 * toFloat64(shares) / sum(toFloat64(shares)) OVER (), 2) AS share_of_volume_pct
FROM
(
    SELECT
        coalesce(nullIf(e.venue_name, ''), concat('Venue ', toString(t.exchange))) AS venue,
        sum(t.size)                                                                AS shares
    FROM global_markets.stocks_trades AS t
    LEFT JOIN
    (
        SELECT
            toString(id) AS exchange_id,
            any(name)    AS venue_name
        FROM global_markets.stocks_exchanges
        WHERE asset_class = 'stocks'
        GROUP BY exchange_id
    ) AS e ON e.exchange_id = toString(t.exchange)
    WHERE t.ticker = 'AAPL'
      AND t.sip_timestamp >= toDateTime('2026-06-16 08:00:00', 'UTC')
      AND t.sip_timestamp <  toDateTime('2026-06-17 01:00:00', 'UTC')
    GROUP BY venue
)
ORDER BY share_of_volume_pct DESC
LIMIT 12