KO: ex-dividend close against the pay date close, 2021 to 2026

WITH
    payouts AS (
        SELECT
            any(ex_dividend_date) AS ex_date,
            any(pay_date)         AS paid_on
        FROM global_markets.stocks_dividends
        WHERE ticker = 'KO'
          AND ex_dividend_date >= '2021-01-01'
          AND ex_dividend_date <  '2026-07-01'
          AND cash_amount > 0
        GROUP BY id
    ),
    bars AS (
        SELECT
            date                            AS session_day,
            round(avg(toFloat64(close)), 2) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'KO'
          AND date >= '2021-01-01'
          AND date <  '2026-09-01'
        GROUP BY date
    )
SELECT
    toString(p.paid_on)                AS pay_date,
    formatDateTime(p.paid_on, '%b %Y') AS pay_label,
    e.px                               AS close_at_ex,
    d.px                               AS close_at_pay,
    round(100 * (d.px / e.px - 1), 2)  AS move_pct
FROM payouts AS p
INNER JOIN bars AS e ON e.session_day = p.ex_date
INNER JOIN bars AS d ON d.session_day = p.paid_on
ORDER BY p.paid_on