kalendarz

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_dividend_date)                                AS ex_date,
    formatDateTime(ex_dividend_date, '%d.%m.%Y')              AS dzien_ex,
    if(max(record_date) > toDate('2000-01-01'),
       formatDateTime(max(record_date), '%d.%m.%Y'),
       'nie podano')                                          AS dzien_ustalenia_praw,
    if(max(pay_date) > toDate('2000-01-01'),
       formatDateTime(max(pay_date), '%d.%m.%Y'),
       'nie podano')                                          AS dzien_wyplaty,
    round(toFloat64(max(cash_amount)), 4)                     AS kwota_usd,
    if(ex_dividend_date >= today(), 'przed nami', 'za nami')  AS status
FROM global_markets.stocks_dividends
WHERE ticker = 'PFE'
  AND ex_dividend_date >= today() - 830
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date