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
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
QQQ on the latest session: at-the-money IV, contracts traded and total volume

QQQ on the latest session: at-the-money IV, contracts traded and total volume

most recentas of scalar 1×7read in context →
symbol
QQQ
session pretty
Nov 6, 2026
atm iv pct
29.3
atm contracts
92
total contracts
6,298
total volume
2.54M
total volume pretty
2.54 million
the exact SQL behind every number 
SELECT
    underlying_symbol                                                         AS symbol,
    concat(formatDateTime(min(date), '%b'), ' ', toString(toDayOfMonth(min(date))), ', ', toString(toYear(min(date)))) AS session_pretty,
    round(avgIf(implied_volatility,
                iv_converged = 1
                AND days_to_expiry BETWEEN 20 AND 45
                AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02) * 100, 1) AS atm_iv_pct,
    countIf(iv_converged = 1
            AND days_to_expiry BETWEEN 20 AND 45
            AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02) AS atm_contracts,
    count()                                                                   AS total_contracts,
    sum(volume)                                                               AS total_volume,
    formatReadableQuantity(toFloat64(sum(volume)))                            AS total_volume_pretty
FROM global_markets.options_greeks
WHERE underlying_symbol = 'QQQ'
  AND volume > 0
  AND date = (
        SELECT max(date)
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'QQQ'
          AND date >= today() - 30
          AND volume > 0
      )
GROUP BY symbol
HAVING countIf(iv_converged = 1
               AND days_to_expiry BETWEEN 20 AND 45
               AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02) > 0
More from this analysisNDX vs QQQ Options: Which One to Trade?
Contract size: one QQQ contract from the latest daily close scalar 1×4 → QQQ ex-dividend dates and cash per share, most recent first series 9×4 → QQQ expiration dates that traded, by weekday, over the last ~45 days ranking 5×2 → Share of QQQ regular-session volume in the first 15 minutes, monthly expiration Fridays series 12×4 → See all 3,293 queries →
$