calendrier

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
    sym                                  AS ticker,
    formatDateTime(ex_date, '%e %b %Y')  AS detachement,
    formatDateTime(rec_date, '%e %b %Y') AS arrete_des_positions,
    formatDateTime(pay_dt, '%e %b %Y')   AS paiement,
    dateDiff('day', ex_date, rec_date)   AS jours_detachement_record,
    dateDiff('day', ex_date, pay_dt)     AS jours_detachement_paiement
FROM
(
    SELECT
        any(ticker)           AS sym,
        any(ex_dividend_date) AS ex_date,
        any(record_date)      AS rec_date,
        any(pay_date)         AS pay_dt
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'PG', 'JNJ', 'XOM', 'CVX', 'PEP', 'MCD', 'HD',
                     'JPM', 'ABBV', 'MRK', 'PFE', 'WMT', 'CSCO', 'IBM', 'VZ', 'T', 'CAT',
                     'TXN', 'UNH', 'ADP', 'COST', 'AXP', 'BAC', 'CL', 'AMGN', 'BLK', 'DE')
      AND ex_dividend_date >= today()
      AND ex_dividend_date <= today() + 120
      AND currency = 'USD'
      AND pay_date >= ex_dividend_date
    GROUP BY id
)
ORDER BY ex_date
LIMIT 12