preferred stock — 4 answered market questions

Quarterly payers by how many different per-share amounts they paid

most recentas of 2026-08-22 ranking 5×3read in context →

Quarterly payers by how many different per-share amounts they paid — 5 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
amount_pattern	securities	declarations
Same amount every time	787	8935
2 different amounts	431	4822
3 different amounts	435	4903
4 to 5 different amounts	817	9514
6 or more different amounts	1542	17385

the exact SQL behind every number

SELECT
    multiIf(distinct_amounts = 1,  'Same amount every time',
            distinct_amounts = 2,  '2 different amounts',
            distinct_amounts = 3,  '3 different amounts',
            distinct_amounts <= 5, '4 to 5 different amounts',
                                   '6 or more different amounts') AS amount_pattern,
    count()                                                       AS securities,
    sum(payments)                                                 AS declarations
FROM
(
    SELECT
        ticker,
        countDistinct(amount) AS distinct_amounts,
        count()               AS payments
    FROM
    (
        SELECT
            ticker,
            ex_dividend_date,
            any(cash_amount) AS amount
        FROM global_markets.stocks_dividends
        WHERE frequency = 4
          AND cash_amount > 0
          AND ex_dividend_date >= today() - 1095
          AND ex_dividend_date <= today()
        GROUP BY ticker, ex_dividend_date
    )
    GROUP BY ticker
    HAVING payments >= 8
)
GROUP BY amount_pattern
ORDER BY min(distinct_amounts)

More from this analysisHow Preferred Stock Dividends Work

Days from the ex-dividend date to the pay date, past two years ranking 6×3 → Dividend declarations by stated payment schedule, past three years ranking 5×3 → Monthly count of dividend declarations across the market series 36×4 → How a two-decade streak compounds: Microsoft's annual dividend, year by year ranking 22×2 → See all 2,170 queries →