Indicated dividend yield on every Microsoft ex-dividend date since 2024

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_day)                                                          AS ex_date,
    concat(formatDateTime(d.ex_day, '%b'), ' ',
           toString(toDayOfMonth(d.ex_day)), ', ',
           toString(toYear(d.ex_day)))                                          AS ex_label,
    round(toFloat64(d.dividend), 2)                                             AS quarterly_dividend,
    round(toFloat64(d.dividend) * 4, 2)                                         AS indicated_annual_dividend,
    concat('$', toString(round(toFloat64(p.close), 2)))                         AS close_on_ex_date,
    round(toFloat64(d.dividend) * 4 / toFloat64(p.close) * 100, 2)              AS indicated_yield_pct
FROM
(
    SELECT
        ex_dividend_date    AS ex_day,
        any(cash_amount)    AS dividend
    FROM global_markets.stocks_dividends
    WHERE ticker = 'MSFT'
      AND ex_dividend_date >= toDate('2024-01-01')
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
) AS d
INNER JOIN
(
    SELECT
        toDate(date)        AS day,
        any(close)          AS close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'MSFT'
      AND date >= toDate('2024-01-01')
      AND date <= today()
    GROUP BY day
) AS p ON p.day = d.ex_day
ORDER BY d.ex_day