qqq_en_euros

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
    qqq AS
    (
        SELECT
            toStartOfMonth(date)             AS m,
            argMax(toFloat64(close), date)   AS usd_close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'QQQ'
          AND date >= addMonths(toStartOfMonth(today()), -60)
          AND date <  toStartOfMonth(today())
        GROUP BY m
    ),
    eur AS
    (
        SELECT
            toStartOfMonth(date)             AS m,
            argMax(toFloat64(close), date)   AS eur_unit
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'FXE'
          AND date >= addMonths(toStartOfMonth(today()), -60)
          AND date <  toStartOfMonth(today())
        GROUP BY m
    ),
    paired AS
    (
        SELECT
            qqq.m                            AS m,
            qqq.usd_close                    AS in_usd,
            qqq.usd_close / eur.eur_unit     AS in_eur
        FROM qqq
        INNER JOIN eur ON qqq.m = eur.m
    ),
    base AS
    (
        SELECT
            argMin(in_usd, m) AS base_usd,
            argMin(in_eur, m) AS base_eur
        FROM paired
    )
SELECT
    formatDateTime(paired.m, '%Y-%m')                             AS month,
    round(100 * paired.in_usd / base.base_usd, 1)                 AS qqq_usd_index,
    round(100 * paired.in_eur / base.base_eur, 1)                 AS qqq_eur_index,
    round(100 * (((paired.in_eur / base.base_eur) / (paired.in_usd / base.base_usd)) - 1), 1) AS fx_gap_pct
FROM paired
CROSS JOIN base
ORDER BY paired.m