Payments in lieu owed on a 100-share AAPL short, by ex-dividend date

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,
    ex_date_label,
    dividend_cents_per_share,
    owed_per_100_shares,
    round(sum(owed_per_100_shares) OVER (ORDER BY ex_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), 2) AS owed_running_total_per_100
FROM
(
    SELECT
        toString(toDate(ex_dividend_date))                        AS ex_date,
        concat(formatDateTime(toDate(ex_dividend_date), '%b'), ' ',
               toString(toDayOfMonth(toDate(ex_dividend_date))), ', ',
               toString(toYear(toDate(ex_dividend_date))))        AS ex_date_label,
        round(toFloat64(max(cash_amount)) * 100, 2)               AS dividend_cents_per_share,
        round(toFloat64(max(cash_amount)) * 100, 2)               AS owed_per_100_shares
    FROM global_markets.stocks_dividends
    WHERE ticker = 'AAPL'
      AND ex_dividend_date >= '2025-09-01'
      AND ex_dividend_date <  '2026-09-01'
    GROUP BY ex_dividend_date
    HAVING max(cash_amount) > 0
)
ORDER BY ex_date