ko_history

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(ex_date_raw)        AS ex_date,
    toYear(ex_date_raw)          AS year,
    round(cash_amount, 4)        AS gross_per_share_usd,
    round(cash_amount * 0.85, 4) AS after_us_tax_usd,
    round(cash_amount * 0.80, 4) AS after_all_tax_usd
FROM
(
    SELECT
        id,
        any(ex_dividend_date)       AS ex_date_raw,
        any(toFloat64(cash_amount)) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND currency = 'USD'
      AND ex_dividend_date >= toDate('2019-01-01')
      AND ex_dividend_date <  today()
    GROUP BY id
)
ORDER BY ex_date