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 Only Some Stocks Have Daily Options
Near-dated contract lines traded in one session, by underlyingranking · 2026-10-04 · 7×3Preview: 7 ranked values, largest first. Share of each name's 30-day option volume, by expiration dateseries · 2026-10-04 · 13×5Preview: a 13-point series, ending lower. Expiration dates open in the next 45 days, by underlyingranking · 2026-10-04 · 7×4Preview: 7 ranked values, largest first. Expiration dates traded per month: SPY versus AAPL, since 2021series · 2026-10-04 · 61×3Preview: a 16-point series, roughly flat.
Which Stocks Have Daily Options?
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekdayseries · 2026-10-04 · 5×3Preview: a 5-point series, ending higher. Daily options vs weekly options: upcoming expiration dates for six household tickersranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volumeseries · 2026-10-04 · 12×4Preview: a 12-point series, ending lower. Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeksranking · 2026-10-04 · 20×3Preview: 16 ranked values, largest first.
EURO STOXX 50 Daily Options (OEXP) Explained
SPY's front two weeks of expiries, as of the latest sessionseries · 2026-10-04 · 10×4Preview: a 10-point series, ending lower. Where the Eurex close lands in the US day: FEZ volume share by half hour (ET), trailing two monthsseries · 2026-10-04 · 32×3Preview: a 16-point series, roughly flat. Share of SPY option volume by days to expiry, trailing six weeksranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first.
Eurex Option Codes: ODAX, ODAP, OESX
One US options symbol, taken apart: busiest SPY contracts on 17 June 2026table · 2026-09-22 · 8×6 Distinct expirations traded per underlying, 17 June 2026ranking · 2026-09-22 · 5×2Preview: 5 ranked values, largest first. SPY option volume by days left to expiry, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first. What one US equity option contract covers, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first.
DAX Daily Options: How Eurex 0DTE Works
Same-day expiries as a share of SPY option volume: every session, July 2026series · 2026-08-03 · 21×4Preview: a 16-point series, roughly flat. Expirations on the SPY option board: every listed expiry over 30 days, 16 July 2026series · 2026-08-03 · 13×4Preview: a 13-point series, ending lower. Median implied volatility by days to expiry: near-the-money SPY contracts, 16 July 2026ranking · 2026-08-03 · 5×4Preview: 5 ranked values, smallest first. Distinct expirations listed for the rest of July 2026: eight US namesranking · 2026-08-03 · 8×3Preview: 8 ranked values, largest first.
Near-dated contract lines traded in one session, by underlying

Near-dated contract lines traded in one session, by underlying

most recentas of ranking 7×3read in context →
Near-dated contract lines traded in one session, by underlying — 7 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbollines_tradedpct_under_10_lots
SPY131513.8
QQQ118116.6
IWM50022.8
MSFT42336.2
NVDA36412.1
AAPL29025.2
KO6624.2
the exact SQL behind every number 
WITH (SELECT max(date) FROM global_markets.options_greeks) AS asof
SELECT
    underlying_symbol                               AS symbol,
    count()                                         AS lines_traded,
    round(100 * countIf(volume < 10) / count(), 1)  AS pct_under_10_lots
FROM global_markets.options_greeks
WHERE date = asof
  AND underlying_symbol IN ('SPY', 'QQQ', 'IWM', 'NVDA', 'AAPL', 'MSFT', 'KO')
  AND volume > 0
  AND days_to_expiry BETWEEN 0 AND 10
GROUP BY underlying_symbol
ORDER BY lines_traded DESC
More from this analysisWhy Only Some Stocks Have Daily Options
Expiration dates open in the next 45 days, by underlying ranking 7×4 → Expiration dates traded per month: SPY versus AAPL, since 2021 series 61×3 → Share of each name's 30-day option volume, by expiration date series 13×5 → Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeks ranking 20×3 → See all 3,256 queries →
$