ko_yield_monthly

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(p.month)                                                      AS month,
    formatDateTime(p.last_day, '%d.%m.%Y')                                 AS as_of,
    round(p.month_close, 2)                                                AS close_usd,
    round(argMax(d.usd, d.ex_dividend_date) * 4 / p.month_close * 100, 2)  AS yield_pct
FROM
(
    SELECT
        toStartOfMonth(date)            AS month,
        max(date)                       AS last_day,
        argMax(toFloat64(close), date)  AS month_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'KO'
      AND date >= addMonths(toStartOfMonth(today()), -23)
    GROUP BY month
) AS p
CROSS JOIN
(
    SELECT
        ex_dividend_date,
        max(toFloat64(cash_amount))     AS usd
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND ex_dividend_date >= addMonths(today(), -36)
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
) AS d
WHERE d.ex_dividend_date <= p.last_day
GROUP BY p.month, p.last_day, p.month_close
ORDER BY p.month