How Much Does It Cost to Trade Options?
Options trade size distribution on July 2, 2026 (whole-tape contracts per print)scalar ·
2026-08-14 · 1×41
SPY options vs. SPY stock on one session: quote count, trade count, and median quoted spreadscalar ·
2026-08-14 · 1×10462.93M
SPY options quoted-spread distribution: percentiles in basis pointsscalar ·
2026-08-14 · 1×635.51
SPY options quote quality: valid, one-sided, and locked/crossed recordsscalar ·
2026-08-14 · 1×7463.20M
SPY options median spread by expiration date, near-the-money strikes onlyranking ·
2026-08-14 · 25×4
Options bid-ask spreads by product: median basis points, July 2, 2026 regular hoursranking ·
2026-08-14 · 5×4
Options trade size distribution on July 2, 2026 (whole-tape contracts per print)
Options trade size distribution on July 2, 2026 (whole-tape contracts per print)
median contracts
1
p90 contracts
10
avg contracts
6.1
total prints
13.04M
the exact SQL behind every number
WITH trades AS (
SELECT toFloat64(size) AS size FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-02 13:30:00' AND sip_timestamp < '2026-07-02 20:00:00'
)
SELECT
round(quantileExact(0.50)(size), 0) AS median_contracts,
round(quantileExact(0.90)(size), 0) AS p90_contracts,
round(avg(size), 1) AS avg_contracts,
count() AS total_prints
FROM trades
More from this analysisHow Much Does It Cost to Trade Options?
SPY options vs. SPY stock on one session: quote count, trade count, and median quoted spread
scalar 1×10
→
SPY options quoted-spread distribution: percentiles in basis points
scalar 1×6
→
SPY options quote quality: valid, one-sided, and locked/crossed records
scalar 1×7
→
SPY options median spread by expiration date, near-the-money strikes only
ranking 25×4
→
See all 2,170 queries →