Dividend adjustment factors on every KO ex-date since 2019

WITH
px AS (
    SELECT
        date,
        toFloat64(any(close)) AS c
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= '2018-10-01'
      AND date < today()
    GROUP BY date
),
lagged AS (
    SELECT
        date,
        lagInFrame(c) OVER (ORDER BY date ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_close
    FROM px
),
divs AS (
    SELECT
        ex_dividend_date            AS d_date,
        toFloat64(max(cash_amount)) AS cash
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= '2019-01-01'
      AND ex_dividend_date < today()
      AND cash_amount > 0
    GROUP BY ex_dividend_date
)
SELECT
    toString(divs.d_date)                           AS ex_date,
    formatDateTime(divs.d_date, '%b %e, %Y')        AS ex_label,
    round(100 * divs.cash / lagged.prior_close, 3)  AS dividend_pct,
    round(100 * (1 - exp(sum(log(1 - divs.cash / lagged.prior_close))
        OVER (ORDER BY divs.d_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW))), 2) AS cumulative_pct
FROM divs
INNER JOIN lagged ON lagged.date = divs.d_date
WHERE lagged.prior_close > 0
ORDER BY divs.d_date