PFE prior close versus the ex-dividend morning opening print

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 px AS
(
    SELECT
        date,
        toFloat64(any(open))  AS open_px,
        toFloat64(any(close)) AS close_px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'PFE'
      AND date >= '2024-01-01'
      AND date <  '2026-10-01'
    GROUP BY date
),
lagged AS
(
    SELECT
        date,
        open_px,
        lagInFrame(close_px, 1) OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW) AS prior_close
    FROM px
),
divs AS
(
    SELECT
        ex_dividend_date            AS ex_date,
        toFloat64(max(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PFE'
      AND cash_amount > 0
      AND ex_dividend_date >= '2024-06-01'
    GROUP BY ex_dividend_date
)
SELECT
    toString(d.ex_date)                                         AS ex_date,
    formatDateTime(d.ex_date, '%b %e, %Y')                      AS ex_date_label,
    round(d.amount, 4)                                          AS dividend_per_share,
    round(l.prior_close, 2)                                     AS prior_close,
    round(l.open_px, 2)                                         AS ex_date_open,
    round(100 * (l.open_px - l.prior_close) / l.prior_close, 2) AS open_vs_prior_close_pct
FROM divs AS d
INNER JOIN lagged AS l ON l.date = d.ex_date
WHERE l.prior_close > 0
ORDER BY d.ex_date