aapl_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
    ex_dividend_date,
    formatDateTime(ex_dividend_date, '%d.%m.%Y') AS ex_label,
    round(toFloat64(amt), 4)                     AS gross_per_share,
    round(toFloat64(amt) * 0.70, 4)              AS net_per_share
FROM
(
    SELECT
        ex_dividend_date,
        max(cash_amount) AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND currency = 'USD'
      AND cash_amount > 0
      AND ex_dividend_date >= today() - 1460
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
)
ORDER BY ex_dividend_date