ex_calendar

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
    (
        SELECT groupArray(date)
        FROM global_markets.stocks_market_holidays
        WHERE status = 'closed'
    ) AS us_closures,
    arrayFirst(
        d -> (toDayOfWeek(d) <= 5) AND NOT has(us_closures, d),
        arrayMap(i -> ex_dividend_date - i, range(1, 6))
    ) AS last_buy_day
SELECT
    ticker,
    formatDateTime(ex_dividend_date, '%a, %b %e')  AS us_ex,
    formatDateTime(last_buy_day, '%a, %b %e')      AS last_us_session,
    formatDateTime(
        toTimeZone(
            toDateTime(concat(toString(last_buy_day), ' 16:00:00'), 'America/New_York'),
            'Asia/Manila'),
        '%a, %b %e, %I:%i %p')                     AS manila_cutoff,
    round(declared_amount, 4)                      AS cash_amount
FROM
(
    SELECT
        ticker,
        ex_dividend_date,
        max(cash_amount) AS declared_amount
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= today()
      AND cash_amount > 0
      AND ticker IN ('AAPL', 'ABBV', 'BLK', 'CAT', 'CSCO', 'CVX', 'HD', 'IBM', 'JNJ',
                     'JPM', 'KO', 'MCD', 'MRK', 'MSFT', 'PEP', 'PG', 'VZ', 'XOM')
    GROUP BY ticker, ex_dividend_date
    ORDER BY ex_dividend_date, ticker
    LIMIT 12
)
ORDER BY ex_dividend_date, ticker