One month of a crowded short, January 2021

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 px AS
(
    SELECT
        date,
        toFloat64(close) AS c
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'GME'
      AND date >= '2021-01-04'
      AND date <= '2021-02-05'
),
anchor AS
(
    SELECT
        argMin(c, date) AS first_close,
        max(c)          AS peak_close
    FROM px
)
SELECT
    toString(px.date)                                            AS date,
    formatDateTime(px.date, '%b %e, %Y')                         AS date_label,
    round((px.c / anchor.first_close - 1) * 100, 1)               AS change_vs_start_pct,
    round((anchor.peak_close / anchor.first_close - 1) * 100, 1)  AS window_peak_vs_start_pct
FROM px
CROSS JOIN anchor
ORDER BY px.date