Share of annual raises declared in the same month as the prior raise, by year
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-03, from When Companies Announce Dividend Raises.
| year | companies | same_month_pct | within_one_month_pct |
|---|---|---|---|
| 2017 | 1104 | 68.6 | 73.4 |
| 2018 | 1159 | 64.7 | 78.2 |
| 2019 | 1399 | 64.7 | 74 |
| 2020 | 1368 | 64.3 | 74.5 |
| 2021 | 1278 | 64.4 | 78.7 |
| 2022 | 1343 | 60.9 | 77.3 |
| 2023 | 1576 | 66.9 | 82.4 |
| 2024 | 1649 | 62 | 81.9 |
| 2025 | 1980 | 56.9 | 80.7 |
| 2026 | 1154 | 74.5 | 82.8 |
- Rows × columns
- 10 × 4
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
year |
number | 2,017 to 2,026 | |
companies |
number | 1,104 to 1,980 | |
same_month_pct |
number | 56.9 to 74.5 | percent |
within_one_month_pct |
number | 73.4 to 82.8 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
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 quarterly AS (
SELECT ticker,
ex_dividend_date,
round(max(toFloat64(cash_amount)), 4) AS amount,
max(declaration_date) AS declared
FROM global_markets.stocks_dividends
WHERE distribution_type = 'recurring'
AND frequency = 4
AND cash_amount > 0
AND declaration_date > toDate('2015-06-30')
AND ex_dividend_date >= toDate('2015-07-01')
AND ex_dividend_date <= toDate('2026-07-31')
GROUP BY ticker, ex_dividend_date
),
stepped AS (
SELECT ticker,
declared,
amount,
ex_dividend_date,
lagInFrame(amount, 1) OVER (PARTITION BY ticker ORDER BY ex_dividend_date ASC
ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_amount,
lagInFrame(ex_dividend_date, 1) OVER (PARTITION BY ticker ORDER BY ex_dividend_date ASC
ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_ex_date
FROM quarterly
),
raises AS (
SELECT ticker, declared
FROM stepped
WHERE prior_amount > 0
AND amount > prior_amount * 1.005
AND dateDiff('day', prior_ex_date, ex_dividend_date) BETWEEN 45 AND 200
),
chained AS (
SELECT ticker,
declared,
lagInFrame(declared, 1) OVER (PARTITION BY ticker ORDER BY declared ASC
ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_declared
FROM raises
)
SELECT toYear(declared) AS year,
uniqExact(ticker) AS companies,
round(100 * countIf(toMonth(declared) = toMonth(prior_declared)) / count(), 1) AS same_month_pct,
round(100 * countIf(abs(toInt32(toRelativeMonthNum(declared))
- toInt32(toRelativeMonthNum(prior_declared)) - 12) <= 1) / count(), 1) AS within_one_month_pct
FROM chained
WHERE declared >= toDate('2017-01-01')
AND dateDiff('day', prior_declared, declared) BETWEEN 250 AND 480
GROUP BY year
ORDER BY year