STRASMORE/EXPLORE 2,272 QUERIES

When dividend raises get declared: share by calendar month, starting from this month

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-09-16, from Dividend Increases Expected This Month.

as of ranking 12×3read in context →
When dividend raises get declared: share by calendar month, starting from this month — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
labeldeclaration_countshare_pct
Sep923
Oct32310.5
Nov2498.1
Dec1966.3
Jan36111.7
Feb59019.1
Mar1314.2
Apr2959.6
May2608.4
Jun792.6
Jul2849.2
Aug2277.4
Rows × columns
12 × 3
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for When dividend raises get declared: share by calendar month, starting from this month, derived from the stored result.
ColumnTypeRangeNotes
label text 12 distinct values (Apr, Aug, Dec…)
declaration_count number 79 to 590 count
share_pct number 2.6 to 19.1 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.

the exact SQL behind every number 
WITH changes AS
(
    SELECT
        ticker,
        ex_dividend_date,
        declaration_date,
        amount,
        prev_amount,
        (prev_amount > 0 AND amount > prev_amount
             AND declaration_date > toDate('2000-01-01'))            AS is_raise,
        (prev_amount > 0 AND amount < prev_amount)                   AS is_cut
    FROM
    (
        SELECT
            ticker,
            ex_dividend_date,
            declaration_date,
            amount,
            lagInFrame(amount, 1) OVER (PARTITION BY ticker ORDER BY ex_dividend_date
                                        ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prev_amount
        FROM
        (
            SELECT
                ticker,
                ex_dividend_date,
                ifNull(max(declaration_date), toDate('1970-01-01')) AS declaration_date,
                ifNull(max(toFloat64(cash_amount)), 0)              AS amount
            FROM global_markets.stocks_dividends
            WHERE toString(frequency) = '4'
              AND ex_dividend_date >= toDate('2020-01-01')
              AND ticker NOT IN ('SPCX')
            GROUP BY ticker, ex_dividend_date
        )
    )
),
growers AS
(
    SELECT ticker
    FROM changes
    GROUP BY ticker
    HAVING uniqExactIf(toYear(declaration_date),
                       is_raise AND (toYear(declaration_date) BETWEEN toYear(today()) - 5 AND toYear(today()) - 1)) = 5
       AND countIf(is_cut AND ex_dividend_date >= addYears(toStartOfYear(today()), -5)) = 0
)
SELECT
    label,
    declaration_count,
    round(100 * declaration_count / sum(declaration_count) OVER (), 1) AS share_pct
FROM
(
    SELECT
        toMonth(declaration_date)                      AS month_num,
        any(formatDateTime(declaration_date, '%b'))    AS label,
        count()                                        AS declaration_count
    FROM changes
    WHERE is_raise
      AND (toYear(declaration_date) BETWEEN toYear(today()) - 5 AND toYear(today()) - 1)
      AND ticker IN (SELECT ticker FROM growers)
    GROUP BY month_num
)
ORDER BY (month_num - toMonth(today()) + 12) % 12

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisDividend Increases Expected This Month
Companies expected to raise their dividend this month, declared names first series 13×7 → MSFT dividend raise declarations, 2019 to 2025 (pinned) series 7×6 → Declared vs. still expected: this month in each of the last six years series 6×4 → Dividend raises by declaration month: US recurring quarterly payers, July 2015 to July 2026 ranking 12×3 → Share of annual raises declared in the same month as the prior raise, by year ranking 10×4 → Typical raise month by company: twelve dividend growers, raises since 2016 series 12×5 → See all 2,272 queries →