
Dataset Name: ice_cas_merger_acquisition
Group: market_data
Vendor: ICE
Data Update Frequency: day
ICE CAS Merger Acquisition
Historical record of one company seeking to acquire another, or two or more companies undertaking a merger. In all cases, the instrument_id component of the primary key for the event is the target firm’s securities (and not the acquiring firm or firms)Data Contained in this Dataset
Column | Type | Description |
---|---|---|
_seq | uint | Internal sequence number used to keep data rows in order |
timestamp | string | Timestamp of the Data - America/New York Time. |
muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. (underlying field is nc_publish_date_actual) |
symbol | string | Trading Symbol or Ticker |
cusip | string | Committee on Uniform Security Identification Procedures identifier owned by American Bankers Association operated by Standard and Poor's, requires CUSIP license. |
isin | string | International Securities Identification Number. An international code which identifies a securities issue |
instrument_name | string | The Instrument Name |
action_type | string | action_type |
entry_date | string | entry_date |
event_status | string | Event Status |
event_description | string | Event Description |
event_comments | string | Event Comments |
market_code | string | Market Code |
market_effective_date | string | market_effective_date |
ma_type | string | ma_type |
ma_subtype | string | ma_subtype |
offering_company | string | offering_company |
offer_cash_amount | double | offer_cash_amount |
offer_cash_currency | string | offer_cash_currency |
merger_acquisition | string | merger_acquisition |
data | string | Full body of the news article, contains all the data in JSONB |