Where AAPL trades printed, June 17 2026, 10:00 to 11:30 ET

SELECT
    if(empty(x.venue_name), concat('Venue ', toString(a.exchange_id)), x.venue_name) AS venue,
    a.prints           AS prints,
    a.shares_thousands AS shares_thousands
FROM
(
    SELECT
        toUInt32(exchange)           AS exchange_id,
        count()                      AS prints,
        round(sum(size) / 1000.0, 1) AS shares_thousands
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= '2026-06-17 14:00:00'
      AND sip_timestamp <  '2026-06-17 15:30:00'
    GROUP BY exchange_id
) AS a
LEFT JOIN
(
    SELECT
        toUInt32(id) AS exchange_id,
        any(name)    AS venue_name
    FROM global_markets.stocks_exchanges
    WHERE asset_class = 'stocks'
    GROUP BY exchange_id
) AS x ON x.exchange_id = a.exchange_id
ORDER BY prints DESC
LIMIT 20