ODCS v3.2.0Draft · 0.1.0licensed-dataequityreferenceusevent

US Equities Trading Halts

One row per trading-halt case for a US equity symbol on a processing date, built from the CTA and UTP SIP feeds, with halt and resume timestamps (exchange and SIP clocks), raw and normalized reason codes and end-of-day status. Used for halt-duration analysis, trading controls and compliance monitoring.

21 columns in delivery order · file or table name eq_trading_halts. Types are ODCS logical types; the format line shows how values are written.

Schema columns with type, key role and description
ColumnTypeKeyDescription
DatedateyyyymmddKey 1 · RequiredDate on which this record was processed; one file per Date, and ongoing halts from earlier days are repeated under later Dates.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

SecIdintegeri64algoseek unique security identifier; blank for test symbols (6 of 60 sample rows).

Missing values: May be empty, e.g. for test symbols · Source: vendor guide and sample

ASIDintegeri64algoseek unique security identifier (second form, 16 digits in sample, prefix 101); blank when SecId is blank.

Missing values: May be empty, e.g. for test symbols · Source: vendor guide and sample

SymbolstringKey 2 · RequiredTicker symbol; may include exchange test symbols (e.g. ZWZZT, ZVZZT) for completeness.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

OrigExchstringExchange where the halt originated, typically the primary listing venue (Nasdaq, NYSE American in sample).

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

Planstring · enum (2)SIP plan under which the halt was reported; decides which fields are populated.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

2 allowed values
CTA
Consolidated Tape Association SIP plan (NYSE, NYSE American and other CTA-listed securities)
UTP
UTP SIP plan (Nasdaq-listed securities)
EodStatusstring · enum (2)Trading status of the security at market close.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

2 allowed values
Halted
Still halted at the market close
Trading
Resumed by the close
HaltDatedateyyyymmddKey 3 · RequiredDate the present halt began; can be earlier than Date for multi-day halts.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

HaltTimeExchtimeHH:MM:SS.mmmuuunnnExchange-provided timestamp, nanosecond precision, when the halt was activated.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

HaltTimeSiptimeHH:MM:SS.mmmuuunnnSIP-provided timestamp when the halt message was disseminated.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

CtaLastPricePreHaltnumberLast price before the halt from CTA-plan exchanges; currency not stated (USD implied).

Missing values: Blank for UTP-plan securities (not available); otherwise unstated · Source: vendor guide and sample

ResumeDatedateyyyymmddDate on which trading resumed.

Missing values: Blank until the halt is lifted (halt may persist beyond the session) · Source: vendor guide and sample

UtpQuoteResumeTimeExchtimeHH:MM:SS.mmmuuunnnExchange-provided timestamp when quotation resumed, for UTP-plan securities.

Missing values: Blank for CTA plan and until quotes resume · Source: vendor guide and sample

UtpQuoteResumeTimeSiptimeHH:MM:SS.mmmuuunnnSIP-provided timestamp when quotation resumed, for UTP-plan securities.

Missing values: Blank for CTA plan and until quotes resume · Source: vendor guide and sample

TradeResumeTimeExchtimeHH:MM:SS.mmmuuunnnExchange-provided timestamp when the security resumed trading.

Missing values: Blank until the halt is lifted · Source: vendor guide and sample

TradeResumeTimeSiptimeHH:MM:SS.mmmuuunnnSIP-provided timestamp when the resumption message was disseminated.

Missing values: Blank until the halt is lifted · Source: vendor guide and sample

AsNormRsnCodestring · enum (16)one or more codes separated by semicolon (e.g. P;D)algoseek-normalized halt reason code(s), semicolon-separated when several reasons apply.

Missing values: Blank in 13 of 60 sample rows (UTP reason may be unavailable at halt start) · Source: vendor guide and sample

16 allowed values
<space>
Reason Not Available
A
Additional Information Requested
C
Regulatory Concern
D
News Released
F
ETF Component Prices Not Available
V
Volatility Pause
O
Security Offering
N
Corporation Action
P
News Pending
NQ
Quote Not Available
X
Operational
NC
Non Compliance
1
Market-Wide Circuit Breaker Level 1 - Breached
2
Market-Wide Circuit Breaker Level 2 - Breached
3
Market-Wide Circuit Breaker Level 3 - Breached
0
Market Wide Circuit Breaker Resumption
AsNormRsnstringone or more descriptions separated by semicolonalgoseek-normalized reason description(s), semicolon-separated.

Missing values: Blank when AsNormRsnCode is blank · Source: vendor guide and sample

ExchRsnCodestringone or more exchange codes separated by semicolon (e.g. T1;T3)Original exchange reason code(s) from CTA or UTP, semicolon-separated.

Missing values: Blank in 13 of 60 sample rows · Source: vendor guide and sample

HaltCaseSeqintegeri64Key 4 · RequiredSequence number of the halt case during a trading session (1..5 in sample); guide types it string, sample values are integers.

Missing values: unstated (always populated in sample) · Source: vendor guide and sample

TotalMessagesintegeri64Total number of messages for the halt (1-4 in sample).

Unit: count · Missing values: unstated (always populated in sample) · Source: vendor guide and sample

Contracts follow the Open Data Contract Standard (Bitol, LF AI & Data).

Vendor names are trademarks of their owners.