cycle_reglement

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
    formatDateTime(mois, '%Y-%m')                                        AS month,
    concat(arrayElement(['janv.', 'févr.', 'mars', 'avr.', 'mai', 'juin',
                         'juil.', 'août', 'sept.', 'oct.', 'nov.', 'déc.'],
                        toMonth(mois)),
           ' ',
           toString(toYear(mois)))                                       AS mois_label,
    toUInt16(round(100 * countIf(record_date = ex_date) / count()))       AS part_meme_jour_pct,
    count()                                                              AS events_count
FROM
(
    SELECT
        toStartOfMonth(ex_dividend_date) AS mois,
        ex_dividend_date                 AS ex_date,
        record_date
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= '2023-07-01'
      AND ex_dividend_date <  '2025-07-01'
      AND cash_amount > 0
      AND record_date >= ex_dividend_date
      AND dateDiff('day', ex_dividend_date, record_date) <= 7
    GROUP BY ticker, ex_dividend_date, record_date
)
GROUP BY mois
HAVING events_count >= 50
ORDER BY mois