Current yield vs five-year dividend growth: ten household payers, July 2026

WITH px AS (
    SELECT ticker,
           argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('MSFT','MCD','HD','PG','KO','JNJ','XOM','CVX','VZ','MO')
      AND window_start >= toDateTime('2026-07-20 00:00:00')
      AND window_start < toDateTime('2026-07-31 00:00:00')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker
),
dv AS (
    SELECT ticker,
           sumIf(cash_amount, ex_dividend_date > toDate('2025-07-30')
                          AND ex_dividend_date <= toDate('2026-07-30')) AS ttm_now,
           sumIf(cash_amount, ex_dividend_date > toDate('2020-07-30')
                          AND ex_dividend_date <= toDate('2021-07-30')) AS ttm_five_years_ago
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('MSFT','MCD','HD','PG','KO','JNJ','XOM','CVX','VZ','MO')
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ((ex_dividend_date > toDate('2020-07-30') AND ex_dividend_date <= toDate('2021-07-30'))
        OR (ex_dividend_date > toDate('2025-07-30') AND ex_dividend_date <= toDate('2026-07-30')))
    GROUP BY ticker
)
SELECT px.ticker AS symbol,
       round(dv.ttm_now / px.price * 100, 2) AS current_yield_pct,
       round(100 * (dv.ttm_now / dv.ttm_five_years_ago - 1), 1) AS five_year_dividend_growth_pct,
       round(dv.ttm_now, 2) AS dividends_per_share_ttm
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
WHERE dv.ttm_five_years_ago > 0
  AND dv.ttm_now > 0
ORDER BY current_yield_pct