ko_trace

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(declared_dt, '%d/%m/%Y')      AS declared_label,
    formatDateTime(ex_dividend_date, '%d/%m/%Y') AS ex_label,
    formatDateTime(record_dt, '%d/%m/%Y')        AS record_label,
    formatDateTime(pay_dt, '%d/%m/%Y')           AS pay_label,
    round(toFloat64(dividend), 4)                AS dividend_usd
FROM
(
    SELECT
        ex_dividend_date,
        argMax(declaration_date, _ingest_time) AS declared_dt,
        argMax(record_date, _ingest_time)      AS record_dt,
        argMax(pay_date, _ingest_time)         AS pay_dt,
        argMax(cash_amount, _ingest_time)      AS dividend
    FROM global_markets.stocks_dividends
    WHERE ticker = 'KO'
      AND cash_amount > 0
      AND ex_dividend_date <= today()
      AND declaration_date >= toDate('2000-01-01')
      AND record_date      >= toDate('2000-01-01')
      AND pay_date         >= toDate('2000-01-01')
    GROUP BY ex_dividend_date
    ORDER BY ex_dividend_date DESC
    LIMIT 8
)
ORDER BY ex_dividend_date