Capital needed for $12,000 a year of distributions, by fund yield

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 ticker, argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('JEPI', 'SPYD', 'VYM', 'SCHD', 'HDV', 'DVY', 'VIG', 'SPY', 'XLU', 'VNQ')
      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_div, count() AS payments
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('JEPI', 'SPYD', 'VYM', 'SCHD', 'HDV', 'DVY', 'VIG', 'SPY', 'XLU', 'VNQ')
      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,
       round(px.price, 2) AS price,
       dv.payments AS payments,
       round(dv.ttm_div / px.price * 100, 2) AS trailing_yield_pct,
       round(12000 / (dv.ttm_div / px.price) / 1000, 0) AS capital_thousands_usd
FROM px
INNER JOIN dv ON px.ticker = dv.ticker
ORDER BY trailing_yield_pct DESC