Dividend outcome over the following 12 months by starting yield band (cohort of June 30, 2025)

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_base AS (
    SELECT ticker,
           argMax(toFloat64(close), window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE toDate(toTimeZone(window_start, 'America/New_York')) = toDate('2025-06-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker
    HAVING price >= 5
),
rate_before AS (
    SELECT ticker,
           argMax(toFloat64(cash_amount) * frequency, ex_dividend_date) AS annual_rate
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND frequency = 4
      AND cash_amount > 0
      AND ex_dividend_date > toDate('2024-06-30')
      AND ex_dividend_date <= toDate('2025-06-30')
    GROUP BY ticker
),
rate_after AS (
    SELECT ticker,
           argMax(toFloat64(cash_amount) * frequency, ex_dividend_date) AS annual_rate
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND frequency > 0
      AND cash_amount > 0
      AND ex_dividend_date > toDate('2025-06-30')
      AND ex_dividend_date <= toDate('2026-06-30')
    GROUP BY ticker
)
SELECT multiIf(100 * b.annual_rate / p.price >= 8, '8% and up',
               100 * b.annual_rate / p.price >= 6, '6-8%',
               100 * b.annual_rate / p.price >= 4, '4-6%',
               100 * b.annual_rate / p.price >= 2, '2-4%',
               'under 2%') AS yield_band,
       count() AS payers,
       round(quantileDeterministic(0.5)(100 * b.annual_rate / p.price, cityHash64(p.ticker)), 2) AS median_yield_pct,
       round(100 * countIf(ifNull(a.annual_rate, 0) = 0) / count(), 1) AS pct_stopped_paying,
       round(100 * countIf(ifNull(a.annual_rate, 0) > 0 AND a.annual_rate < b.annual_rate * 0.99) / count(), 1) AS pct_reduced_rate,
       round(100 * countIf(ifNull(a.annual_rate, 0) = 0 OR a.annual_rate < b.annual_rate * 0.99) / count(), 1) AS pct_reduced_or_stopped,
       round(100 * countIf(ifNull(a.annual_rate, 0) >= b.annual_rate * 0.99) / count(), 1) AS pct_maintained_or_raised
FROM px_base AS p
INNER JOIN rate_before AS b ON p.ticker = b.ticker
LEFT JOIN rate_after AS a ON p.ticker = a.ticker
GROUP BY yield_band
ORDER BY median_yield_pct