OpenFIGI

Overview

OpenFIGI IDs are unique identifiers for active and inactive securities across all global assets including equities, bonds, futures, and options. The Financial Instrument Global Identifier (i.e. FIGI) is an established global standard and used to facilitate easy mapping across data sources.

Coverage includes:

• Companies: >8K companies

• Asset classes: Ordinary shares, corporate bonds, municipal bonds, currency pairs, and more

Key Attributes

Geographic Coverage	Global
Entity Level	OpenFIGI
Release Frequency	Ad hoc

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

The OPENFIGI_SECURITY_INDEX table provides a list of over 2M securities and their associated TOP_LEVEL_OPENFIGI_ID and respective TOP_LEVEL_OPENFIGI_ID_TYPE. The TOP_LEVEL_OPENFIGI_ID is the OpenFIGI ID of the highest, most widely encompassing level for a particular security. The OpenFIGI hierarchy follows the order: "share class" (global) > "composite" (country-level) > "FIGI" (exchange-level). Other fields in the table detail the primary ticker, security name, asset class, security type, security subtypes, global tickers and exchange codes. Learn more and view documentation from OpenFIGI here.

The COMPANY_SECURITY_RELATIONSHIPS table maps 89K+ OpenFIGI and 15K+ PermID securities to the Company entity (Company_ID). The table can be joined across Cybersyn tables that include Company_ID.

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details

Tables & Sources

Tables Names	Source
OPENFIGI_SECURITY_INDEX	OpenFIGI
COMPANY_SECURITY_RELATIONSHIPS	PermID, OpenFIGI

Cybersyn Products

Tables above are available in the following Cybersyn data products:

• SEC Filings

• LLM Training Essentials

• Enterprise

Examples & Sample Queries

Aggregate company identifiers and metadata about companies

Search for commonly-used corporate identifiers such as CIK and EIN as well as stock-specific identifiers like ticker symbol and OpenFIGI ID.

SELECT
    idx.company_id,
    idx.company_name,
    idx.cik,
    idx.ein,
    idx.lei,
    openfigi.openfigi_share_class_id,
    openfigi.primary_ticker,
    idx.permid_company_id
FROM cybersyn.company_index AS idx
JOIN cybersyn.company_characteristics AS char
    ON (idx.company_id = char.company_id)
JOIN cybersyn.company_security_relationships AS rship
    ON (idx.company_id = rship.company_id)
JOIN cybersyn.openfigi_security_index AS openfigi
    ON ARRAY_CONTAINS(rship.security_id::VARIANT, openfigi.openfigi_share_class_id)
WHERE char.relationship_type = 'sic_description'
  AND char.value = 'Air transportation, scheduled';

Disclaimers

The data in this product is sourced from OpenFIGI.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.