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

Why Only Some Stocks Have Daily Options
Near-dated contract lines traded in one session, by underlyingranking · 2026-11-07 · 7×3Preview: 7 ranked values, largest first. Share of each name's 30-day option volume, by expiration dateseries · 2026-11-07 · 13×5Preview: a 13-point series, roughly flat. Expiration dates open in the next 45 days, by underlyingranking · 2026-11-07 · 7×4Preview: 7 ranked values, largest first. Expiration dates traded per month: SPY versus AAPL, since 2021series · 2026-11-07 · 62×3Preview: a 16-point series, roughly flat.
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
QQQ158118
SPY133012.5
IWM46022.6
MSFT39728.2
NVDA39212.2
AAPL31123.5
KO4126.8
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
$