Moving the strike up costs premium: AAPL calls 30 to 45 days out

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
    strike_vs_spot,
    round(avg(premium_pct), 2) AS call_premium_pct_of_spot,
    count()                    AS sample_count
FROM
(
    SELECT
        multiIf(strike_ratio < 0.95, '5%+ below spot',
                strike_ratio < 0.98, '2-5% below spot',
                strike_ratio < 1.02, 'at the money',
                strike_ratio < 1.05, '2-5% above spot',
                strike_ratio < 1.10, '5-10% above spot',
                                     '10%+ above spot')            AS strike_vs_spot,
        strike_ratio,
        premium_pct
    FROM
    (
        SELECT
            toFloat64(strike_price)  / toFloat64(underlying_close)       AS strike_ratio,
            toFloat64(option_close)  / toFloat64(underlying_close) * 100 AS premium_pct
        FROM global_markets.options_greeks
        WHERE underlying_symbol = 'AAPL'
          AND lower(option_type) IN ('call', 'c')
          AND iv_converged = 1
          AND volume > 0
          AND date >= '2026-02-01'
          AND date <  '2026-08-01'
          AND days_to_expiry BETWEEN 30 AND 45
          AND underlying_close > 0
    )
)
GROUP BY strike_vs_spot
ORDER BY min(strike_ratio)