Skip to main content

US Equities Lookup File

GET 

/api/v1/data/us-equity-ref/eq-lookup-files

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

For more details, please refer to the dataset documentation: US Equities Lookup File Guide.

Advanced Filtering

You can provide one or multiple filter expressions based on the dataset's columns to narrow down the results. For example, StartDate.gt=2023-01-01&StartDate.lt=2023-12-31, Ticker=AAPL.

Please refer to the Advanced Filtering Guide for the extensive reference.

Request

Responses

JSON, CSV file, or gzip-compressed CSV file, depending on the value of response_format query parameter