indexado

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 nke AS
(
    SELECT
        date,
        argMax(toFloat64(close), _ingest_time) AS px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'NKE'
      AND date >= '2021-01-01'
    GROUP BY date
),
euro AS
(
    SELECT
        date,
        argMax(toFloat64(close), _ingest_time) AS px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'FXE'
      AND date >= '2021-01-01'
    GROUP BY date
),
diario AS
(
    SELECT
        n.date        AS date,
        n.px          AS usd,
        e.px          AS fx,
        n.px / e.px   AS eur
    FROM nke AS n
    INNER JOIN euro AS e ON e.date = n.date
),
mensual AS
(
    SELECT
        toStartOfMonth(date) AS m,
        argMax(usd, date)    AS usd,
        argMax(eur, date)    AS eur,
        argMax(fx, date)     AS fx
    FROM diario
    GROUP BY m
),
base AS
(
    SELECT
        argMin(usd, m) AS usd0,
        argMin(eur, m) AS eur0,
        argMin(fx, m)  AS fx0
    FROM mensual
)
SELECT
    toString(x.m)                     AS month,
    round(x.usd / b.usd0 * 100, 1)    AS nke_en_dolares,
    round(x.eur / b.eur0 * 100, 1)    AS nke_en_euros,
    round(x.fx  / b.fx0  * 100, 1)    AS euro_frente_al_dolar
FROM mensual AS x
CROSS JOIN base AS b
ORDER BY x.m