Trailing four payments against the indicated rate, by quarter

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.

SELECT
    ex_date,
    ex_date_label,
    trailing_4_payments,
    indicated_rate
FROM
(
    SELECT
        toString(ex_dividend_date)                 AS ex_date,
        formatDateTime(ex_dividend_date, '%b %Y')  AS ex_date_label,
        ex_dividend_date                           AS d,
        round(4 * amt, 4)                          AS indicated_rate,
        round(sum(amt) OVER (ORDER BY ex_dividend_date ROWS BETWEEN 3 PRECEDING AND CURRENT ROW), 4) AS trailing_4_payments
    FROM
    (
        SELECT
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS amt
        FROM global_markets.stocks_dividends
        WHERE ticker = 'AAPL'
          AND ex_dividend_date >= '2021-07-01'
          AND ex_dividend_date <  '2026-07-01'
        GROUP BY ex_dividend_date
    )
)
WHERE d >= '2022-07-01'
ORDER BY d