Corporate action dataste containing events carried out by a publically traded company that materially impacts its stakeholders, such as shareholders or creditors. A corporate action may affect the securities issued by the company, such as equity or debt, and may require approval by the board of directors and/or the shareholders. Some examples of corporate actions are stock splits, dividends, mergers and acquisitions, rights issues, and spin-offs. Corporate actions can be either mandatory or voluntary. Mandatory corporate actions are automatically applied to the securities involved, while voluntary corporate actions require a response from the shareholders to participate.
| 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. |
| symbol | string | Trading Symbol or Ticker |
| splitid | int | Split Identifier |
| exdate | string | Ex Date |
| paydate | string | Pay Date |
| recorddate | string | record date |
| announceddate | string | The announcement date of an event. In securitities this could be an announcement of a dividend, a stock split, a merger, etc. |
| rate | double | rate |
| tradingitemid | int | CIQ Trading Item Identifier |
| appliedflag | int | Applied Flag or Indicator |
| securityid | int | Security Identification Code for the data source vendor |
| primaryflag | int | primary flag |
| tradingitemstatusid | int | Trading item status code. 15 = Active, 11 = Inactive |
| iso_currency_code | string | ISO Currency Code |
| exchangename | string | Exchange or Market place name |
| exchangesymbol | string | Exchange or Market place short names. This includes values like ´OTCPK´, ´NasdaqGS´, ´NasdaqCM´, ´NYSE´, ´NasdaqGM´, ´ARCA´, ´NYSEAM´ |
| splittypename | string | Split Type Name: Common values are Stock dividend, Consolidation, Stock split, Subdivision |
| splittypeid | int | Split Type ID: 11 = Stock Dividend, 12 = Stock Split, 33 = Subdivision, 34 = Consolidation. See splittypename for the decode value of this column. |
| securityname | string | Security Name |
| companyname | string | The Company’s Name. May be formal/legal name or some derivative of the company‘s name. |