What extra time is worth: at-the-money AAPL call premium by days to expiry

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
    dte_bucket,
    round(avg(premium_pct), 2) AS call_premium_pct_of_spot,
    count()                    AS sample_count
FROM
(
    SELECT
        multiIf(days_to_expiry <=  7, '1-7 days',
                days_to_expiry <= 14, '8-14 days',
                days_to_expiry <= 30, '15-30 days',
                days_to_expiry <= 60, '31-60 days',
                days_to_expiry <= 90, '61-90 days',
                                      '91-180 days')              AS dte_bucket,
        days_to_expiry                                            AS dte,
        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 1 AND 180
      AND underlying_close > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.02
)
GROUP BY dte_bucket
ORDER BY min(dte)