AAPL option trade sizes, one June 2026 session

WITH
session_trades AS
(
    SELECT toUInt32(size) AS contracts
    FROM global_markets.options_trades
    WHERE underlying_symbol = 'AAPL'
      AND sip_timestamp >= '2026-06-16 13:00:00'
      AND sip_timestamp <  '2026-06-16 21:00:00'
      AND size > 0
),
totals AS
(
    SELECT
        count()        AS all_trades,
        sum(contracts) AS all_contracts
    FROM session_trades
)
SELECT
    b.size_bucket                                            AS size_bucket,
    b.trades                                                 AS trade_count,
    round(100 * b.trades / t.all_trades, 1)                  AS share_of_trades_pct,
    round(100 * b.bucket_contracts / t.all_contracts, 1)     AS share_of_contracts_pct
FROM
(
    SELECT
        multiIf(contracts = 1,    '1 contract',
                contracts <= 10,  '2 to 10',
                contracts <= 100, '11 to 100',
                contracts <= 500, '101 to 500',
                                  'over 500') AS size_bucket,
        min(contracts)                        AS bucket_floor,
        count()                               AS trades,
        sum(contracts)                        AS bucket_contracts
    FROM session_trades
    GROUP BY size_bucket
) AS b
CROSS JOIN totals AS t
ORDER BY b.bucket_floor