2,170 answered market questions

SELECT
    toString(toMonday(date))                                       AS week,
    round(avgIf(rho, expiration_date = '2027-01-15'), 3)           AS leaps_call_rho,
    round(avgIf(rho, days_to_expiry BETWEEN 21 AND 45), 3)         AS front_call_rho
FROM global_markets.options_greeks
WHERE underlying_symbol = 'SPY'
  AND startsWith(lower(toString(option_type)), 'c')
  AND date >= '2025-08-04'
  AND date <  '2026-08-01'
  AND iv_converged = 1
  AND volume > 0
  AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.05
  AND (expiration_date = '2027-01-15' OR days_to_expiry BETWEEN 21 AND 45)
GROUP BY week
HAVING countIf(expiration_date = '2027-01-15') > 0
   AND countIf(days_to_expiry BETWEEN 21 AND 45) > 0
ORDER BY week