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

# US Equities Security Master File

`GET /v1/data/us-equity-ref/sec-master`

The U.S. Equities Security Master dataset provides a comprehensive, centralized reference record for all listed and delisted U.S. equity securities from 2007 to the present. It serves as the authoritative foundation for security identification, classification, and lifecycle tracking across the U.S. equities universe. The dataset includes core descriptive attributes such as industry and sector classification, listing status, and security name and ticker history, enabling accurate tracking of securities through name and symbol changes. Each record is organized around algoseek’s Security ID (SecId), a stable internal identifier that remains unchanged across name and ticker updates. In addition, the Security Master provides cross-references to major industry identifiers, including FIGI and ISIN, supporting interoperability with third-party datasets and internal systems. The dataset is delivered as a single consolidated table and is updated daily to reflect new listings, delistings, and reference-data changes. Complementary Lookup Files are available to resolve tickers and other identifiers to SecId.

 For more details, please refer to the dataset documentation: [US Equities Security Master 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

- USEquitiesSecurityMasterFileDataOut
  - `data` USEquitiesSecurityMasterFileDataDetailsOut[], required
    - `SecId` integer, nullable — A unique identifier for a security
    - `ASID` integer, nullable — A unique identifier for a security
    - `ListStatus` string, nullable — Current list status (D = Delisted. L = Listed)
    - `SecurityDescription` string, nullable — Current type of security
    - `Sic` integer, nullable — Current Standard Industrial Classification code
    - `Sector` string, nullable — Current SIC Sector
    - `Industry` string, nullable — Current SIC Industry
    - `SEDOL` string, nullable — Current Stock Exchange Daily Official List
    - `Ticker` string[], nullable — List of symbol names used
    - `TickerStartToEndDate` string[], nullable — Start and end dates for each ticker
    - `Name` string[], nullable — List of security names used
    - `NameStartToEndDate` string[], nullable — Start and end dates for each name
    - `ISIN` string[], nullable — List of ISIN codes used
    - `ISINStartToEndDate` string[], nullable — Start and end dates for each ISIN
    - `USIdentifier` string[], nullable — List of USIdentifiers for US securities used
    - `USIdentifierStartToEndDate` string[], nullable — Start and end dates for each USIdentifier
    - `PrimaryExchange` string[], nullable — List of Primary Exchanges used
    - `PrimaryExchangeStartToEndDate` string[], nullable — Start and end dates for each Primary Exchange
    - `FIGI` string[], nullable — List of Financial Instrument Global Identifier codes used
  - `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)