SPYM (formerly SPLG) quarterly distributions: declared, ex, record and pay dates

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      AS ex_date,
        max(cash_amount)      AS cash_paid,
        max(declaration_date) AS declared_on,
        max(record_date)      AS record_on,
        max(pay_date)         AS pay_on
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('SPYM', 'SPLG')
      AND cash_amount > 0
    GROUP BY ex_dividend_date
),
recent AS
(
    SELECT
        toString(ex_date)                        AS ex_dividend_date,
        formatDateTime(ex_date, '%b %e, %Y')     AS ex_date_label,
        round(cash_paid, 4)                      AS cash_per_share,
        formatDateTime(declared_on, '%b %e, %Y') AS declared_label,
        formatDateTime(record_on, '%b %e, %Y')   AS record_date_label,
        formatDateTime(pay_on, '%b %e, %Y')      AS pay_date_label
    FROM paid
    ORDER BY ex_date DESC
    LIMIT 12
)
SELECT *
FROM recent
ORDER BY ex_dividend_date