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.
Qualified Dividend Holding Period: 61 Days
Every 121-day window around a Coca-Cola ex-dividend dateseries · 2026-08-22 · 14×6Preview: a 14-point series, ending higher. How long after the ex-date the cash actually arrivesranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first. Days between consecutive ex-dividend dates, against the 121-day windowranking · 2026-08-22 · 6×3Preview: 6 ranked values, smallest first.
Why stocks drop on the ex-dividend date
KO: dividend per share against the realised opening drop, every ex-date 2021 to 2025series · 2026-08-14 · 20×4Preview: a 16-point series, roughly flat. Opening drop per dollar of dividend paid, ex-dates 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, largest first. Pooled opening drop per dollar paid, by calendar yearranking · 2026-08-14 · 5×3Preview: 5 ranked values, largest first. Quarterly dividend against ordinary overnight moves, 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, smallest first.
Wash Sale Rule and Options: The 61-Day Window
How many trading sessions fit inside a 61 day wash sale windowseries · 2026-08-13 · 30×4Preview: a 16-point series, roughly flat. One full 61 day wash sale window on the tape: AAPL, Dec 1 2025 through Jan 30 2026series · 2026-08-13 · 42×3Preview: a 16-point series, ending lower. Average call and put delta by strike distance, AAPL, 20 to 45 days to expiry, June 2026ranking · 2026-08-13 · 5×4Preview: 5 ranked values, largest first. Every December session and how far its wash sale window reaches into the new yearseries · 2026-08-13 · 22×4Preview: a 16-point series, ending higher.
Cost Basis Methods: FIFO vs Specific ID
Cheapest to dearest monthly lot in 2024, five household tickersranking · 2026-08-09 · 5×3Preview: 5 ranked values, largest first. Twelve monthly AAPL lots, first regular session of each month of 2024series · 2026-08-09 · 12×3Preview: a 12-point series, ending higher. Realized gain per share on each 2024 lot, sold at the same June 2025 priceseries · 2026-08-09 · 12×3Preview: a 12-point series, ending lower.
Dividends vs Buybacks: Shareholder Yield
Dividend yield, buyback yield and total shareholder yieldranking · 2026-08-08 · 4×4Preview: 4 ranked values, largest first. AAPL diluted share count, every reported quarter since 2021series · 2026-08-08 · 20×3Preview: a 16-point series, ending lower. The exact quarters behind each buyback yieldtable · 2026-08-08 · 4×5 Share of net income already committed to the dividendranking · 2026-08-08 · 8×2Preview: 8 ranked values, largest 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 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
$