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
    toString(ex_date)                     AS ex_date,
    ex_pretty,
    declared_on,
    record_on,
    paid_on,
    cash_amount
FROM
(
    SELECT
        ex_dividend_date                                   AS ex_date,
        formatDateTime(ex_dividend_date, '%b %e, %Y')      AS ex_pretty,
        formatDateTime(max(declaration_date), '%b %e, %Y') AS declared_on,
        formatDateTime(max(record_date), '%b %e, %Y')      AS record_on,
        formatDateTime(max(pay_date), '%b %e, %Y')         AS paid_on,
        round(max(toFloat64(cash_amount)), 4)              AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= today() - 1300
    GROUP BY ex_dividend_date
)
ORDER BY ex_date DESC
LIMIT 13