2,170 answered market questions

SELECT
    multiIf(days_to_expiry <=  14, '1-14 days',
            days_to_expiry <=  30, '15-30 days',
            days_to_expiry <=  60, '31-60 days',
            days_to_expiry <= 120, '61-120 days',
                                   '121-365 days')                                                       AS dte_bucket,
    round(avgIf(100 * toFloat64(option_close) / toFloat64(strike_price), underlying_symbol = 'SPY'), 2)   AS spy_premium_pct,
    round(avgIf(100 * toFloat64(option_close) / toFloat64(strike_price), underlying_symbol = 'NVDA'), 2)  AS nvda_premium_pct
FROM global_markets.options_greeks
WHERE date = (
        SELECT max(date)
        FROM global_markets.options_greeks
        WHERE underlying_symbol IN ('SPY', 'NVDA')
      )
  AND lower(toString(option_type)) IN ('put', 'p')
  AND days_to_expiry BETWEEN 1 AND 365
  AND toFloat64(option_close) > 0
  AND toFloat64(strike_price) > 0
  AND toFloat64(underlying_close) > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.03
  AND underlying_symbol IN ('SPY', 'NVDA')
GROUP BY dte_bucket
HAVING countIf(underlying_symbol = 'SPY')  > 0
   AND countIf(underlying_symbol = 'NVDA') > 0
ORDER BY min(days_to_expiry)