ODCS v3.2.0Draft · 0.1.0licensed-dataequityreferenceusevent

US Equities Announcements

One row per announced ticker change or delisting of a US exchange-listed equity, with announcement date, effective date, old/new tickers or delisting exchange. Used to anticipate and replay symbol changes and delistings.

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

Schema columns with type, key role and description
ColumnTypeKeyDescription
AnnounceDatedateyyyymmddKey 1 · RequiredDate on which the event was announced.

Missing values: Never · Source: vendor guide and sample

EffectiveDatedateyyyymmddInitial effective date published in the first announcement; blank when the date is not yet set. Not updated if the date later moves.

Missing values: Blank · Source: vendor guide and sample

SecIdintegeri64Key 2 · Requiredalgoseek unique security identifier.

Missing values: Never · Source: vendor guide and sample

TickerstringSymbol name; for TickerChange rows in the sample it equals OldTicker (the pre-change symbol).

Missing values: Never · Source: vendor guide and sample

EventTypestring · enum (2)Key 3 · RequiredType of announced listing event.

Missing values: Never · Source: vendor guide and sample

2 allowed values
Delisting
Symbol is delisted from a public exchange
TickerChange
Symbol name is changed to a new symbol
OldTickerstringSymbol before the change; populated for TickerChange only.

Missing values: Blank · Source: vendor guide and sample

NewTickerstringSymbol after the change; populated for TickerChange only.

Missing values: Blank · Source: vendor guide and sample

DelistingExchangestringExchange the symbol is delisted from; populated for Delisting only (NASDAQ, NYSE, AMEX in sample).

Missing values: Blank · Source: vendor guide and sample

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

Vendor names are trademarks of their owners.