coin — 3 answered market questions

COIN ATM implied volatility by time to expiration: latest session

most recentas of 2026-08-22 ranking 4×3read in context →

COIN ATM implied volatility by time to expiration: latest session — 4 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
expiry_bucket	atm_iv_pct	contracts
Under 2 weeks	97.5	22
2-6 weeks	67.2	53
6 weeks - 4 months	74.2	12
Beyond 4 months	71.3	51

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 = 'COIN'
  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)

More from this analysisCOIN Implied Volatility: IV Now & Its History

COIN at-the-money implied volatility by session: trailing 90 days series 62×2 → COIN vs SPY and QQQ: median ATM implied volatility by month, since mid-2022 series 50×4 → Implied volatility beside the movement each stock actually delivered over the prior 30 sessions ranking 11×4 → At-the-money implied volatility, eleven familiar tickers (July 28, 2026) ranking 11×2 → See all 2,170 queries →