index investing — 4 answered market questions

Trailing twelve month distribution yields: broad index, equal weight, dividend screens, sector funds

most recentas of 2026-10-04 table 9×6read in context →

Trailing twelve month distribution yields: broad index, equal weight, dividend screens, sector funds — 9 rows by 6 columns, computed 2026-10-04 from US exchange, SIP and OPRA data.
ticker	segment	price	ttm_distributions_usd	payments	trailing_yield_pct
SPY	broad index tracker	769.8	7.583	4	0.99
RSP	equal weight S&P 500	209.84	3.18	4	1.52
VYM	dividend screen	156.62	3.676	4	2.35
SCHD	dividend screen	32.76	1.054	4	3.22
SPYD	dividend screen	45.47	2.06	4	4.53
XLU	sector fund	39.95	1.212	4	3.03
XLP	sector fund	80.43	2.197	4	2.73
XLRE	sector fund	40.95	1.443	4	3.52
XLK	sector fund	199.87	0.835	4	0.42

the exact SQL behind every number

WITH px AS (
    SELECT ticker,
           argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SPY', 'RSP', 'VYM', 'SCHD', 'SPYD', 'XLU', 'XLP', 'XLRE', 'XLK')
      AND window_start >= now() - INTERVAL 7 DAY
      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,
           sum(cash_amount) AS ttm_distributions,
           count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('SPY', 'RSP', 'VYM', 'SCHD', 'SPYD', 'XLU', 'XLP', 'XLRE', 'XLK')
      AND ex_dividend_date > today() - INTERVAL 1 YEAR
      AND ex_dividend_date <= today()
      AND cash_amount > 0
    GROUP BY ticker
)
SELECT px.ticker AS ticker,
       multiIf(px.ticker = 'SPY', 'broad index tracker',
               px.ticker = 'RSP', 'equal weight S&P 500',
               px.ticker IN ('VYM', 'SCHD', 'SPYD'), 'dividend screen',
               'sector fund') AS segment,
       round(px.price, 2) AS price,
       round(dv.ttm_distributions, 3) AS ttm_distributions_usd,
       dv.payments AS payments,
       round(dv.ttm_distributions / px.price * 100, 2) AS trailing_yield_pct
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
ORDER BY multiIf(px.ticker = 'SPY', 1,
                 px.ticker = 'RSP', 2,
                 px.ticker = 'VYM', 3,
                 px.ticker = 'SCHD', 4,
                 px.ticker = 'SPYD', 5,
                 px.ticker = 'XLU', 6,
                 px.ticker = 'XLP', 7,
                 px.ticker = 'XLRE', 8,
                 9)

More from this analysisS&P 500 Dividend Yield: How It's Measured

Tracker distribution yield vs the 10 year Treasury, calendar year ends 2015-2025 table 11×5 → Cap weighted vs equal weighted dividend yield, by company size table 5×6 → SPY distributions per share and price, both rebased to 100 at 2015 ranking 11×3 → Monthly dividend stocks - filing companies paying every month, ranked by daily traded value table 31×6 → See all 3,256 queries →