dividendos

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 pagos AS
(
    SELECT
        pay_date                    AS d,
        toFloat64(max(cash_amount)) AS usd
    FROM global_markets.stocks_dividends
    WHERE ticker = 'NKE'
      AND pay_date >= '2016-01-01'
      AND pay_date <= today()
      AND cash_amount > 0
    GROUP BY pay_date
),
euro_mes AS
(
    SELECT
        toStartOfMonth(date)  AS m,
        avg(toFloat64(close)) AS fx
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'FXE'
      AND date >= '2015-12-01'
    GROUP BY m
),
convertido AS
(
    SELECT
        p.d          AS d,
        p.usd        AS usd,
        p.usd / e.fx AS eur
    FROM pagos AS p
    INNER JOIN euro_mes AS e ON e.m = toStartOfMonth(p.d)
),
base AS
(
    SELECT
        argMin(usd, d) AS usd0,
        argMin(eur, d) AS eur0
    FROM convertido
)
SELECT
    toString(c.d)                          AS date,
    round(c.usd, 4)                        AS dividendo_usd,
    round((c.usd / b.usd0 - 1) * 100, 1)   AS acumulado_en_dolares_pct,
    round((c.eur / b.eur0 - 1) * 100, 1)   AS acumulado_en_euros_pct
FROM convertido AS c
CROSS JOIN base AS b
ORDER BY c.d