US Equities IPO

GET https://api.devalgoseek.com/api/v1/data/us-equity-ref/eq-ipo#

The U.S. Equities IPO dataset provides comprehensive reference information on Initial Public Offering (IPO) events for equities listed on U.S. public exchanges, excluding securities traded on the OTC market. IPO records typically available several days prior to the first trading day. Key fields include ticker symbol, algoseek SecId, ISIN, and first trading date, enabling early identification and accurate tracking of newly listed securities. Additionally, the dataset supports IPO status tracking, allowing users to distinguish between completed IPOs, postponed offerings, and other listing outcomes. This makes the dataset suitable for monitoring new listings, conducting event-driven research, and maintaining accurate security master records.

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

Query Parameters#

sort Sort

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 Columns

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 Offset

Possible values: >= 0

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

Default value: 0

Example: 100

limit Limit

Possible values: >= 0 and <= 100000

Maximum number of records to return. Used to control response size and pagination. If not provided, a default limit is applied by the server.

Default value: 10000

Example: 100

response_format ResponseFormat

Possible values: [json, csv, csv_gzip]

The type of the data to return

Default value: json

Examples:

JSON
CSV Gzip

JSON format (default)

Example: json

Compressed CSV format

Example: csv_gzip

Responses#

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

application/json
text/csv
application/gzip

Schema
Example (auto)

Schema

data object[]required

Array [

CreatedDatedate

Trading date when the record was created

Example: 2009-01-08

ModifiedDatedate

Trading date when record was updated

Example: 2023-09-25

Revisioninteger

Version number

Example: 0

SecIdinteger

A unique identifier for a security

Example: 1281362

Tickerstring

Symbol name

Example: FFN

Namestring

Security name

Example: Friendfinder Networks Inc

USIdentifierstring

USIdentifiers for US securities

Example: 358453306

ISINstring

International Securities Identification Number

Example: US3584533067

FirstTradingDatedate

First trading Date

Example: 2011-05-11

ExchangeCodestring

Code for an exchange

Example: USNASD

Statusstring

Indicates the status of IPO

Example: HISTORY

]

pagination objectrequired

offsetinteger

The number of records skipped to fetch the current page

Default value: 0

limitintegerrequired

The maximum number of records in the current page

next_offsetinteger

The number of records to skip to fetch the next page

{
  "data": [
    {
      "CreatedDate": "2009-01-08",
      "ModifiedDate": "2023-09-25",
      "Revision": 0,
      "SecId": 1281362,
      "Ticker": "FFN",
      "Name": "Friendfinder Networks Inc",
      "USIdentifier": "358453306",
      "ISIN": "US3584533067",
      "FirstTradingDate": "2011-05-11",
      "ExchangeCode": "USNASD",
      "Status": "HISTORY"
    }
  ],
  "pagination": {
    "limit": 1000,
    "next_offset": 2000,
    "offset": 1000
  }
}

Schema
Example (auto)

Schema

stringbinary

"string"

Schema
Example (auto)

Schema

stringbinary

"string"

Validation Error

application/json

Schema
Example (auto)

Schema

detail object[]

Array [

loc object[]required

Array [

anyOf

string
integer

string

]

msgstringrequired

typestringrequired

inputInput

ctxobject

]

{
  "detail": [
    {
      "loc": [
        "string",
        0
      ],
      "msg": "string",
      "type": "string",
      "ctx": {}
    }
  ]
}

Authorization: X-API-KEY#

name: X-API-KEYtype: apiKeyin: header

HTTPCLIENT
RESTSHARP

var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Get, "https://api.devalgoseek.com/api/v1/data/us-equity-ref/eq-ipo");
request.Headers.Add("Accept", "application/json");
request.Headers.Add("X-API-KEY", "<X-API-KEY>");
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());

Response

Click the Send API Request button above and see the response here!

← Previous

US Equities Detailed Adjustment Factors

US Equities Basic Adjustment Factors