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

3,256 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-10-04 · 1×719.9 QQQ ex-dividend dates and cash per share, most recent firstseries · 2026-10-04 · 9×4Preview: a 9-point series, ending lower. QQQ expiration dates that traded, by weekday, over the last ~45 daysranking · 2026-10-04 · 5×2Preview: 5 ranked values, smallest first. Contract size: one QQQ contract from the latest daily closescalar · 2026-10-04 · 1×4749.58
How QQQ Holdings Are Weighted, and Capped
QQQ volume on the December reconstitution Friday against the rest of the monthranking · 2026-10-04 · 10×4Preview: 10 ranked values, smallest first. Average daily dollar volume, non-technology Nasdaq-100 members, trailing three monthsranking · 2026-10-04 · 12×2Preview: 12 ranked values, largest first. Market value of the largest Nasdaq-100 securities, and each one's share of the groupranking · 2026-10-04 · 11×3Preview: 11 ranked values, largest first.
SpaceX Joins the Nasdaq-100: The Index-Add Trade
July 6's matched volume by where it printed: the cross, continuous on-exchange, off-exchange (TRF)ranking · 2026-07-09 · 3×4Preview: 3 ranked values, largest first. The morning after: July 7, 2026 through 12:59 p.m. ET (window pinned by design; see data notes)scalar · 2026-07-09 · 1×10210 The add-eve receipts row: checkpoints, the last continuous trade, and the auction print itselfscalar · 2026-07-09 · 1×23165.95 July 6, 2026 in five-minute buckets: the slide, the late climb, and the volume underneathseries · 2026-07-09 · 78×3Preview: a 16-point series, ending lower. Levine's three sessions on our tape: day volume, the closing cross, and the cross's share of the dayseries · 2026-07-09 · 3×7Preview: a 3-point series, roughly flat. Entity receipt: the old SPCX tape ends in April 2026, May is silent, SpaceX lists June 12series · 2026-07-09 · 5×6Preview: a 5-point series, ending higher. Every SPCX closing cross since the June 12 listing: size, share of the day, and the official close it setseries · 2026-07-09 · 15×6Preview: a 15-point series, ending lower.
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
Oct 1, 2026
atm iv pct
19.9
atm contracts
211
total contracts
4,974
total volume
3.14M
total volume pretty
3.14 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,256 queries →
$