Where Apple trades printed on June 10, 2026, by venue

WITH
    by_venue AS
    (
        SELECT
            toString(exchange) AS venue_id,
            sum(size)          AS shares,
            count()            AS prints
        FROM global_markets.stocks_trades
        WHERE ticker = 'AAPL'
          AND sip_timestamp >= '2026-06-10 00:00:00'
          AND sip_timestamp <  '2026-06-11 00:00:00'
        GROUP BY venue_id
    ),
    venue_names AS
    (
        SELECT
            toString(id) AS venue_id,
            any(name)    AS venue_name
        FROM global_markets.stocks_exchanges
        WHERE asset_class = 'stocks'
        GROUP BY id
    )
SELECT
    if(n.venue_name = '', concat('Venue ', b.venue_id), n.venue_name)                  AS venue,
    round(100 * toFloat64(b.shares) / toFloat64((SELECT sum(shares) FROM by_venue)), 2) AS share_of_volume_pct,
    round(toFloat64(b.shares) / b.prints, 0)                                            AS avg_print_size
FROM by_venue AS b
LEFT JOIN venue_names AS n ON n.venue_id = b.venue_id
ORDER BY share_of_volume_pct DESC
LIMIT 15