Where 30 minutes of AAPL prints landed, by venue

WITH
    prints AS
    (
        SELECT
            toString(exchange) AS venue_id,
            count()            AS print_count
        FROM global_markets.stocks_trades
        WHERE ticker = 'AAPL'
          AND sip_timestamp >= '2026-06-10 14:00:00'
          AND sip_timestamp <  '2026-06-10 14:30:00'
        GROUP BY venue_id
    ),
    venues AS
    (
        SELECT
            toString(id) AS venue_id,
            any(name)    AS venue_name
        FROM global_markets.stocks_exchanges
        GROUP BY venue_id
    )
SELECT
    if(empty(v.venue_name), concat('Venue ', p.venue_id), v.venue_name) AS venue,
    p.print_count                                                       AS print_count,
    round(100 * p.print_count / sum(p.print_count) OVER (), 1)          AS share_pct
FROM prints AS p
LEFT JOIN venues AS v USING (venue_id)
ORDER BY print_count DESC
LIMIT 12