3,256 answered market questions

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