STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first.
SPX Options vs ES Futures Options: Which to Use
Daily S&P 500 moves by month, measured on SPYseries · 2026-10-04 · 13×6Preview: a 13-point series, ending lower. Share of SPY volume by hour of the day (ET), trailing monthranking · 2026-10-04 · 16×2Preview: 16 ranked values, largest first.
Mini Index Options Explained: XSP, XND, MRUT
SPY ex-dividend dates and cash amounts, trailing three yearsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Open to close moves on monthly expiration Fridays, SPY since 2015ranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Dollar exposure in one 100-multiplier contract, by monthseries · 2026-10-04 · 37×5Preview: a 16-point series, ending higher.
How Are Event Contracts Taxed? 60/40 or Not
Illustrative at a 37% ordinary rate: tax on a $10,000 gain, and the deductible part of a $10,000 loss with no offsetting gainsranking · 2026-10-02 · 3×3Preview: 3 ranked values, smallest first.
Average daily options volume: Section 1256 names against equity options

Average daily options volume: Section 1256 names against equity options

most recentas of ranking 4×3read in context →
Average daily options volume: Section 1256 names against equity options — 4 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symboltax_treatmentavg_daily_contracts_k
SPYOrdinary equity option3660
QQQOrdinary equity option2328.7
IWMOrdinary equity option919.6
AAPLOrdinary equity option885.8
the exact SQL behind every number 
SELECT
    replaceOne(underlying_symbol, 'I:', '')            AS symbol,
    if(symbol IN ('SPX', 'XSP', 'NDX', 'RUT', 'VIX'),
       'Section 1256 (60/40)',
       'Ordinary equity option')                       AS tax_treatment,
    round(sum(volume) / countDistinct(date) / 1000, 1) AS avg_daily_contracts_k
FROM global_markets.options_greeks
WHERE date >= today() - 90
  AND symbol IN ('SPX', 'XSP', 'NDX', 'RUT', 'VIX', 'SPY', 'QQQ', 'IWM', 'AAPL')
  AND volume > 0
GROUP BY symbol
ORDER BY avg_daily_contracts_k DESC
More from this analysisWhy Index Options Are Taxed 60/40: Section 1256
Share of contract volume by days to expiry, SPX and SPY ranking 5×3 → Share of SPY volume by hour of the day (ET), trailing month ranking 16×2 → Time value left in deep in-the-money SPY calls, against the dividend at stake ranking 15×4 → SPY option volume by days to expiry, trailing six weeks ranking 5×3 → See all 3,256 queries →
$