ALalgoseek
us-equity-ref-sec-master-lookups

US Equities OTC Security Master

Changed on

The algoseek US Equity OTC Security Master provides comprehensive reference information on all Over-the-Counter (OTC) securities with complete historical tracking of attribute changes. The dataset tracks the complete history of security attributes, including symbols, names, identifiers (ISIN, FIGI, LEI), company information, and trading status. It enables tracking of symbol and name changes, identification of company information and relationships, cross-referencing securities using multiple identifiers, monitoring of trading status, and historical analysis with complete date ranges for all attribute changes. Daily updates run twice each trading day (~7 AM and ~10 PM) to capture changes to active securities. Coverage spans November 1, 2024, to present.

For more details, please refer to the dataset documentation: US Equities OTC Security Master 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>
get/v1/data/us-equity-ref/otc-sec-master

Request

Query parameters

sortstring 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.

columnsstring 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.

offsetinteger

Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.

limitinteger

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

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": [
    {
      "ASID": 1210000000001000,
      "OTCSecId": [
        15
      ],
      "OTCSecIdDateRange": [
        "20241101:29991231"
      ],
      "OTCCompId": [
        36930
      ],
      "OTCCompIdDateRange": [
        "20241101:29991231"
      ],
      "Ticker": [
        "ELUXY"
      ],
      "TickerDateRange": [
        "20241101:29991231"
      ],
      "SecurityName": [
        "AB ELECTROLUX B S/ADR"
      ],
      "SecurityNameDateRange": [
        "20241101:29991231"
      ],
      "CompanyName": [
        "AB Electrolux"
      ],
      "CompanyNameDateRange": [
        "20241101:29991231"
      ],
      "SecurityClass": [
        "B"
      ],
      "SecurityClassDateRange": [
        "20241101:29991231"
      ],
      "SecurityType": [
        "American Depository Receipts"
      ],
      "SecurityTypeDateRange": [
        "20241101:29991231"
      ],
      "SecurityStatus": [
        "A"
      ],
      "SecurityStatusDateRange": [
        "20241101:29991231"
      ],
      "ISIN": [
        "US0101982082"
      ],
      "ISINDateRange": [
        "20241101:29991231"
      ],
      "FIGI": [
        "BBG000BN8276"
      ],
      "FIGIDateRange": [
        "20241101:29991231"
      ],
      "ShareClassFIGI": [
        "BBG001SCG119"
      ],
      "ShareClassFIGIDateRange": [
        "20241101:29991231"
      ],
      "LEI": [
        "549300Y3HHZB1ZGFPJ93"
      ],
      "LEIDateRange": [
        "20241101:29991231"
      ]
    }
  ],
  "pagination": {
    "limit": 1000,
    "next_offset": 2000,
    "offset": 1000
  }
}

Changes