STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 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-08-22 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first.
Mini Index Options Explained: XSP, XND, MRUT
SPY ex-dividend dates and cash amounts, trailing three yearsseries · 2026-08-22 · 12×3Preview: a 12-point series, ending higher. Open to close moves on monthly expiration Fridays, SPY since 2015ranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first. Dollar exposure in one 100-multiplier contract, by monthseries · 2026-08-22 · 37×5Preview: a 16-point series, ending higher.
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 option3834.8
QQQOrdinary equity option2349.7
IWMOrdinary equity option941.9
AAPLOrdinary equity option833.5
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
$