weekly_52w

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
    (
        SELECT max(toFloat64(high))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'MSFT'
          AND date >= today() - 364
          AND date < today()
    ) AS hi_52w,
    (
        SELECT min(toFloat64(low))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'MSFT'
          AND date >= today() - 364
          AND date < today()
    ) AS lo_52w
SELECT
    toString(toMonday(date))                                        AS week,
    formatDateTime(toMonday(date), '%Y/%m/%d')                      AS week_label,
    round(argMax(toFloat64(close), date), 2)                        AS weekly_close,
    round(hi_52w, 2)                                                AS high_52w,
    round(lo_52w, 2)                                                AS low_52w,
    round((1 - argMax(toFloat64(close), date) / hi_52w) * 100, 1)   AS pct_below_52w_high,
    round((argMax(toFloat64(close), date) / lo_52w - 1) * 100, 1)   AS pct_above_52w_low,
    formatDateTime(max(date), '%Y/%m/%d')                           AS last_session
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'MSFT'
  AND date >= today() - 364
  AND date < today()
GROUP BY toMonday(date)
ORDER BY week