dividends_forgone

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,
    dividend_per_share,
    round(sum(dividend_per_share) OVER (ORDER BY ex_date), 4) AS cumulative_per_share
FROM
(
    SELECT
        ex_dividend_date                      AS ex_date,
        round(max(toFloat64(cash_amount)), 4) AS dividend_per_share
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date <= (
            SELECT max(date)
            FROM global_markets.options_greeks
            WHERE underlying_symbol = 'AAPL'
      )
      AND ex_dividend_date > subtractDays(
          (
            SELECT max(date)
            FROM global_markets.options_greeks
            WHERE underlying_symbol = 'AAPL'
          ), 365)
    GROUP BY ex_dividend_date
)
ORDER BY ex_date