trading halts — 4 answered market questions

SPY-equivalent circuit breaker levels for the next session

most recentas of 2026-11-01 table 3×7read in context →

SPY-equivalent circuit breaker levels for the next session — 3 rows by 7 columns, computed 2026-11-01 from US exchange, SIP and OPRA data.
level	threshold	halt_rule	reference_close_label	spy_reference_close	spy_trigger_level	spy_points_to_trigger
Level 1	7% below the prior close	15-minute halt if crossed before 3:25 p.m. ET	October 30	755.72	702.82	52.9
Level 2	13% below the prior close	15-minute halt if crossed before 3:25 p.m. ET	October 30	755.72	657.48	98.24
Level 3	20% below the prior close	Halt for the rest of the day, at any time	October 30	755.72	604.58	151.14

the exact SQL behind every number

SELECT
    concat('Level ', toString(multiIf(lv.decline_pct = 7, 1, lv.decline_pct = 13, 2, 3))) AS level,
    concat(toString(lv.decline_pct), '% below the prior close')                           AS threshold,
    if(lv.decline_pct = 20,
       'Halt for the rest of the day, at any time',
       '15-minute halt if crossed before 3:25 p.m. ET')                                   AS halt_rule,
    concat(monthName(ref.d), ' ', toString(toDayOfMonth(ref.d)))                          AS reference_close_label,
    round(ref.c, 2)                                                                       AS spy_reference_close,
    round(ref.c * (100 - lv.decline_pct) / 100, 2)                                        AS spy_trigger_level,
    round(ref.c * lv.decline_pct / 100, 2)                                                AS spy_points_to_trigger
FROM
(
    SELECT arrayJoin([7, 13, 20]) AS decline_pct
) AS lv
CROSS JOIN
(
    SELECT
        date                     AS d,
        toFloat64(max(close))    AS c
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= today() - 14
    GROUP BY date
    ORDER BY date DESC
    LIMIT 1
) AS ref
ORDER BY lv.decline_pct

More from this analysisMarket-Wide Circuit Breakers Explained

March 2020 session by session: open, low and close versus the prior close series 22×6 → How the three lines move with each SPY close series 15×5 → The four Level 1 halt sessions of March 2020 series 4×8 → Average minute range through the session, five liquid names series 26×3 → See all 3,293 queries →