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

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.

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)