1c983de099e2
US Equities IPO Detailed
The U.S. Equities IPO (Detailed) 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. Like the basic IPO dataset, records are typically available several days prior to the first trading day, enabling early identification and monitoring of upcoming offerings. Core fields include ticker symbol, algoseek SecId, ISIN, first trading date, and IPO status indicators that track outcomes such as completed, postponed, or otherwise modified offerings. In addition to these core attributes, the detailed dataset includes expanded offering-level metadata, such as par value, initial offering price, and underwriter information. This enhanced field coverage supports deeper analysis of IPO structure, pricing context, and issuance characteristics, and is well suited for research, security master enrichment, and historical event analysis.
For more details, please refer to the dataset documentation: US Equities IPO Detailed 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": [
{
"CreatedDate": "2009-01-08",
"ModifiedDate": "2023-09-25",
"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
}
}