PermID Security Index

Snowflake table name : CYBERSYN.PERMID_SECURITY_INDEX

View data source documentation here.

Name	Description	Type	Example
PERMID_SECURITY_ID	PermID for the security.	VARCHAR	8590017491
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	MIPIQ
SECURITY_NAME	Name of the security.	VARCHAR	SPROTT PHYSICAL GOLD AND SILVER TRUST USD
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	BCO
PRIMARY_EXCHANGE_NAME	The exchange name for the primary trading venue of a security.	VARCHAR	PNK OTC MARKETS INC
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	Inactive
GLOBAL_TICKERS	An array of ticker symbols under which the security may be traded globally on all exchanges.	ARRAY	[ "MIPIQ", "YJ1" ]
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	[ "21772232241", "21772651836", "21772653309", "25727311...