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

MSFT Implied Volatility: IV Now & Its History
MSFT ATM implied volatility by time to expiration: latest sessionranking · 2026-10-04 · 4×3Preview: 4 ranked values, smallest first. MSFT vs SPY and QQQ: median ATM implied volatility by month, since mid-2022series · 2026-10-04 · 52×4Preview: a 16-point series, ending lower. MSFT at-the-money implied volatility by session: trailing 90 daysseries · 2026-10-04 · 63×2Preview: a 16-point series, ending lower.
MSFT Dividend 2026: Dates, Raise, Per Share
Indicated dividend yield on every Microsoft ex-dividend date since 2024series · 2026-10-04 · 11×6Preview: a 11-point series, roughly flat. Trailing yield and payout ratio at the latest stored Microsoft closescalar · 2026-10-04 · 1×7517.53 Microsoft dividends with a 2026 ex-dividend dateseries · 2026-10-04 · 4×7Preview: a 4-point series, ending higher. Microsoft's September dividend raises since 2020, read from each year's November ex-datetable · 2026-10-04 · 7×7 Dividends per share for 2026: calendar year vs Microsoft's July-to-June fiscal yearranking · 2026-10-04 · 2×4Preview: 2 ranked values, largest first.
MSFT Dividend: Yield, History & Ex-Dates
MSFT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-10-04 · 1×70.98 MSFT recent dividend payments: ex-dividend date and per-share amountseries · 2026-10-04 · 10×2Preview: a 10-point series, ending lower. MSFT total dividends paid per year (regular dividends)ranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first.
MSFT ATM implied volatility by time to expiration: latest session

MSFT ATM implied volatility by time to expiration: latest session

most recentas of ranking 4×3read in context →
MSFT 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 weeks25.9210
2-6 weeks30.7110
6 weeks - 4 months29.964
Beyond 4 months32.6132
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 = 'MSFT'
  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)
$