The 61 day wash sale window around each late-December 2025 session

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 sessions AS
(
    SELECT DISTINCT toDate(toTimeZone(window_start, 'America/New_York')) AS d
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2025-11-18 00:00:00'
      AND window_start <  '2026-02-02 00:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
)
SELECT
    toString(s.d)                           AS sale_date,
    formatDateTime(s.d, '%b %e, %Y')        AS sale_label,
    formatDateTime(s.d - 30, '%b %e, %Y')   AS window_opens,
    formatDateTime(s.d + 30, '%b %e, %Y')   AS window_closes,
    countIf(t.d >= s.d - 30 AND t.d < s.d)  AS sessions_before,
    countIf(t.d > s.d AND t.d <= s.d + 30)  AS sessions_after
FROM
(
    SELECT d
    FROM sessions
    WHERE d >= '2025-12-22'
      AND d <  '2026-01-01'
) AS s
CROSS JOIN sessions AS t
GROUP BY s.d
ORDER BY s.d