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

Market Recap: July 1, 2026, The Day in Numbers
Session check: SPY's observed minute-bar spanscalar · 2026-07-26 · 1×6893 One row for the whole options day: volume, same-day expiry, put/call skew, and the busiest contractscalar · 2026-07-26 · 1×2111.22 The day's last twelve news articles tagging MU, SNDK, STX, WDC or META (one licensed feed)table · 2026-07-26 · 12×4 The biggest names going ex-dividend on July 1, ranked by the day's dollar volumetable · 2026-07-26 · 8×7 July 1's corporate calendar and information flow, in one rowscalar · 2026-07-26 · 1×14746 The volatility complex on July 1: VIX-futures ETFs vs Tuesday's close, with SPY as the anchortable · 2026-07-26 · 5×5 The Treasury curve, July 1 close vs June 30 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY's open-to-close move ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×40.09 The memory complex and the megacaps: change vs Tuesday's close, range timing, and dollar volumetable · 2026-07-26 · 8×9 The eleven S&P sector ETFs on July 1, best to worst vs Tuesday's closetable · 2026-07-26 · 11×7 SPY / QQQ / DIA / IWM: July 1 vs the June 30 close, regular hourstable · 2026-07-26 · 4×8 Every quarter-opening session since 2004: SPY's open-to-close move, with July 1 ranked inside itscalar · 2026-07-26 · 1×991 Advancers, decliners, and new quarterly highs vs lows among tickers with at least $1M traded on July 1scalar · 2026-07-26 · 1×122,928
Market Recap: June 30, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×3Preview: a 13-point series, ending higher. Volume leaders two ways: top 6 by dollars traded, top 4 by shares traded (one reused-symbol listing excluded pending entity verification)table · 2026-07-26 · 10×6 Session check: SPY's observed minute-bar spanscalar · 2026-07-26 · 1×5860 The six busiest option contracts of June 30, by contracts tradedseries · 2026-07-26 · 6×7Preview: a 6-point series, ending lower. One row for the whole options day: volume, same-day expiry, SPY's put/call skew by moneyness, the holiday-shifted weekscalar · 2026-07-26 · 1×2010.06 The news feed on June 30: article count and the day's last headline for each name in this recapseries · 2026-07-26 · 7×5Preview: a 7-point series, ending lower. The Treasury curve, June 30 close vs June 29 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. SPY's open-to-close move ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×40.68 The semiconductor and storage names: change vs Monday's close, range, and dollar volumetable · 2026-07-26 · 6×10 The ten S&P sector funds on June 30: change vs Monday's close, and how far each sat behind the leadertable · 2026-07-26 · 10×7 SPY / QQQ / DIA / IWM: June 30 vs the June 29 close, regular hourstable · 2026-07-26 · 4×8 Q2 2026 end to end: each index ETF from the April 1 open to the June 30 close, regular hoursseries · 2026-07-26 · 4×7Preview: a 4-point series, ending lower. Top 5 gainers and top 5 decliners among names with $10M+ traded on June 30 (one reused-symbol listing excluded)table · 2026-07-26 · 10×8 Crypto-adjacent financials: change vs Monday's close, range, and dollar volumetable · 2026-07-26 · 4×10 June 30's corporate calendar and information flow, in one row (the filing-index gap on display)scalar · 2026-07-26 · 1×12704 Advancers vs decliners among tickers with at least $1M traded on June 30scalar · 2026-07-26 · 1×93,349
Market Recap: June 29, 2026, The Day in Numbers
Shares traded per 30-minute bucket, regular hours (billions)series · 2026-07-26 · 13×4Preview: a 13-point series, roughly flat. Volume leaders two ways: top 6 by dollars traded, top 4 by shares tradedtable · 2026-07-26 · 10×6 The Treasury curve, June 29 close vs June 26 (populated maturities only)ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. QQQ and SPY: June 29 ranked against the trailing month of sessions (rank 1 = biggest absolute move)scalar · 2026-07-26 · 1×102.57 Session check: SPY's observed minute-bar span, and the Friday closure on the tapescalar · 2026-07-26 · 1×80 The eleven sector baskets: June 29 vs the June 26 close, regular hourstable · 2026-07-26 · 11×6 SPY / QQQ / DIA / IWM: June 29 vs the June 26 close, regular hourstable · 2026-07-26 · 4×9 What it cost to cross the spread: NBBO updates and median quoted width, regular hourstable · 2026-07-26 · 4×7 One row for the whole options day: volume, 0DTE, the holiday-shifted weekscalar · 2026-07-26 · 1×2011.04 The memory/storage names: change vs Friday's close and intraday rangetable · 2026-07-26 · 4×9 June 29's corporate calendar and information flow, in one rowscalar · 2026-07-26 · 1×22449 Advancers vs decliners among tickers with at least $1M traded on June 29scalar · 2026-07-26 · 1×93,968
page 3 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)
$