history_years

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
    toYear(ex_dividend_date)                    AS year,
    round(toFloat64(max(cash_usd)), 2)          AS quartalsrate_usd,
    round(toFloat64(sum(cash_usd)), 2)          AS jahressumme_usd,
    arrayStringConcat(
        arrayMap(d -> formatDateTime(d, '%d.%m.'), arraySort(groupArray(zahl_datum))),
        ' | ')                                  AS zahltage
FROM
(
    SELECT
        ex_dividend_date,
        any(pay_date)    AS zahl_datum,
        max(cash_amount) AS cash_usd
    FROM global_markets.stocks_dividends
    WHERE ticker = 'IBM'
      AND toYear(ex_dividend_date) >= toYear(today()) - 15
      AND toYear(ex_dividend_date) <  toYear(today())
    GROUP BY ex_dividend_date
)
GROUP BY year
ORDER BY year