pep_2026_schedule

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 toFloat64(max(cash_amount))
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND toYear(ex_dividend_date) = 2026
      AND toQuarter(ex_dividend_date) = 1
) AS q1_rate
SELECT
    toString(argMin(ex_date, src))                              AS ex_dividend_date,
    concat('Q', toString(q), ' 2026')                           AS quarter,
    if(min(src) = 0, 'confirmed', 'scheduled')                  AS status,
    if(min(src) = 0 AND argMin(decl_date, src) > toDate('2000-01-01'),
       formatDateTime(argMin(decl_date, src), '%b %e, %Y'),
       'not yet declared')                                      AS declared,
    formatDateTime(argMin(rec_date, src), '%b %e, %Y')          AS record_date,
    formatDateTime(argMin(pay_dt, src), '%b %e, %Y')            AS payment_date,
    round(argMin(amt, src), 4)                                  AS cash_amount,
    round(100 * (toFloat64(argMin(amt, src)) / q1_rate - 1), 1) AS change_vs_q1_pct
FROM
(
    SELECT
        0                                              AS src,
        toQuarter(ex_dividend_date)                    AS q,
        ex_dividend_date                               AS ex_date,
        ifNull(declaration_date, toDate('1970-01-01')) AS decl_date,
        record_date                                    AS rec_date,
        pay_date                                       AS pay_dt,
        cash_amount                                    AS amt
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2026-01-01'
      AND ex_dividend_date <  '2027-01-01'
    UNION ALL
    SELECT
        1,
        toQuarter(ex_dividend_date),
        addYears(ex_dividend_date, 1),
        toDate('1970-01-01'),
        addYears(record_date, 1),
        addYears(pay_date, 1),
        (
            SELECT max(cash_amount)
            FROM global_markets.stocks_dividends
            WHERE ticker = 'PEP'
              AND ex_dividend_date >= '2026-01-01'
              AND ex_dividend_date <  '2027-01-01'
        )
    FROM global_markets.stocks_dividends
    WHERE ticker = 'PEP'
      AND ex_dividend_date >= '2025-01-01'
      AND ex_dividend_date <  '2026-01-01'
)
GROUP BY q
ORDER BY q