---
title: "US Equities Lookup File"
method: GET
path: "/v1/data/us-equity-ref/lookup-files"
tags: ["us-equity-ref-sec-master-lookups"]
---

# US Equities Lookup File

`GET /v1/data/us-equity-ref/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](https://us-equity-reference-docs.s3.us-east-1.amazonaws.com/algoseek.US.Equity.Security.Master.File.pdf).

<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

- `sort` string, nullable — 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.
- `columns` string, nullable — 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.
- `offset` integer — Number of records to skip before returning results. To be used with the `limit` parameter for pagination. If not provided, defaults to 0.
- `limit` integer — Maximum number of records to return. Default and maximum values depend on the response format; see `format_limits` in the schema for details.
- `response_format` 'json' | 'csv' | 'csv_gzip' — Note the lowercase which is used for the consistency with other projects and tools

## Response `200`

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

- USEquitiesLookupFileDataOut
  - `data` USEquitiesLookupFileDataDetailsOut[], required
    - `SecId` integer, nullable — A unique identifier for a security
    - `Ticker` string, nullable — Symbol name
    - `StartDate` string, date, nullable — The start date
    - `EndDate` string, date, nullable — The end date
  - `pagination` PaginationDetailsOut, required
    - `offset` integer — The number of records skipped to fetch the current page
    - `limit` integer, required — The maximum number of records in the current page
    - `next_offset` integer, nullable — The number of records to skip to fetch the next page

## Other responses

- `403` — Forbidden
- `422` — Validation Error
- `429` — Request rejected because the identity or team exceeded a configured monthly or per-minute usage quota. When available, the response includes rate-limit headers describing the current quota.

---

[API](https://skmtc.net/algoseek/apis/datasets-api.md) · [All operations](https://skmtc.net/algoseek/apis/datasets-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/algoseek/datasets-api/revisions/1c983de099e2/schema)