STRASMORE/EXPLORE 2,309 QUERIES

spy_trade_sizes

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-09-17, from the-390-rule-in-options-trading.

as of ranking 5×3read in context →
spy_trade_sizes — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
buckettrade_countshare_of_trades_pct
1 contract64243747.8
2 to 5 contracts41023230.5
6 to 10 contracts1290689.6
11 to 50 contracts1324139.9
51 or more contracts290282.2
Rows × columns
5 × 3
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 spy_trade_sizes, derived from the stored result.
ColumnTypeRangeNotes
bucket text 5 distinct values
trade_count number 29,028 to 642,437 count
share_of_trades_pct number 2.2 to 47.8 percent

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 
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

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 analysisthe-390-rule-in-options-trading
one_lot_share ranking 6×4 → session_shape series 16×3 → spy_option_pace series 14×3 → Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays ranking 25×4 → Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years) ranking 25×3 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → See all 2,309 queries →