One session of SPY prints, sorted into trade size buckets

WITH
    tape AS
    (
        SELECT size
        FROM global_markets.stocks_trades
        WHERE ticker = 'SPY'
          AND sip_timestamp >= '2026-06-17 13:30:00'
          AND sip_timestamp <  '2026-06-17 20:00:00'
          AND size > 0
    ),
    day_total AS
    (
        SELECT
            sum(size) AS all_shares,
            count()   AS all_prints
        FROM tape
    )
SELECT
    multiIf(t.size < 100,   '1 to 99',
            t.size < 1000,  '100 to 999',
            t.size < 10000, '1,000 to 9,999',
                            '10,000 and up')        AS bucket,
    count()                                         AS trade_count,
    round(100 * count() / any(d.all_prints), 2)     AS pct_of_prints,
    round(100 * sum(t.size) / any(d.all_shares), 2) AS pct_of_volume
FROM tape AS t
CROSS JOIN day_total AS d
GROUP BY bucket
ORDER BY min(t.size)