Typical daily move: option premium against quoted volatility

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    underlying_symbol                                              AS symbol,
    round(quantileDeterministic(0.5)(premium_move_pct, obs_id), 2) AS median_premium_move_pct,
    round(quantileDeterministic(0.5)(vol_move_pct, obs_id), 2)     AS median_vol_move_pct,
    round(quantileDeterministic(0.5)(premium_move_pct, obs_id)
        / quantileDeterministic(0.5)(vol_move_pct, obs_id), 1)     AS premium_move_ratio
FROM
(
    SELECT
        underlying_symbol,
        cityHash64(ticker, date)                                AS obs_id,
        100 * abs(toFloat64(option_close) / prev_premium - 1)   AS premium_move_pct,
        100 * abs(toFloat64(implied_volatility) / prev_vol - 1) AS vol_move_pct
    FROM
    (
        SELECT
            underlying_symbol,
            ticker,
            date,
            option_close,
            implied_volatility,
            lagInFrame(toFloat64(option_close))       OVER (PARTITION BY ticker ORDER BY date ASC) AS prev_premium,
            lagInFrame(toFloat64(implied_volatility)) OVER (PARTITION BY ticker ORDER BY date ASC) AS prev_vol,
            lagInFrame(date)                          OVER (PARTITION BY ticker ORDER BY date ASC) AS prev_date
        FROM global_markets.options_greeks
        WHERE underlying_symbol IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'JNJ')
          AND date BETWEEN '2026-04-06' AND '2026-05-15'
          AND iv_converged = 1
          AND volume > 0
          AND days_to_expiry BETWEEN 20 AND 45
          AND option_close > 0
          AND implied_volatility > 0
          AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
    )
    WHERE prev_premium > 0
      AND prev_vol > 0
      AND dateDiff('day', prev_date, date) <= 4
)
GROUP BY underlying_symbol
HAVING count() >= 200
ORDER BY premium_move_ratio ASC