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 |