3,022 answered market questions

WITH monthly AS
(
    SELECT
        toStartOfMonth(date)           AS m,
        max(date)                      AS last_session,
        argMax(toFloat64(close), date) AS month_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'PFE'
      AND date >= '2026-01-01'
      AND date <  '2026-10-01'
    GROUP BY m
),
quarterly AS
(
    SELECT
        ex_dividend_date            AS ex_date,
        toFloat64(max(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PFE'
      AND cash_amount > 0
      AND ex_dividend_date >= '2024-01-01'
      AND ex_dividend_date <  '2027-01-01'
    GROUP BY ex_dividend_date
)
SELECT
    toString(max(mo.last_session))                                        AS month_end,
    formatDateTime(max(mo.last_session), '%b %e, %Y')                     AS month_label,
    round(max(mo.month_close), 2)                                         AS close_price,
    round(4 * argMax(q.amount, q.ex_date), 4)                             AS annual_rate,
    round(100 * 4 * argMax(q.amount, q.ex_date) / max(mo.month_close), 2) AS indicated_yield_pct
FROM monthly AS mo
CROSS JOIN quarterly AS q
WHERE q.ex_date <= mo.last_session
GROUP BY mo.m
ORDER BY mo.m