OpenFIGI Security Index
Snowflake table name : CYBERSYN.OPENFIGI_SECURITY_INDEX
Last updated
Snowflake table name : CYBERSYN.OPENFIGI_SECURITY_INDEX
Last updated
Copyright © 2024 Cybersyn
Name | Description | Type | Example |
---|---|---|---|
TOP_LEVEL_OPENFIGI_ID
OpenFIGI ID of the highest, most widely encompassing level for a particular security. The hierarchy follows the order "share class FIGI" (global) > "composite FIGI" (country-level) > "FIGI" (exchange-level).
VARCHAR
BBG00830PK15
TOP_LEVEL_OPENFIGI_ID_TYPE
The highest level of the OpenFIGI ID in the hierarchy for the security held. The hierarchy follows the order "share class FIGI" (global) > "composite FIGI" (country-level) > "FIGI" (exchange-level). For example, if the highest level of ID (recorded in TOP_LEVEL_OPENFIGI_ID) is the composite FIGI, then this will be equal to 'openfigi_composite_id'.
VARCHAR
openfigi_share_class_id
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
ISNFX
SECURITY_NAME
Name of the security.
VARCHAR
VOYA SOLUTION 2040 PORT-ADV
ASSET_CLASS
Broad-based class of the asset, such as 'Equity', 'Muni', etc.
VARCHAR
Equity
SECURITY_TYPE
The type of security, such as "Common Stock" for equities. Securities can fall into multiple categories such as when a company has both tradable shares of Common Stock and an ADR.
ARRAY
[ "Open-End Fund" ]
SECURITY_SUBTYPE
Sub-type of the security, providing further classification. Like SECURITY_TYPE, securities can also have multiple subtypes.
ARRAY
[ "Mutual Fund" ]
GLOBAL_TICKERS
An array of ticker symbols under which the security may be traded globally on all exchanges.
ARRAY
[ "GENT" ]
OPENFIGI_FIGI_ID
Array of the FIGI (Financial Instrument Global Identifier) ID(s) for the security. In cases where there is a share class FIGI (global ID) or composite FIGI (country-level ID) because a security trades across multiple countries or exchanges, there may be multiple FIGI IDs associated with a single security.
ARRAY
[ "BBG00830PK06" ]
OPENFIGI_COMPOSITE_ID
Array of the country-level composite FIGI ID(s) for the security. In cases where there is a share class FIGI (global ID) and the security is tradable in more than one country there may be multiple composite IDs associated with a single security.
ARRAY
[ "BBG01MVT3DC7" ]
OPENFIGI_SHARE_CLASS_ID
The global share class FIGI ID(s) for the security. This is meant to be the most broad classification in the FIGI classification hierarchy.
ARRAY
[ "BBG012C7JTN6" ]
EXCHANGE_CODES
Codes representing the exchanges where the security is traded. An empty array means that exchange information is not available.
ARRAY
[ "US" ]