3,293 answered market questions

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