jnj_payments

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
    toString(ex_d)                                   AS ex_dividend_date,
    formatDateTime(decl_d, '%d %b %Y')               AS declared_label,
    formatDateTime(ex_d, '%d %b %Y')                 AS ex_date_label,
    formatDateTime(rec_d, '%d %b %Y')                AS record_label,
    formatDateTime(pay_d, '%d %b %Y')                AS pay_date_label,
    round(cash_usd, 4)                               AS cash_per_share_usd,
    round(sum(cash_usd) OVER (ORDER BY ex_d), 4)     AS cumulative_usd
FROM
(
    SELECT
        ex_dividend_date                 AS ex_d,
        any(declaration_date)            AS decl_d,
        any(record_date)                 AS rec_d,
        any(pay_date)                    AS pay_d,
        toFloat64(max(cash_amount))      AS cash_usd
    FROM global_markets.stocks_dividends
    WHERE ticker = 'JNJ'
      AND ex_dividend_date >= today() - 365
      AND ex_dividend_date <  today()
    GROUP BY ex_dividend_date
)
ORDER BY ex_d