Where AAPL prints fall by trade size, June 17, 2026

SELECT
    size_bucket,
    round(100 * trade_count / sum(trade_count) OVER (), 2) AS pct_of_trades,
    round(100 * shares / sum(shares) OVER (), 2)           AS pct_of_shares
FROM
(
    SELECT
        multiIf(size < 100,  '1 to 99 (odd lot)',
                size < 500,  '100 to 499',
                size < 2000, '500 to 1,999',
                size < 5000, '2,000 to 4,999',
                             '5,000 and up') AS size_bucket,
        min(size)                            AS min_size,
        count()                              AS trade_count,
        sum(size)                            AS shares
    FROM global_markets.stocks_trades
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= '2026-06-17 11:00:00'
      AND sip_timestamp <  '2026-06-17 22:00:00'
      AND size > 0
    GROUP BY size_bucket
)
ORDER BY min_size