US Equities Lookup File
US Equities Lookup File
Production
·
The U.S. Equities Lookup Files dataset enables users to map a ticker and effective date or a FIGI to the corresponding SecId, supporting accurate identifier normalization across time, then SecId can be further linked to additional identifiers, such as ISIN, via the U.S. Equities Security Master, enabling consistent cross-dataset joins and security-level analysis. The dataset is delivered in two complementary lookup versions: • Ticker-to-SecId lookup, supporting date-aware symbol resolution • FIGI-to-SecId lookup, supporting cross-vendor identifier mapping
Dataset Info
SQL (ArdaDB)
CSV (S3)
Algoseek Dataset ID
US1022
Data Class
Equity
Dataset Name ID
eq_lookup_files
Data Format
Reference
Version
1.0
Time Granularity
Event
Region
US
Data Type
Reference
Universe
All stocks, ETFs/ETNs from US exchanges
Update Frequencies
End of day
Start Date
2007-01-01
End Date
Ongoing
Update Frequency
1 Day
Total Size
891 KB
Annual Size
891 KB / year
Update Size
891 KB
Start Date
01/01/2023
End Date
12/31/2023
Access Methods
SQL
Universe Identifiers
A, AAL, AAP + 500 more
Description
One year of data (2023) for SP500 index.
Included in Data Research Packages: