PFE配当2026の権利落ち日と支払日

SELECT
    toString(ex_dt)                                      AS ex_date,
    formatDateTime(ex_dt, '%b %e, %Y')                   AS ex_date_label,
    formatDateTime(any(declared_on), '%b %e, %Y')        AS declared_label,
    formatDateTime(any(record_on), '%b %e, %Y')          AS record_date_label,
    formatDateTime(any(paid_on), '%b %e, %Y')            AS pay_date_label,
    round(max(amount), 4)                                AS cash_amount,
    if(ex_dt > today(), 'still ahead', 'already passed')  AS ex_date_status
FROM
(
    SELECT
        ex_dividend_date       AS ex_dt,
        declaration_date       AS declared_on,
        record_date            AS record_on,
        pay_date               AS paid_on,
        toFloat64(cash_amount) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PFE'
      AND cash_amount > 0
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
)
GROUP BY ex_dt
ORDER BY ex_dt

SELECT
    toString(toYear(ex_date))       AS year,
    count()                         AS payments,
    round(min(amount), 4)           AS lowest_quarterly_rate,
    round(max(amount), 4)           AS highest_quarterly_rate,
    round(sum(amount), 4)           AS declared_per_share_for_year,
    uniqExact(amount)               AS distinct_rates
FROM
(
    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 >= '2017-01-01'
      AND ex_dividend_date <  '2027-01-01'
    GROUP BY ex_dividend_date
)
GROUP BY year
ORDER BY year

WITH monthly AS
(
    SELECT
        toStartOfMonth(date)           AS m,
        max(date)                      AS last_session,
        argMax(toFloat64(close), date) AS month_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'PFE'
      AND date >= '2026-01-01'
      AND date <  '2026-10-01'
    GROUP BY m
),
quarterly 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-01-01'
      AND ex_dividend_date <  '2027-01-01'
    GROUP BY ex_dividend_date
)
SELECT
    toString(max(mo.last_session))                                        AS month_end,
    formatDateTime(max(mo.last_session), '%b %e, %Y')                     AS month_label,
    round(max(mo.month_close), 2)                                         AS close_price,
    round(4 * argMax(q.amount, q.ex_date), 4)                             AS annual_rate,
    round(100 * 4 * argMax(q.amount, q.ex_date) / max(mo.month_close), 2) AS indicated_yield_pct
FROM monthly AS mo
CROSS JOIN quarterly AS q
WHERE q.ex_date <= mo.last_session
GROUP BY mo.m
ORDER BY mo.m

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