pfe_2026_calendar

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
    toString(ex_dt)                                      AS ex_date,
    formatDateTime(ex_dt, '%b %e, %Y')                   AS ex_date_label,
    formatDateTime(any(declared_on), '%b %e, %Y')        AS declared_label,
    formatDateTime(any(record_on), '%b %e, %Y')          AS record_date_label,
    formatDateTime(any(paid_on), '%b %e, %Y')            AS pay_date_label,
    round(max(amount), 4)                                AS cash_amount,
    if(ex_dt > today(), 'still ahead', 'already passed')  AS ex_date_status
FROM
(
    SELECT
        ex_dividend_date       AS ex_dt,
        declaration_date       AS declared_on,
        record_date            AS record_on,
        pay_date               AS paid_on,
        toFloat64(cash_amount) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PFE'
      AND cash_amount > 0
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
)
GROUP BY ex_dt
ORDER BY ex_dt