One-time distributions by size: where the ex-date lands

SELECT
    multiIf(toFloat64(amount) <  0.5, 'Under $0.50',
            toFloat64(amount) <  2.0, '$0.50 to $2',
            toFloat64(amount) < 10.0, '$2 to $10',
            '$10 and up')                                  AS amount_bucket,
    count()                                                AS payout_count,
    round(100 * countIf(ex_date = record_on) / count(), 1) AS ex_on_record_pct,
    round(100 * countIf(ex_date > paid_on) / count(), 1)   AS ex_after_pay_pct
FROM
(
    SELECT
        id,
        any(ticker)           AS dividend_ticker,
        any(cash_amount)      AS amount,
        any(ex_dividend_date) AS ex_date,
        any(record_date)      AS record_on,
        any(pay_date)         AS paid_on
    FROM global_markets.stocks_dividends
    WHERE frequency = 0
      AND currency = 'USD'
      AND cash_amount > 0
      AND ex_dividend_date >= toDate('2024-09-01')
      AND ex_dividend_date <  today()
      AND record_date >= toDate('2000-01-01')
      AND pay_date    >= toDate('2000-01-01')
      AND ticker NOT IN ('SPCX')
    GROUP BY id
)
GROUP BY amount_bucket
ORDER BY min(toFloat64(amount)) ASC