yield_by_ex_date

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,
    concat(monthName(d.ex_dividend_date), ' ',
           toString(toDayOfMonth(d.ex_dividend_date)), ', ',
           toString(toYear(d.ex_dividend_date)))                      AS ex_dividend_pretty,
    round(toFloat64(p.close), 2)                                      AS close_price,
    round(100 * 4 * toFloat64(d.cash_amount) / toFloat64(p.close), 2) AS annualized_yield_pct
FROM
(
    SELECT
        ex_dividend_date,
        max(cash_amount) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date >= '2024-01-01'
    GROUP BY ex_dividend_date
) AS d
INNER JOIN
(
    SELECT
        date,
        max(close) AS close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2024-01-01'
    GROUP BY date
) AS p ON p.date = d.ex_dividend_date
ORDER BY d.ex_dividend_date