3,171 answered market questions

SELECT
    bucket,
    trade_count,
    round(100 * trade_count / sum(trade_count) OVER (), 1) AS share_of_trades_pct
FROM
(
    SELECT
        multiIf(size = 1, 1, size <= 5, 2, size <= 10, 3, size <= 50, 4, 5) AS bucket_rank,
        multiIf(bucket_rank = 1, '1 contract',
                bucket_rank = 2, '2 to 5 contracts',
                bucket_rank = 3, '6 to 10 contracts',
                bucket_rank = 4, '11 to 50 contracts',
                                 '51 or more contracts')                     AS bucket,
        count()                                                              AS trade_count
    FROM global_markets.options_trades
    WHERE underlying_symbol = 'SPY'
      AND sip_timestamp >= toDateTime('2026-09-10 13:30:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-09-10 20:30:00', 'UTC')
    GROUP BY bucket_rank, bucket
)
ORDER BY bucket_rank