The same covered call at entry, the SPY peak, the dip, and the final session

WITH prem AS (
  SELECT avg(option_close) AS p
  FROM global_markets.options_greeks
  WHERE ticker = 'O:SPY260618C00740000' AND date = '2026-05-01' AND implied_volatility > 0.02
)
SELECT multiIf(g.date = '2026-05-01', '1. Sold the call (May 1)',
               g.date = '2026-06-02', '2. SPY peak (Jun 2)',
               g.date = '2026-06-10', '3. SPY dip (Jun 10)', '4. Final session (Jun 15)') AS stage,
       round(avg(g.underlying_close), 2) AS spy_price,
       round(avg(g.option_close), 2) AS call_value,
       if(avg(g.underlying_close) > 740, 'above 740 strike', 'below 740 strike') AS moneyness,
       round(avg(g.underlying_close) + any(prem.p) - avg(g.option_close), 2) AS covered_value
FROM global_markets.options_greeks g, prem
WHERE g.ticker = 'O:SPY260618C00740000'
  AND g.date IN ('2026-05-01', '2026-06-02', '2026-06-10', '2026-06-15')
  AND g.implied_volatility > 0.02
GROUP BY g.date ORDER BY g.date