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.
SPX vs SPY Options: Which One to Trade
SPY option volume by days to expiry, trailing six weeksranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first. Time value left in deep in-the-money SPY calls, against the dividend at stakeranking · 2026-08-22 · 16×4Preview: 16 ranked values, smallest first. How close SPY closes to the nearest whole-dollar strike on monthly expirationsseries · 2026-08-22 · 13×4Preview: a 13-point series, ending lower. What one contract controls: SPX, SPY and XSPranking · 2026-08-22 · 3×4Preview: 3 ranked values, largest first.
AM vs PM Settled Index Options Explained
The same hypothetical on every session: expiration mornings against the rest of the tapetable · 2026-08-03 · 3×5 The prices behind the arithmetic: Thursday's close, the strike, Friday's open and closeseries · 2026-08-03 · 29×6Preview: a 16-point series, ending higher. One at-the-money call settled two ways: the ten widest splits since January 2024table · 2026-08-03 · 10×5 Every monthly expiration since January 2024: the overnight gap, then the session that followedseries · 2026-08-03 · 29×4Preview: a 16-point series, ending lower.
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
$