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

What Is Implied Volatility? IV, Explained
SPY put IV rises as strikes fall: the volatility skew (2026-07-13)ranking · 2026-08-13 · 5×2Preview: 5 ranked values, smallest first. SPY at-the-money implied volatility, month by month (Jul 2025 – Jul 2026)series · 2026-08-13 · 13×2Preview: a 13-point series, ending lower. At-the-money implied volatility by stock (2026-07-13)ranking · 2026-08-13 · 7×2Preview: 7 ranked values, largest first.
Implied Volatility vs Vega: The Difference
Where vega peaks: AAPL vega and IV across strikes, 20 to 45 days out (July 2026)ranking · 2026-08-13 · 12×4Preview: 12 ranked values, largest first. Same underlying, same IV, rising vega: AAPL by days to expiry (July 2026)ranking · 2026-08-13 · 14×4Preview: 14 ranked values, largest first. Contract days behind the weekly IV series, by monthseries · 2026-08-13 · 12×5Preview: a 12-point series, ending higher. One input, three levels: weekly average IV for AAPL, NVDA and KO (20 to 45 days out)series · 2026-08-13 · 53×5Preview: a 16-point series, ending higher.
Heston Model and the Volatility Smile
How far at-the-money implied volatility itself travelled (Jan to Jun 2026)ranking · 2026-08-12 · 6×4Preview: 6 ranked values, largest first. Near-the-money implied volatility by time to expiry (Jan to Jun 2026)ranking · 2026-08-12 · 6×3Preview: 6 ranked values, smallest first. SPY implied volatility by strike distance, 20 to 45 days to expiry (Jan to Jun 2026)ranking · 2026-08-12 · 13×4Preview: 13 ranked values, largest first. Put-side versus call-side implied volatility, 20 to 45 days (Jan to Jun 2026)ranking · 2026-08-12 · 6×4Preview: 6 ranked values, smallest first. Daily at-the-money implied volatility, SPY and NVDA (Apr to Jun 2026)series · 2026-08-12 · 62×3Preview: a 16-point series, ending higher.
Probability of Touch vs Probability ITM
SPY through July 2024 against a level 2% above the July 1 closeseries · 2026-08-07 · 28×6Preview: a 16-point series, ending higher. SPY: touched versus finished above, 21-session forward windows since 2011table · 2026-08-07 · 4×5 SPY option delta buckets, with the doubling rule applied (Jan to Jun 2026)ranking · 2026-08-07 · 9×4Preview: 9 ranked values, smallest first.
IV Term Structure: What the Curve Tells You
NVDA term structure either side of the February 26, 2025 report: median near-the-money IV by expiry bandranking · 2026-08-04 · 5×4Preview: 5 ranked values, largest first. NVDA front band vs 91-180 day band: median near-the-money IV per session, Feb 10 to Mar 14, 2025series · 2026-08-04 · 24×4Preview: a 16-point series, ending higher. IV term structure, six liquid names: median near-the-money implied volatility by expiry band, June 2026ranking · 2026-08-04 · 5×4Preview: 5 ranked values, smallest first. Share of sessions with an inverted curve: front band above the 91-180 day band, twelve months to July 31, 2026ranking · 2026-08-04 · 10×4Preview: 10 ranked values, largest first.
Is 30% IV High? It Depends on the Ticker
IV rank against IV percentile: the latest reading inside each ticker's 52-week rangetable · 2026-08-02 · 8×6 Where a 30% reading sits in each ticker's own two-year distributiontable · 2026-08-02 · 8×6 Monthly median 30-day implied volatility: index ETF, staple, and chipmakerseries · 2026-08-02 · 24×5Preview: a 16-point series, ending lower. Implied volatility band against the move the underlying made the next sessiontable · 2026-08-02 · 5×5
How to Read an Option Chain, Column by Column
Where the trading happened: SPY contract volume by strike, August 21 2026 expiry, July 15 2026ranking · 2026-07-31 · 8×3Preview: 8 ranked values, smallest first. Median quoted bid and ask by strike: SPY calls expiring August 21 2026, regular session of July 15 2026table · 2026-07-31 · 7×5 Implied volatility by strike: SPY options expiring August 21 2026, as of July 15 2026ranking · 2026-07-31 · 11×3Preview: 11 ranked values, largest first. SPY option volume by time to expiration, July 15 2026ranking · 2026-07-31 · 5×4Preview: 5 ranked values, largest first. One expiration of the SPY chain: closing prices and delta by strike, August 21 2026 expiry, as of July 15 2026table · 2026-07-31 · 8×6
page 2 of 2
META ATM implied volatility by time to expiration: latest session

META ATM implied volatility by time to expiration: latest session

most recentas of ranking 4×3read in context →
META 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 weeks35186
2-6 weeks35.7109
6 weeks - 4 months39.844
Beyond 4 months4292
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 = 'META'
  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)
$