PermID Security Index

Snowflake table name : CYBERSYN.PERMID_SECURITY_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
PERMID_SECURITY_ID	PermID for the security.	VARCHAR	8590931896
PRIMARY_TICKER	The ticker for the primary trading venue of a security. If a security trades on multiple exchanges or has numerous tickers, an attempt is made to select the ticker from the home market.	VARCHAR	WFRSF
SECURITY_NAME	Name of the security.	VARCHAR	KEMET ORD SHS
ASSET_CLASS	Broad-based class of the asset, such as 'Ordinary Shares', 'Depositary Receipts', etc.	VARCHAR	Ordinary Shares
PRIMARY_EXCHANGE_CODE	The exchange code for the primary trading venue of a security.	VARCHAR	GER
PRIMARY_EXCHANGE_NAME	The exchange name for the primary trading venue of a security.	VARCHAR	XETRA
SECURITY_STATUS	Status of the security, i.e. 'Active' or 'Inactive'. An active security is a security that has active quotes and an inactive security has no active quotes. This status changes over time.	VARCHAR	Active
GLOBAL_TICKERS	An array of ticker symbols under which the security may be traded globally on all exchanges.	ARRAY	[ "VALGF", "VR2N" ]
EXCHANGE_CODE	An array of codes representing the exchanges where the security is traded. An empty array means that exchange information is not available.	ARRAY	[ "DEU", "PNK" ]
PERMID_QUOTE_ID	An array of PermIDs for the quotes for each exchange where the security is traded. An empty array means that quote information is not available.	ARRAY	[ "21634404231", "21641132737", "21656679967", "55837364...