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
When Do NDX Options Expire?
Listed QQQ option expirations by weekday, trailing 90 days of traded contractsranking · 2026-11-07 · 5×3Preview: 5 ranked values, largest first. Share of QQQ regular-session volume in the first 15 minutes, monthly expiration Fridaysseries · 2026-11-07 · 12×4Preview: a 12-point series, roughly flat. NDX monthly expirations ahead: third Friday, Thursday last trade, exchange statusseries · 2026-11-07 · 8×6Preview: a 8-point series, ending higher. QQQ volume by ET hour: quarterly expiration Friday (2026-09-18) vs the prior Friday (2026-09-11)series · 2026-11-07 · 7×3Preview: a 7-point series, ending higher.
NDX vs QQQ Options: Which One to Trade?
QQQ on the latest session: at-the-money IV, contracts traded and total volumescalar · 2026-11-07 · 1×729.3 QQQ ex-dividend dates and cash per share, most recent firstseries · 2026-11-07 · 9×4Preview: a 9-point series, ending lower. QQQ expiration dates that traded, by weekday, over the last ~45 daysranking · 2026-11-07 · 5×2Preview: 5 ranked values, smallest first. Contract size: one QQQ contract from the latest daily closescalar · 2026-11-07 · 1×4656.1
Listed QQQ option expirations by weekday, trailing 90 days of traded contracts

Listed QQQ option expirations by weekday, trailing 90 days of traded contracts

most recentas of ranking 5×3read in context →
Listed QQQ option expirations by weekday, trailing 90 days of traded contracts — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
weekday_labellisted_expirationsexpirations_within_60d
Friday2919
Thursday1917
Wednesday1715
Tuesday1515
Monday1414
the exact SQL behind every number 
SELECT
    formatDateTime(expiration_date, '%W')                          AS weekday_label,
    countDistinct(expiration_date)                                 AS listed_expirations,
    countDistinctIf(expiration_date, days_to_expiry <= 60)         AS expirations_within_60d
FROM global_markets.options_greeks
WHERE underlying_symbol = 'QQQ'
  AND date >= today() - 90
  AND volume > 0
  AND iv_converged = 1
GROUP BY weekday_label
ORDER BY listed_expirations DESC
More from this analysisWhen Do NDX Options Expire?
Share of QQQ regular-session volume in the first 15 minutes, monthly expiration Fridays series 12×4 → NDX monthly expirations ahead: third Friday, Thursday last trade, exchange status series 8×6 → QQQ volume by ET hour: quarterly expiration Friday (2026-09-18) vs the prior Friday (2026-09-11) series 7×3 → SPY: widest open print to close print gaps on monthly expiration Fridays since 2021 ranking 12×4 → See all 3,293 queries →
$