PG trailing twelve-month dividend yield against the month-end share price

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.

WITH px AS
(
    SELECT
        toStartOfMonth(date)           AS month,
        max(date)                      AS last_session,
        argMax(toFloat64(close), date) AS month_end_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'PG'
      AND date >= '2025-01-01'
    GROUP BY month
),
divs AS
(
    SELECT
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PG'
      AND ex_dividend_date >= '2023-12-01'
    GROUP BY ex_dividend_date
)
SELECT
    toString(p.month)                                AS month,
    round(p.month_end_close, 2)                      AS month_end_close,
    round(100 * sum(d.amt) / p.month_end_close, 2)   AS ttm_yield_pct
FROM px AS p
CROSS JOIN divs AS d
WHERE d.ex_dividend_date <= p.last_session
  AND d.ex_dividend_date >  subtractYears(p.last_session, 1)
GROUP BY p.month, p.month_end_close
ORDER BY p.month