STRASMORE/EXPLORE 3,293 QUERIES

Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessions

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-11-07, from Best Stocks for Day Trading Options (Ranked).

as of ranking 15×4read in context →
Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessions — 15 rows by 4 columns, computed from US exchange, SIP and OPRA data.
symbolavg_daily_contracts_millionsexpirations_next_2_weeksatm_30d_iv_pct
SPY3.651019.3
QQQ2.951029.1
NVDA1.82655
IWM1.141022.5
TSLA1.03652
AAPL0.85626.1
INTC0.84271.9
EWZ0.8230.7
MU0.7677.7
TLT0.69612
AMZN0.64635.5
CRWV0.582129.9
IBIT0.481038.7
GOOGL0.48634.1
AMD0.48670.4
Rows × columns
15 × 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 Stock and ETF underlyings ranked by average daily options contract volume, last 20 sessions, derived from the stored result.
ColumnTypeRangeNotes
symbol text 15 distinct values (AAPL, AMD, AMZN…)
avg_daily_contracts_millions number 0.48 to 3.65 count
expirations_next_2_weeks number 2 to 10
atm_30d_iv_pct number 12 to 129.9 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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    (
        SELECT max(date)
        FROM global_markets.options_greeks
        WHERE date >= today() - 40
    ) AS last_session
SELECT
    underlying_symbol                                            AS symbol,
    round(sum(volume) / countDistinct(date) / 1e6, 2)            AS avg_daily_contracts_millions,
    countDistinctIf(expiration_date,
                    date = last_session
                    AND expiration_date <= last_session + 14)    AS expirations_next_2_weeks,
    round(avgIf(implied_volatility,
                date = last_session
                AND iv_converged = 1
                AND underlying_close > 0
                AND days_to_expiry BETWEEN 20 AND 45
                AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.03) * 100, 1) AS atm_30d_iv_pct
FROM global_markets.options_greeks
WHERE date IN
    (
        SELECT date
        FROM global_markets.options_greeks
        WHERE date >= today() - 40
        GROUP BY date
        ORDER BY date DESC
        LIMIT 20
    )
  AND volume > 0
  AND underlying_symbol NOT IN ('SPCX')
  AND underlying_symbol IN
    (
        SELECT DISTINCT ticker
        FROM global_markets.stocks_daily_aggs
        WHERE date >= today() - 40
    )
GROUP BY underlying_symbol
HAVING countIf(date = last_session
               AND iv_converged = 1
               AND underlying_close > 0
               AND days_to_expiry BETWEEN 20 AND 45
               AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.03) > 0
ORDER BY sum(volume) DESC
LIMIT 15
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

More from this analysisBest Stocks for Day Trading Options (Ranked)
At-the-money spread as a percent of premium, calls expiring next day, Dec 19 2024, 10:00 to 10:30 ET ranking 5×4 → Share of all options contract volume by liquidity tier, last 20 sessions ranking 4×3 → Daily options contract volume, SPY vs QQQ vs IWM vs NVDA, last 20 sessions series 20×6 → SPY options median spread by expiration date, near-the-money strikes only ranking 25×4 → Share of August 2026 options volume expiring within five days, by underlying ranking 6×2 → What 100 shares, one contract's deliverable, cost at the end of August 2026 ranking 6×4 → See all 3,293 queries →