STRASMORE/EXPLORE 2,549 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,549 answered market questions

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

NDX vs QQQ Options: Which One to Trade?
QQQ on the latest session: at-the-money IV, contracts traded and total volumescalar · 2026-09-20 · 1×717.8 QQQ ex-dividend dates and cash per share, most recent firstseries · 2026-09-20 · 8×4Preview: a 8-point series, ending lower. QQQ expiration dates that traded, by weekday, over the last ~45 daysranking · 2026-09-20 · 5×2Preview: 5 ranked values, smallest first. Contract size: one QQQ contract from the latest daily closescalar · 2026-09-20 · 1×4721.45
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
Sep 17, 2026
atm iv pct
17.8
atm contracts
225
total contracts
4,546
total volume
2.65M
total volume pretty
2.65 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 8×4 → QQQ expiration dates that traded, by weekday, over the last ~45 days ranking 5×2 → QQQ at-the-money implied volatility by session: trailing 90 days series 62×2 → See all 2,549 queries →
$