1c983de099e2
US Equities Lookup File
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.
<details> <summary>**Advanced Filtering**</summary>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 <a href="https://algoseek.com/docs/rest-api/tutorial/advanced-filtering">Advanced Filtering Guide</a> for the extensive reference.
</details>Query parameters
Sorting criteria for the results. Provide a column name with optional prefix '+' for ascending order, or prefix with '-' for descending order. Multiple sorting fields may be supported depending on the dataset. If sort prefix is not provided, the ascending order is applied.
Sorting criteria for the results. Provide a column name with optional prefix '+' for ascending order, or prefix with '-' for descending order. Multiple sorting fields may be supported depending on the dataset. If sort prefix is not provided, the ascending order is applied.
A comma-separated list of columns to include in the response. Use this parameter to select only specific fields from the dataset. If not provided, all available columns will be returned.
A comma-separated list of columns to include in the response. Use this parameter to select only specific fields from the dataset. If not provided, all available columns will be returned.
Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.
Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.
Maximum number of records to return. Default and maximum values depend on the response format; see format_limits in the schema for details.
Maximum number of records to return. Default and maximum values depend on the response format; see format_limits in the schema for details.
Note the lowercase which is used for the consistency with other projects and tools
The type of the data to return
Response
JSON, CSV file, or gzip-compressed CSV file, depending on the value of response_format query parameter
Example response
{
"data": [
{
"SecId": 2234,
"Ticker": "SLF",
"StartDate": "2007-01-03",
"EndDate": "2099-12-31"
}
],
"pagination": {
"limit": 1000,
"next_offset": 2000,
"offset": 1000
}
}