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

3,293 answered market questions

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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
Why Only Some Stocks Have Daily Options
Near-dated contract lines traded in one session, by underlyingranking · 2026-11-01 · 7×3Preview: 7 ranked values, largest first. Share of each name's 30-day option volume, by expiration dateseries · 2026-11-01 · 13×5Preview: a 13-point series, ending lower. Expiration dates open in the next 45 days, by underlyingranking · 2026-11-01 · 7×4Preview: 7 ranked values, largest first. Expiration dates traded per month: SPY versus AAPL, since 2021series · 2026-11-01 · 62×3Preview: a 16-point series, roughly flat.
Which Stocks Have Weekly Options? How to Tell
Optionable underlyings by expiration pattern, trailing five weeksranking · 2026-11-01 · 4×2Preview: 4 ranked values, largest first. Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdaysranking · 2026-11-01 · 25×4Preview: 16 ranked values, largest first. Underlyings with a traded expiration on each weekday, trailing five weeksranking · 2026-11-01 · 6×2Preview: 6 ranked values, smallest first. AAPL expirations within 130 days, as of Monday Aug 24, 2026series · 2026-11-01 · 12×5Preview: a 12-point series, ending higher.
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
SPY116314.7
QQQ108518.1
MSFT55317.7
IWM45727.4
NVDA34420.9
AAPL28319.4
KO8525.9
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 62×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,293 queries →
$