priority — 4 answered market questions

Apple option trades on June 17 2026: share of prints vs share of contracts, by trade size

most recentas of 2026-08-07 ranking 5×3read in context →

Apple option trades on June 17 2026: share of prints vs share of contracts, by trade size — 5 rows by 3 columns, computed 2026-08-07 from US exchange, SIP and OPRA data.
size_bucket	share_of_trades_pct	share_of_volume_pct
1 contract	48.48	7.83
2 to 5	31.02	16.39
6 to 20	15.5	26.95
21 to 100	4.56	32.15
over 100	0.44	16.67

the exact SQL behind every number

WITH
    (
        SELECT count()
        FROM global_markets.options_trades
        WHERE underlying_symbol = 'AAPL'
          AND sip_timestamp >= toDateTime('2026-06-17 00:00:00', 'UTC')
          AND sip_timestamp <  toDateTime('2026-06-18 00:00:00', 'UTC')
    ) AS day_prints,
    (
        SELECT sum(size)
        FROM global_markets.options_trades
        WHERE underlying_symbol = 'AAPL'
          AND sip_timestamp >= toDateTime('2026-06-17 00:00:00', 'UTC')
          AND sip_timestamp <  toDateTime('2026-06-18 00:00:00', 'UTC')
    ) AS day_contracts
SELECT
    multiIf(size = 1,    '1 contract',
            size <= 5,   '2 to 5',
            size <= 20,  '6 to 20',
            size <= 100, '21 to 100',
                         'over 100')       AS size_bucket,
    round(100 * count()   / day_prints, 2) AS share_of_trades_pct,
    round(100 * sum(size) / day_contracts, 2) AS share_of_volume_pct
FROM global_markets.options_trades
WHERE underlying_symbol = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-06-17 00:00:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-06-18 00:00:00', 'UTC')
GROUP BY size_bucket
ORDER BY min(size)

More from this analysisWhy Your Options Order Isn't Getting Filled

Apple option activity by strike distance, 20 to 45 days to expiry, May and June 2026 ranking 5×3 → Median quoted spread on Apple options by contract price, 30 second window on June 17 2026 ranking 5×3 → Apple options quote updates, second by second, 2:00 p.m. ET on June 17 2026 series 30×3 → AAPL trades by venue, latest session: off-exchange first ranking 19×4 → See all 2,173 queries →