STRASMORE/EXPLORE 2,170 QUERIES

Options trade size distribution on July 2, 2026 (whole-tape contracts per print)

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-14, from How Much Does It Cost to Trade Options?.

as of scalar 1×4read in context →
median contracts
1
p90 contracts
10
avg contracts
6.1
total prints
13.04M
Rows × columns
1 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Options trade size distribution on July 2, 2026 (whole-tape contracts per print), derived from the stored result.
ColumnTypeRangeNotes
median_contracts number every row is 1 count
p90_contracts number every row is 10 count
avg_contracts number every row is 6.1 count
total_prints number every row is 13,035,841

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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 Options bid-ask spreads by product: median basis points, July 2, 2026 regular hours ranking 5×4 AAPL: NBBO quote updates on the latest session scalar 1×4 See all 2,170 queries →