Corporate actions | Databento schemas & data formats

Corporate actions

Corporate actions includes coverage from 215+ exchanges worldwide, 300,000+ listed and delisted securities from 100,000+ companies, categorized as 60+ event types. The dataset focuses on crucial events affecting global securities such as dividends, takeovers, mergers & acquisitions and rights issues.

See also

Reference data enums for a lookup table of possible enumeration field values.

Fields

Timestamps are strings in ISO 8601 format, expressed in UTC

Dates are strings in YYYY-MM-DD ISO 8601 format, expressed in the local time of the listing exchange

Enums are strings, with each value corresponding to a predefined set of options listed in the associated lookup table

Field	Type	Description
`ts_record`	Timestamp	The timestamp (UTC) the record last changed.
`event_unique_id`	String	Unique corporate actions record identifier. Can be used to deduplicate records for the same event.
`event_id`	String	Event identifier unique at the event level.
`listing_id`	String	Unique listing numerical ID. Concatenation of a sequence number and the `listing_group_id`. The sequence number will usually be 1 unless additional listings exists for the same security in the same market, usually as a result of secondary trading currencies.
`listing_group_id`	String	Groups all listings for the same security on a specific exchange, often in different trading currencies.
`security_id`	String	Security level numerical ID. Can be used to link all multiple listings together.
`issuer_id`	String	Issuer level numerical ID. Can be used to link all securities of a company together.
`event_action`	Enum	Record action status code. See ACTION enum.
`event`	Enum	Event type. The `event_id` where applicable links all payments rows of an event together to show all the payment options. Can be used as a short event name. See EVENT enum.
`event_subtype`	Enum or null	Event subtype. This is only used for a limited number of events where the event data supplied falls into distinct sub-groupings. See EVENTSUBTYPE enum.
`event_date_label`	String	The main calendar date name for the event.
`event_date`	Date	The primary date associated with the event, often marking when the event is scheduled to occur or take effect.
`event_created_date`	Date	The date on which the event was officially created or recorded in the system.
`ex_date`	Date or null	The ex-dividend date (ex-date), marking the first date on which the security trades without the entitlement to the upcoming dividend, distribution, or other corporate action benefit. Where the `payment_type` of a multiple payment event is flagged as a (B)oth, this ex-date field will contain the ex-date of the cash component. The `ex_date2` field in the `event_info` section will carry the stock component ex-date.
`effective_date`	Date or null	The date on which the event becomes effective or is executed, signifying when the changes or actions are officially recognized.
`record_date`	Date or null	The date on which a company reviews its records to determine the eligible shareholders entitled to receive dividends or participate in the event. The record date is one business day after the ex-date.
`record_date_id`	Date or null	Record date ID. This ID links all events for the same security that share the same record date.
`related_event`	Enum or null	Related event type. See EVENT enum.
`related_event_id`	Date or null	Direct link to another event.
`global_status`	Enum	Global status code. Indicates the global listing activity status of a security. See GLOBSTATUS enum.
`listing_status`	Enum	Listing status code. Indicates the listing activity status at market level. See LISTSTAT enum.
`listing_source`	Enum	Indicates if the listing level data in the record is (M)ain or (S)econdary. See LISTSOURCE enum.
`listing_date`	Date or null	The date when the security is officially listed on the exchange and becomes available for trading.
`delisting_date`	Date or null	The date when the security is officially removed from the exchange and ceases to be traded.
`issuer_name`	String	The issuer name.
`security_type`	Enum	The security type. See SECTYPE enum.
`security_description`	String	The security description.
`primary_exchange`	Enum or null	Exchange code for the primary security. Empty if unknown. See EXCHANGE enum.
`exchange`	Enum	Exchange code for the listing. Equivalent to the MIC but more stable as MIC might not be available in a timely fashion. Also note that the MIC can change but the `exchange` will remain the same. See EXCHANGE enum.
`operating_mic`	Enum or null	Market Identifier Code (MIC) as an ISO 10383 string. See EXCHANGE enum.
`symbol`	String or null	The query input symbol which matched the record.
`nasdaq_symbol`	String or null	Nasdaq Integrated Platform Suffix convention symbol.
`local_code`	String or null	Local code. Usually unique at market level but there are exceptions to this rule. Either an alpha string, or a number.
`isin`	String or null	ISIN global level identifier as an ISO 6166 string.
`us_code`	String or null	US domestic CUSIP.
`bbg_comp_id`	String or null	Bloomberg composite global ID.
`bbg_comp_ticker`	String or null	Bloomberg composite ticker.
`figi`	String or null	Bloomberg FIGI, that is exchange level ID.
`figi_ticker`	String or null	Bloomberg exchange level ticker.
`listing_country`	Enum or null	Listing country as two letter ISO 3166-1 alpha-2 string. See CNTRY enum.
`register_country`	Enum or null	Register country as two letter ISO 3166-1 alpha-2 string. See CNTRY enum.
`trading_currency`	Enum or null	Trading currency as an ISO 4217 string. See CUREN enum.
`multi_currency`	Boolean	True if there is currently more than one listing in the market, otherwise false.
`segment_mic_name`	String or null	Market Segment Name. Used when no Segment MIC is available (Not the ISO 10383 MICSEG lookup name).
`segment_mic`	Enum or null	Market Identifier Code (MIC) as an ISO 10383 string. See MICSEG enum.
`mand_volu_flag`	Enum	Indicates mandatory and/or voluntary event participation requirement. With a few event types the flag change in the course of the corporate action lifecycle. See MANDVOLU enum.
`rd_priority`	Number or null	The priority order number sequence where populated is necessary to correctly calculate resultant cash and stock outcomes.
`lot_size`	Number or null	Lot Size. Indicates the minimum number of shares that can be acquired in one transaction.
`par_value`	Number or null	Par value amount.
`par_value_currency`	Enum or null	Par value currency as an ISO 4217 string. See CUREN enum.
`payment_date`	Date or null	The date on which the dividend or payment is made to eligible shareholders. Where the `payment_type` of a multiple payment event is flagged as a (B)oth, this payment date field will contain the payment date of the cash component.
`duebills_redemption_date`	Date or null	Due bills redemption date.
`from_date`	Date or null	The earliest date from which a specific corporate action or event is valid, active, or can be exercised. This date marks the beginning of the relevant event or process, such as when shareholders can start participating in a buyback, conversion, or rights issue. Applicable to a wide range of events.
`to_date`	Date or null	The final date by which the specific corporate action or event is valid, active, or must be completed. This date marks the conclusion of the relevant event or process, after which the associated rights, entitlements, or obligations may expire. Applicable to a wide range of events.
`registration_date`	Date or null	Registration date.
`start_date`	Date or null	The date on which the specific corporate action or event begins or becomes effective. This marks the commencement of the event's active period, such as the start of a buyback program, the beginning of a class action period, or the initiation of an odd-lot offer. Applicable to events like Class Actions (`CLSAC`), Certificate of Exchange (`CTX`), Buyback (`BB`), Odd-Lot Offer (`ODDLT`), and Financial Transaction Tax (`FTT`).
`end_date`	Date or null	The final date by which the corporate action or event is valid, active, or must be completed. This marks the conclusion of the event's active period, such as the end of a buyback program, the closing of a class action period, or the deadline for participating in an odd-lot offer. Applicable to events like Class Actions (`CLSAC`), Certificate of Exchange (`CTX`), Buyback (`BB`), Odd-Lot Offer (`ODDLT`), and Financial Transaction Tax (`FTT`).
`open_date`	Date or null	The date when the corporate action or event opens for participation or becomes available to stakeholders. This marks the beginning of the active period during which actions like tender offers, purchase offers, or redemptions can be initiated. Applicable to events like Takeovers (`TKOVR`), Purchase Offers (`PO`), and Redemptions (`REDEM`).
`close_date`	Date or null	The final date by which participation in the corporate action or event must be completed. This marks the end of the active period for actions like tender offers, purchase offers, or redemptions. Applicable to events like Takeovers (`TKOVR`), Purchase Offers (`PO`), and Redemptions (`REDEM`).
`start_subscription_date`	Date or null	The date when the subscription period for the event begins.
`end_subscription_date`	Date or null	The date when the subscription period for the event ends.
`option_election_date`	Date or null	The deadline by which participants must choose or elect an option related to the event.
`withdrawal_rights_from_date`	Date or null	The date from which withdrawal rights become effective, allowing participants to retract their election or participation.
`withdrawal_rights_to_date`	Date or null	The final date by which participants can exercise their withdrawal rights, retracting their election or participation.
`notification_date`	Date or null	The date on which the event notification is issued or made public.
`financial_year_end_date`	Date or null	The closing date of the company's financial year.
`exp_completion_date`	Date or null	The anticipated date when the event or related transaction is expected to be completed.
`payment_type`	Enum or null	Payment type. See PAYTYPE enum.
`option_id`	String or null	Option number of the event where applicable - options are ORs.
`serial_id`	String or null	Serial number of the event where applicable - serials are ANDs.
`default_option_flag`	Boolean or null	Flag indicating the benefit the shareholder would receive by default in case of several options being offered to them. The default is not always announced.
`rate_currency`	Enum or null	Payment currency as an ISO 4217 string. See CUREN enum.
`ratio_old`	Number or null	Ratio Denominator is the existing holding.
`ratio_new`	Number or null	Ratio Numerator is the new holding (for `FSPLT`, `DIV` and `BON` events includes the existing holding).
`fraction`	Enum or null	Describes how fractions are handled in settlement calculations. See FRACTIONS enum.
`outturn_style`	Enum or null	Style of outturn security. See OUTTURNSTYLE enum.
`outturn_security_type`	Enum or null	Security asset type. See SECTYPE enum.
`outturn_security_id`	String or null	Outturn security.
`outturn_isin`	String or null	Outturn ISIN.
`outturn_us_code`	String or null	Outturn CUSIP.
`outturn_local_code`	String or null	Outturn local code.
`outturn_bbg_comp_id`	String or null	Outturn Bloomberg composite ID.
`outturn_bbg_comp_ticker`	String or null	Outturn Bloomberg composite ticker.
`outturn_figi`	String or null	Outturn FIGI - Bloomberg exchange level ID.
`outturn_figi_ticker`	String or null	Outturn FIGI Ticker - Bloomberg exchange level ticker.
`min_offer_qty`	Number or null	The quantity range within which the shareholder can offer from their total holding in the event.
`max_offer_qty`	Number or null	The quantity range within which the shareholder can offer from their total holding in the event.
`min_qualify_qty`	Number or null	If the quantity held by shareholder is within this range then they qualify for taking part in the event.
`max_qualify_qty`	Number or null	If the quantity held by shareholder is within this range then they qualify for taking part in the event.
`min_accept_qty`	Number or null	The total quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror.
`max_accept_qty`	Number or null	The total quantity the company will accept from all the shareholders tendering their shares in the event for the event to be binding on the offeror.
`tender_strike_price`	Number or null	If the event is via a tender process it is the cut off price at which all the bids are accepted.
`tender_price_step`	Number or null	If the event is via a tender then there is a price step in which one can put in the bids. E.g. If the price step specified is 10p then one has to make bids in steps of 10p i.e. GBP 1.10, GBP 1.20, GBP 1.30.
`option_expiry_time`	String or null	Option expiry time.
`option_expiry_tz`	String or null	Option expiry time zone.
`withdrawal_rights_flag`	Boolean or null	Withdrawal rights flag.
`withdrawal_rights_expiry_time`	String or null	Withdrawal rights expiry time.
`withdrawal_rights_expiry_tz`	String or null	Withdrawal rights expiry time zone.
`expiry_time`	String or null	Expiry time.
`expiry_tz`	String or null	Expiry time zone.
`date_info`	JSON	Event specific date information.
`rate_info`	JSON	Event specific payment rate information.
`event_info`	JSON	Additional event specific information.
`ts_created`	Timestamp	The timestamp (UTC) the record was added by Databento.

Identifiers

Identifiers for listing, security and issuer are grouped at the beginning of each record, which enables clearer comparisons of where a single security is associated with many individual listings across different exchanges. There is one primary_exchange for a security, and it may then be listed on multiple secondary exchanges.

Dynamic fields

The following dynamically-sized fields provide additional supplementary information as key-value pairs:

date_info. Date specific information related to the event

rate_info. Rate specific information related to the event

event_info. Additional supplementary event information

Info

The content of these dynamic fields is contingent on the type of event and its event_subtype, allowing for flexible and detailed data representation.