raises

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 paid AS
(
    SELECT
        ex_dividend_date,
        min(declaration_date)        AS declared,
        max(toFloat64(cash_amount))  AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'IBM'
      AND ex_dividend_date >= '2019-01-01'
      AND ex_dividend_date <= today()
    GROUP BY ex_dividend_date
),
stepped AS
(
    SELECT
        ex_dividend_date,
        declared,
        amount,
        lagInFrame(amount, 1, toFloat64(0)) OVER (ORDER BY ex_dividend_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prev_amount
    FROM paid
)
SELECT
    formatDateTime(declared, '%d.%m.%Y')          AS declared_label,
    formatDateTime(ex_dividend_date, '%d.%m.%Y')  AS first_ex_date_label,
    round(amount, 2)                              AS quarterly_usd,
    round(amount - prev_amount, 2)                AS step_usd,
    round((amount / prev_amount - 1) * 100, 2)    AS step_pct,
    round(amount * 4, 2)                          AS annual_usd
FROM stepped
WHERE prev_amount > 0
  AND amount > prev_amount
  AND ex_dividend_date >= '2021-01-01'
ORDER BY ex_dividend_date