Coca-Cola's declared quarterly dividend rate, last five years

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
    concat(toString(toYear(ex_date)), ' Q', toString(toQuarter(ex_date))) AS quarter,
    round(toFloat64(amount), 4)                                          AS rate_per_share,
    round(4 * toFloat64(amount), 4)                                      AS annual_run_rate,
    formatDateTime(pay_day, '%b %e, %Y')                                 AS paid
FROM
(
    SELECT
        id,
        any(ex_dividend_date) AS ex_date,
        any(cash_amount)      AS amount,
        any(pay_date)         AS pay_day
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= today() - 1830
    GROUP BY id
)
ORDER BY ex_date