2,170 answered market questions

SELECT
    if(venue_name = '', concat('Venue ', toString(venue_id)), venue_name) AS venue,
    prints_10k_plus,
    avg_shares_per_print
FROM
(
    SELECT
        toInt32(exchange)               AS venue_id,
        countIf(size >= 10000)          AS prints_10k_plus,
        round(avg(toFloat64(size)), 0)  AS avg_shares_per_print
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-06-10 00:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-11 00:00:00', 'UTC')
    GROUP BY venue_id
) AS v
LEFT JOIN
(
    SELECT
        toInt32(id) AS venue_id,
        any(name)   AS venue_name
    FROM global_markets.stocks_exchanges
    GROUP BY venue_id
) AS e USING (venue_id)
ORDER BY prints_10k_plus DESC
LIMIT 12