calendar_2026

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
    concat('Q', toString(toQuarter(zahl_datum)), ' ', toString(toYear(zahl_datum))) AS quartal,
    formatDateTime(beschluss_datum, '%d.%m.%Y')   AS beschluss,
    formatDateTime(ex_dividend_date, '%d.%m.%Y')  AS ex_tag,
    formatDateTime(stichtag_datum, '%d.%m.%Y')    AS stichtag,
    formatDateTime(zahl_datum, '%d.%m.%Y')        AS zahltag,
    round(toFloat64(cash_usd), 2)                 AS dividende_usd,
    round(toFloat64(cash_usd) * 4, 2)             AS jahresrate_usd
FROM
(
    SELECT
        ex_dividend_date,
        any(declaration_date) AS beschluss_datum,
        any(record_date)      AS stichtag_datum,
        any(pay_date)         AS zahl_datum,
        max(cash_amount)      AS cash_usd
    FROM global_markets.stocks_dividends
    WHERE ticker = 'IBM'
      AND toYear(pay_date) = 2026
    GROUP BY ex_dividend_date
)
ORDER BY ex_dividend_date