Free SQL API for Stock Market Data
SPY implied volatility by days-to-expiry bucket, latest sessionranking ·
2026-10-04 · 11×2
P/E ratios of US companies above $500B market capranking ·
2026-10-04 · 12×2
KO: total cash dividends per share by yearranking ·
2026-10-04 · 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.6 |
| 30 | 19.3 |
| 60 | 21.5 |
| 90 | 20.8 |
| 120 | 17.8 |
| 150 | 24.9 |
| 180 | 20 |
| 240 | 21.8 |
| 270 | 18.3 |
| 330 | 20.8 |
| 360 | 18.9 |
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
→
Correlation of price levels against correlation of daily returns, same pairs
ranking 15×4
→
Pairwise correlation of daily returns, six large caps, Oct 2025 to Sep 2026
ranking 15×2
→
See all 3,256 queries →