Year-end dividend rate against twelve months earlier: how many large REITs raised or lowered

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 yearly AS (
    SELECT ticker,
           toYear(ex_dividend_date) AS pay_year,
           argMax(toFloat64(cash_amount), ex_dividend_date) AS year_end_rate
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('O','SPG','PLD','PSA','AVB','EQR','VTR','WELL','KIM','FRT','NNN','MAA','ARE','IRM')
      AND distribution_type = 'recurring'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2016-01-01')
      AND ex_dividend_date < toDate('2026-01-01')
    GROUP BY ticker, pay_year
),
shifted AS (
    SELECT ticker AS prior_ticker,
           pay_year + 1 AS compare_year,
           year_end_rate AS prior_rate
    FROM yearly
)
SELECT cur.pay_year AS year,
       count() AS reits_compared,
       countIf(cur.year_end_rate > shifted.prior_rate * 1.005) AS raised,
       countIf(cur.year_end_rate < shifted.prior_rate * 0.995) AS lowered,
       countIf(cur.year_end_rate >= shifted.prior_rate * 0.995
               AND cur.year_end_rate <= shifted.prior_rate * 1.005) AS unchanged
FROM yearly AS cur
INNER JOIN shifted ON cur.ticker = shifted.prior_ticker AND cur.pay_year = shifted.compare_year
WHERE cur.pay_year >= 2017
GROUP BY year
ORDER BY year