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

2,170 answered market questions

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

QQQ Implied Volatility: IV Now & Its History
QQQ ATM implied volatility by time to expiration: latest sessionranking · 2026-08-22 · 4×3Preview: 4 ranked values, smallest first. QQQ vs SPY: median ATM implied volatility by month, since mid-2022series · 2026-08-22 · 50×3Preview: a 16-point series, ending lower. QQQ at-the-money implied volatility by session: trailing 90 daysseries · 2026-08-22 · 62×2Preview: a 16-point series, ending higher.
Market Recap: July 30, 2026, The Day in Numbers
Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-02 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 30table · 2026-08-02 · 7×5 July 31 and August 3 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-02 · 1×60 Ex-dividends, splits, listings, news, and the July 30 SEC filing mixscalar · 2026-08-02 · 1×14200 Treasury curve prints on file, July 27 through July 30series · 2026-08-02 · 4×5Preview: a 4-point series, ending higher. SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-02 · 1×40.27 Stocks NBBO update count: July 30 vs July 29, with named-ticker updates (millions)scalar · 2026-08-02 · 1×6560.75 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 30scalar · 2026-08-02 · 1×310.32 Top 6 by dollars traded, top 4 by shares traded: July 30 regular hourstable · 2026-08-01 · 10×5 SPY day move in trailing context (open-to-close, June 30 through July 30)scalar · 2026-08-01 · 1×40.77 Sector ETFs, July 30 close vs July 29 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 30 vs the July 29 close, regular hourstable · 2026-08-01 · 4×10 Options tape: contracts, call share, same-day share vs Wednesday, busiest SPY contractscalar · 2026-08-01 · 1×1210.93 Eight mega-caps: change vs July 29 and regular-hours dollars, July 30table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 30 close vs July 29 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 30 close vs July 29 close, $1M-traded filterscalar · 2026-08-01 · 1×63,782
Market Recap: July 29, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 29 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 29table · 2026-08-01 · 7×5 July 30 and 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 29 SEC filing mixscalar · 2026-08-01 · 1×1485 Treasury curve prints on file, July 24 through July 29series · 2026-08-01 · 4×5Preview: a 4-point series, ending higher. SPY day move in trailing context (open-to-close, June 29 through July 29)scalar · 2026-08-01 · 1×4-1.41 SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 29 close vs July 28 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 29 vs the July 28 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 29 vs July 28, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6722.65 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 29scalar · 2026-08-01 · 1×313.55 Options tape: contracts, call share, same-day share vs Tuesday, busiest SPY contractscalar · 2026-08-01 · 1×1211.03 Eight mega-caps: change vs July 28 and regular-hours dollars, July 29table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 29 close vs July 28 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 29 close vs July 28 close, $1M-traded filterscalar · 2026-08-01 · 1×61,652
Market Recap: July 28, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 28 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 28table · 2026-08-01 · 7×5 July 29 through 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 28 SEC filing mixscalar · 2026-08-01 · 1×14147 Treasury curve prints on file, July 23 through July 28series · 2026-08-01 · 4×5Preview: a 4-point series, ending higher. SPY day move in trailing context (open-to-close, June 29 through July 28)scalar · 2026-08-01 · 1×40.21 SPY's median spread ranked against every July session, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 28 close vs July 27 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 28 vs the July 27 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 28 vs July 27, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6536.07 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 28scalar · 2026-08-01 · 1×310.23 Options tape: contracts, call share, same-day share vs Monday, busiest SPY contractscalar · 2026-08-01 · 1×1210.07 Eight mega-caps: change vs July 27 and regular-hours dollars, July 28table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 28 close vs July 27 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 28 close vs July 27 close, $1M-traded filterscalar · 2026-08-01 · 1×63,519
Market Recap: July 27, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 27 regular hourstable · 2026-08-01 · 10×5 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-08-01 · 1×7390 Seven names: RTH median quoted spread in basis points, with quote-quality counts, July 27table · 2026-08-01 · 7×5 July 28 through 31 on the calendar: closures, ex-dividends, splits, the Friday expiry, and the short-interest lagscalar · 2026-08-01 · 1×60 Ex-dividends, splits, listings, news, and the July 27 SEC filing mixscalar · 2026-08-01 · 1×1491 Treasury curve prints on file, July 22 through July 27series · 2026-08-01 · 4×5Preview: a 4-point series, ending lower. SPY day move in trailing context (open-to-close, June 26 through July 27)scalar · 2026-08-01 · 1×4-0.79 SPY's median spread ranked against every July session through the 27th, tightest firstscalar · 2026-08-01 · 1×40.27 Sector ETFs, July 27 close vs July 24 close, rankedranking · 2026-08-01 · 11×3Preview: 11 ranked values, largest first. SPY / QQQ / DIA / IWM: July 27 vs the July 24 close, regular hourstable · 2026-08-01 · 4×10 Stocks NBBO update count: July 27 vs July 24, with named-ticker updates (millions)scalar · 2026-08-01 · 1×6553.53 Options NBBO tape: total updates vs the stock tape, plus the SPY root slice, July 27scalar · 2026-08-01 · 1×310.38 Options tape: contracts, call share, same-day share vs Friday, busiest SPY contractscalar · 2026-08-01 · 1×1211.07 Eight mega-caps: change vs July 24 and regular-hours dollars, July 27table · 2026-08-01 · 8×5 Biggest gainers and decliners: July 27 close vs July 24 close, $5M+ traded, splits excludedranking · 2026-08-01 · 16×4Preview: 16 ranked values, largest first. Liquid-tape breadth: July 27 close vs July 24 close, $1M-traded filterscalar · 2026-08-01 · 1×63,880
Feb 24, 2022: War at the Open, Green by Close
2-year and 10-year Treasury yields, February 18 – March 8, 2022 (%)series · 2026-07-26 · 12×3Preview: a 12-point series, ending lower. QQQ sessions since 2003: intraday low ≤ −3% vs prior close AND close ≥ +1%series · 2026-07-26 · 2×4Preview: a 2-point series, ending lower. QQQ by half-hour: February 24, 2022 regular sessionseries · 2026-07-26 · 13×4Preview: a 13-point series, ending lower. After the reversal: when QQQ broke the invasion-day low, and how far it fellscalar · 2026-07-26 · 1×10340.65 QQQ on February 24, 2022: the invasion-day reversal, receiptedscalar · 2026-07-26 · 1×14329.41 Eleven tickers on February 24, 2022: gap, intraday extremes, close (% vs prior close)table · 2026-07-26 · 11×6 QQQ daily closes, February 22 – March 14, 2022series · 2026-07-26 · 15×4Preview: a 15-point series, roughly flat.
Market Recap: Week of July 6, 2026
Next week on the calendar: closures, ex-dividends, and the monthly expiry's pullscalar · 2026-07-26 · 1×40 SPY by session: close, change, and share volume, July 6-10series · 2026-07-26 · 5×4Preview: a 5-point series, ending lower. Options contracts and 0DTE share by session, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, smallest first. What the news feed actually carried, verbatim (The Motley Fool, rout day and bounce day)table · 2026-07-26 · 2×3 SEC filings by session and form type, July 6-10table · 2026-07-26 · 5×5 SK Hynix's SEC paper trail into its July 10 US listingtable · 2026-07-26 · 9×2 SK Hynix's US debut: the raise, the delayed open, the close vs offer, and where the first-day tape ranks in 2026scalar · 2026-07-26 · 1×14158.14 Top names by regular-hours dollar volume, full week July 6-10ranking · 2026-07-26 · 6×2Preview: 6 ranked values, largest first. Tuesday's rout: INTC and TER, July 7 close vs July 6 closeranking · 2026-07-26 · 2×2Preview: 2 ranked values, largest first. Daily short-volume file coverage: tickers on file and total short shares, July 6-10ranking · 2026-07-26 · 5×3Preview: 5 ranked values, largest first. Session verification: five sessions, no holiday, next scheduled closurescalar · 2026-07-26 · 1×65 Feed coverage by day: articles tagging NVDA, MU, INTC, TER, July 6-10table · 2026-07-26 · 5×5 The week's corporate calendar: filings, dividends, splits, newsscalar · 2026-07-26 · 1×1018,353 SPY's week in trailing-year context (open-to-close weekly returns, ~53 weeks)scalar · 2026-07-26 · 1×50.82 SPY / QQQ / DIA / IWM: week of July 6 vs the July 2 close, with the prior week's changetable · 2026-07-26 · 4×5 Sector ETFs, full-week change: July 10 close vs July 2 closeranking · 2026-07-26 · 10×2Preview: 10 ranked values, smallest first. Treasury curve: the Friday July 10 print vs the July 2 close, both late receipts on filescalar · 2026-07-26 · 1×67 Weekly movers: ten biggest gainers and decliners, $5M+ traded, in-week splits excludedtable · 2026-07-26 · 20×5 The chip complex's full-week change: July 10 close vs July 2 close, fourteen namesranking · 2026-07-26 · 14×2Preview: 14 ranked values, smallest first. Weekly breadth: July 10 close vs July 2 close, names with $5M+ traded during the weekscalar · 2026-07-26 · 1×43,015
Market Recap: July 10, 2026, The Day in Numbers
Top 6 by dollars traded, top 4 by shares traded: July 10 regular hourstable · 2026-07-26 · 10×5 SK Hynix's first session: the listing record vs the tape, July 10, 2026scalar · 2026-07-26 · 1×8158.14 Session verification: first/last SPY bar ET, regular-bar count, holiday receipts, next closurescalar · 2026-07-26 · 1×7390 SPY / QQQ / NVDA / META / MU / SNDK / AVGO: RTH median quoted spread in basis pointsranking · 2026-07-26 · 7×2Preview: 7 ranked values, smallest first. NVDA and META in the news feed on July 10: every company-named headlinetable · 2026-07-26 · 5×3 The week of July 13–17: closures, ex-dividends, splits, the monthly expiry, and the short-interest lagscalar · 2026-07-26 · 1×80
page 1 of 3
QQQ ATM implied volatility by time to expiration: latest session

QQQ ATM implied volatility by time to expiration: latest session

most recentas of ranking 4×3read in context →
QQQ ATM implied volatility by time to expiration: latest session — 4 rows by 3 columns, computed from US exchange, SIP and OPRA data.
expiry_bucketatm_iv_pctcontracts
Under 2 weeks191003
2-6 weeks19.2652
6 weeks - 4 months21.5210
Beyond 4 months24.3271
the exact SQL behind every number
SELECT multiIf(days_to_expiry <= 14, 'Under 2 weeks', days_to_expiry <= 45, '2-6 weeks',
               days_to_expiry <= 120, '6 weeks - 4 months', 'Beyond 4 months') AS expiry_bucket,
       round(100 * quantileExact(0.5)(implied_volatility), 1) AS atm_iv_pct,
       count() AS contracts
FROM global_markets.options_greeks
WHERE underlying_symbol = 'QQQ'
  AND date = (SELECT max(date) FROM global_markets.options_greeks)
  AND iv_converged AND implied_volatility BETWEEN 0.02 AND 5
  AND abs(strike_price / underlying_close - 1) <= 0.05
GROUP BY expiry_bucket
HAVING count() >= 5
ORDER BY min(days_to_expiry)
$