3,256 answered market questions

SELECT
    venue,
    round(shares / 1e6, 2)                        AS shares_millions,
    round(100 * shares / sum(shares) OVER (), 1)  AS pct_of_shares,
    prints
FROM
(
    SELECT
        any(if(empty(x.name), concat('Venue ', toString(t.exchange)), x.name)) AS venue,
        sum(t.size)                                                           AS shares,
        count()                                                               AS prints
    FROM global_markets.stocks_trades AS t
    LEFT JOIN global_markets.stocks_exchanges AS x ON x.id = t.exchange
    WHERE t.ticker = 'AAPL'
      AND t.sip_timestamp >= '2026-09-15 00:00:00'
      AND t.sip_timestamp <  '2026-09-16 00:00:00'
      AND (toHour(toTimeZone(t.sip_timestamp, 'America/New_York')) * 60
           + toMinute(toTimeZone(t.sip_timestamp, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(t.sip_timestamp, 'America/New_York')) * 60
           + toMinute(toTimeZone(t.sip_timestamp, 'America/New_York'))) < 960
    GROUP BY t.exchange
)
ORDER BY shares_millions DESC
LIMIT 15