payments

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
    ex_date,
    ex_date_label,
    record_date_label,
    pay_date_label,
    cash_amount
FROM
(
    SELECT
        toString(ex_dividend_date)                    AS ex_date,
        formatDateTime(ex_dividend_date, '%d.%m.%Y')  AS ex_date_label,
        formatDateTime(max(record_date), '%d.%m.%Y')  AS record_date_label,
        formatDateTime(max(pay_date), '%d.%m.%Y')     AS pay_date_label,
        round(toFloat64(max(cash_amount)), 4)         AS cash_amount,
        ex_dividend_date                              AS sort_key
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND currency = 'USD'
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
    ORDER BY sort_key DESC
    LIMIT 12
)
ORDER BY sort_key