KO quarterly dividend in cents and as a percent of the share price, 2016 to 2026

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    toString(d.ex_date)                                           AS ex_date,
    round(100 * toFloat64(d.cash_amount), 2)                      AS dividend_cents,
    round(toFloat64(a.close), 2)                                  AS share_price_usd,
    round(100 * toFloat64(d.cash_amount) / toFloat64(a.close), 3) AS step_pct
FROM
(
    SELECT
        ex_dividend_date    AS ex_date,
        max(cash_amount)    AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= '2016-01-01'
      AND ex_dividend_date <= '2026-06-30'
    GROUP BY ex_dividend_date
) AS d
INNER JOIN
(
    SELECT date, close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= '2016-01-01'
      AND date <= '2026-06-30'
) AS a ON a.date = d.ex_date
ORDER BY ex_date