2,178 answered market questions

WITH daily AS (
    SELECT underlying_symbol, date,
           quantileExact(0.5)(implied_volatility) AS iv,
           sum(volume) AS vol
    FROM global_markets.options_greeks
    WHERE date >= toDate('2026-06-01') AND date <= toDate('2026-07-15')
      AND iv_converged AND implied_volatility BETWEEN 0.02 AND 5
      AND abs(strike_price / underlying_close - 1) <= 0.05
      AND expiration_date BETWEEN date + 7 AND date + 60
      AND underlying_symbol NOT IN ('KORU','SOXL','SOXS','TQQQ','SQQQ','NVDL','NVDS','NVD','TSLL','TSLQ','TSLZ','SPXL','SPXS','UPRO','SPXU','LABU','LABD','FAS','FAZ','TNA','TZA','YINN','YANG','UDOW','SDOW','BOIL','KOLD','UCO','SCO','USD','SSO','SDS','QLD','QID','ERX','ERY','DRN','DRV','CURE','SOXY','MUU','SNXX','UVXY','SVXY','UVIX','SVIX','BULZ','WEBL','WEBS','DPST','DRIP','GUSH','AGQ','ZSL','BITX','ETHU','MSTX','MSTU','CONL','DUST','JNUG','JDST','NUGT','AMDL','NUAI','DRAM')
    GROUP BY underlying_symbol, date
    HAVING count() >= 15 AND sum(volume) >= 1000
),
moves AS (
    SELECT underlying_symbol, date,
           iv, lagInFrame(iv) OVER w AS prev_iv,
           lagInFrame(date) OVER w AS prev_date, vol
    FROM daily
    WINDOW w AS (PARTITION BY underlying_symbol ORDER BY date ASC)
)
SELECT underlying_symbol AS ticker,
       toString(date) AS crush_date,
       round(100 * prev_iv, 1) AS iv_before_pct,
       round(100 * iv, 1) AS iv_after_pct,
       round(100 * (prev_iv - iv), 1) AS iv_drop_points,
       vol AS contracts_traded
FROM moves
WHERE prev_iv > 0 AND date - prev_date <= 4 AND prev_iv - iv >= 0.12
ORDER BY iv_drop_points DESC
LIMIT 12