declarations

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, '%b %e, %Y')       AS ex_date_label,
    round(max(toFloat64(cash_amount)), 4)               AS cash_amount,
    formatDateTime(max(record_date), '%b %e, %Y')       AS record,
    formatDateTime(max(pay_date), '%b %e, %Y')          AS payable,
    formatDateTime(max(declaration_date), '%b %e, %Y')  AS declared
FROM global_markets.stocks_dividends
WHERE ticker = 'HON'
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date DESC
LIMIT 16