2,170 answered market questions

WITH
(
    SELECT ticker
    FROM global_markets.options_greeks
    WHERE underlying_symbol = 'AAPL'
      AND toFloat64(delta) > 0
      AND date BETWEEN '2026-04-06' AND '2026-05-15'
      AND expiration_date BETWEEN '2026-06-15' AND '2026-09-30'
      AND iv_converged = 1
      AND volume > 0
      AND abs(toFloat64(strike_price) / toFloat64(underlying_close) - 1) < 0.03
    GROUP BY ticker
    ORDER BY sum(volume) DESC
    LIMIT 1
) AS traced_call
SELECT
    toString(date)                     AS session_date,
    formatDateTime(date, '%b %e')      AS session_label,
    round(100 * (toFloat64(underlying_close)
        / first_value(toFloat64(underlying_close)) OVER (ORDER BY date ASC) - 1), 2)   AS stock_change_pct,
    round(100 * (toFloat64(option_close)
        / first_value(toFloat64(option_close)) OVER (ORDER BY date ASC) - 1), 2)       AS call_premium_change_pct,
    round(100 * (toFloat64(implied_volatility)
        / first_value(toFloat64(implied_volatility)) OVER (ORDER BY date ASC) - 1), 2) AS quoted_vol_change_pct
FROM global_markets.options_greeks
WHERE ticker = traced_call
  AND date BETWEEN '2026-04-06' AND '2026-05-15'
  AND iv_converged = 1
  AND option_close > 0
  AND implied_volatility > 0
ORDER BY session_date ASC