ko_trace

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_dividend_date)                        AS ex_date,
    round(d.cash_per_share, 4)                          AS cash_per_share,
    round(d.cash_per_share * p.shares, 2)               AS usd_on_500_stake,
    formatDateTime(d.ex_dividend_date, '%b %e, %Y')     AS ex_date_pretty
FROM
(
    SELECT
        ex_dividend_date,
        toFloat64(max(cash_amount)) AS cash_per_share
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= today() - 1500
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
) AS d
CROSS JOIN
(
    SELECT floor(500 / argMin(toFloat64(close), date)) AS shares
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= today() - 1500
      AND date <  today() - 1460
) AS p
ORDER BY d.ex_dividend_date