Free SQL API for Stock Market Data
SPY implied volatility by days-to-expiry bucket, latest sessionranking ·
2026-08-22 · 9×2
P/E ratios of US companies above $500B market capranking ·
2026-08-22 · 12×2
KO: total cash dividends per share by yearranking ·
2026-08-22 · 22×2
SPY implied volatility by days-to-expiry bucket, latest session
SPY implied volatility by days-to-expiry bucket, latest session
| dte_bucket_days | avg_iv_pct |
|---|---|
| 0 | 22.8 |
| 30 | 20.4 |
| 60 | 18.5 |
| 90 | 22 |
| 120 | 27.1 |
| 150 | 18.8 |
| 210 | 21 |
| 300 | 22.4 |
| 360 | 21.2 |
the exact SQL behind every number
SELECT least(floor(days_to_expiry / 30) * 30, 360) AS dte_bucket_days,
round(avg(implied_volatility) * 100, 1) AS avg_iv_pct
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
AND date = (SELECT max(date) FROM global_markets.options_greeks)
AND iv_converged
AND days_to_expiry BETWEEN 1 AND 400
GROUP BY dte_bucket_days
ORDER BY dte_bucket_days
More from this analysisFree SQL API for Stock Market Data
KO: total cash dividends per share by year
ranking 22×2
→
P/E ratios of US companies above $500B market cap
ranking 12×2
→
Highest large-cap dividend yields, latest session
ranking 12×3
→
End-of-day implied-volatility leaders, liquid underlyings
ranking 12×2
→
See all 2,170 queries →