US Equities Lookup File

US Equities Lookup File
Production
·

Data Class

Equity

Data Type

Reference

Delivery Method

CSV, SQL

Vendor

algoseek

Region

US

Documentation

Open Link

The US Equities Lookup Files provides an efficient way to identify the corresponding algoseek SecId based on a ticker-date pair or a FIGI. Once the SecId is determined, it can be cross-referenced with other identifiers, including ISIN, using the US Equities Security Master File for enhanced data analysis.

At present, two versions of the Lookup Files are available: ticker_to_secid_lookup and figi_to_secid_lookup, allowing users to select the most suitable method for their needs.

Browse by tags:

Reference Data Identifiers FIGI Lookup Files SecId Ticker Mapping Cross Reference
Dataset Info
Dataset Name ID
eq_lookup_files
Algoseek Dataset ID
US1022
Data Format
Reference
Data Class
Equity
Data Type
Reference
Time Granularity
Event
Region
US
Universe
All stocks, ETFs/ETNs from US exchanges
Version
1.0
Update Frequency Options
End of day
 Introductory Demo Info
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.
 Historical Info
Data Size
891 KB / year
Update Size
891 KB
Update Frequency
1 Day
Start Date
2007-01-01
End Date
Ongoing

SQL (ArdaDB)

Easily connect to your data using SQL with a database connection. No complex setup, just instant access to your data - run queries, retrieve insights, and manage data effortlessly. Secure, fast, and built for developers, analysts, and teams who need reliable access without the hassle.
Delivery Info
Update Time
01:00 ET
Database Table
USEquityReferenceData.LookupBase
Database Schema
USEquityReferenceData
Object Type
Table
Primary Date Column
StartDate
Timestamp Column
--
Internal ID Column
SecId
Identifier Column
Ticker
Data Fields
Preview Data
# name data type description
1 SecId Integer A unique identifier for a security
2 Ticker String Symbol name
3 StartDate Date The start date
4 EndDate Date The end date

CSV (S3)

Easily connect to your data stored in S3 and access CSV files without hassle. Streamline data retrieval with fast, secure, and scalable access, whether for analytics, processing, or integration.
Delivery Info
S3 Bucket Name
us-equity-lookup
Update Time
01:00 ET
S3 Bucket Path
ticker_to_secid_lookup.csv
S3 Bucket Path Description
Two csv files with SecId mapped to ticker and FIGI
S3 Start Year
N/A
S3 End Year
N/A
S3 Bucket Size
891 KB / year
Sample Data File
A few sample records
Data Fields
Preview Data
# name data type description
1 Ticker String Ticker symbol
2 SecId Integer Unique ID per security
3 StartDate Date Start date for Ticker with this SecId
4 EndDate Date End date of ticker with this SecId. EndDate = 20991231 when the ticker is still being used