Skip to main content

Data Dictionary

Company Characteristics Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_CHARACTERISTICS_PIT: Tracks history of the company_characteristics table with start and end timestamps to indicate row validity periods.

Company Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_INDEX_PIT: Tracks history of the company_index table with start and end timestamps to indicate row validity periods.

Company Security RelationshipsView Source Documentation

PUBLIC_DATA.COMPANY_SECURITY_RELATIONSHIPS: Map between companies and the securities (stocks, bonds, etc.) they issue, including security identifiers from common open sources, including OpenFIGI and PermID. Maps to Snowflake Public Data company index.

Company Security Relationships Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_SECURITY_RELATIONSHIPS_PIT: Tracks history of the company_security_relationships table with start and end timestamps to indicate row validity periods.

OpenFIGI Security IndexView Source Documentation

PUBLIC_DATA.OPENFIGI_SECURITY_INDEX: Security details for OpenFIGI Composite, Share Class, and FIGI IDs, including tickers, names, asset classes, types, subtypes, exchange codes, and related IDs.

OpenFIGI Security Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.OPENFIGI_SECURITY_INDEX_PIT: Tracks history of the openfigi_security_index table with start and end timestamps to indicate row validity periods.