Upcoming ex-dividend dates and the size of the open-order reduction

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.

WITH
    upcoming AS
    (
        SELECT
            ticker,
            min(ex_dividend_date)                 AS ex_date,
            argMin(cash_amount, ex_dividend_date) AS dividend_usd
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND cash_amount > 0
          AND ex_dividend_date >= today()
          AND ex_dividend_date <= today() + 120
        GROUP BY ticker
    ),
    last_price AS
    (
        SELECT
            ticker,
            argMax(close, date) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
          AND date >= today() - 30
        GROUP BY ticker
    )
SELECT
    u.ticker                                                    AS ticker,
    formatDateTime(u.ex_date, '%b %e')                          AS ex_date_label,
    round(toFloat64(u.dividend_usd), 2)                         AS dividend_usd,
    round(100 * toFloat64(u.dividend_usd) / toFloat64(p.px), 3) AS reduction_pct
FROM upcoming AS u
INNER JOIN last_price AS p ON p.ticker = u.ticker
ORDER BY reduction_pct DESC