-- finance migration 0007: dividend payout history (Phase 26).
--
-- A stock's per-event dividend history (ex-dividend date + per-share amount),
-- pulled from Yahoo's chart `events.dividends` series. Used on the symbol page
-- to show the payout cadence, prior-year and YTD totals, and an on-track pace
-- read. Stocks only: ETFs, indexes and futures do not pay regular dividends
-- in this app's sense.

-- When this stock's dividend history was last refreshed from Yahoo. NULL =
-- never. Driven by the new `dividends` scheduler job (weekly cadence).
ALTER TABLE symbols ADD COLUMN dividends_synced_at INTEGER;


CREATE INDEX dividends_ticker_date ON dividends(ticker, ex_date DESC);
