SPY daily closes across a pinned 61 day wash sale window, Jan to Mar 2025

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 toFloat64(any(close))
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date = '2025-02-14'
) AS sale_day_close
SELECT
    toString(date)                                          AS date,
    formatDateTime(toDate(date), '%b %e, %Y')               AS session_label,
    round(toFloat64(close), 2)                              AS close,
    round(100 * (toFloat64(close) / sale_day_close - 1), 2) AS change_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
  AND date >= '2025-01-15'
  AND date <= '2025-03-16'
ORDER BY date