Compounding the index against the buffered payoff, net of a 0.79% fee

WITH yearly AS
(
    SELECT
        toString(toYear(date)) AS outcome_year,
        round((toFloat64(argMax(close, date)) / toFloat64(argMin(close, date)) - 1) * 100, 1) AS index_return_pct
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2014-01-01'
      AND date <  '2026-01-01'
    GROUP BY toYear(date)
),
outcomes AS
(
    SELECT
        outcome_year,
        1.0 + (index_return_pct / 100) AS index_growth,
        (1.0 + (multiIf(index_return_pct >  15.0, 15.0,
                        index_return_pct >=  0.0, index_return_pct,
                        index_return_pct >= -9.0, 0.0,
                        index_return_pct + 9.0) / 100)) * (1.0 - 0.0079) AS fund_growth
    FROM yearly
)
SELECT
    outcome_year,
    round((exp(sum(log(index_growth)) OVER (ORDER BY outcome_year ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)) - 1) * 100, 1) AS index_cum_pct,
    round((exp(sum(log(fund_growth))  OVER (ORDER BY outcome_year ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)) - 1) * 100, 1) AS fund_net_cum_pct
FROM outcomes
ORDER BY outcome_year