US Equities IPO
US Equities IPO
Production
·
The US Equities IPO provides information on Initial Public Offering (IPO) events for the whole US market, excluding Over-the-Counter. Usually, IPO data is available a few days before the event itself providing access to such fields as ticker, SecId, first trading day, ISIN, etc. Also, the dataset offers a possibility for tracking IPO status: new IPO that happened recently, IPO that was postponed for some reason, etc.
Dataset Info
Dataset Name ID
eq_ipo
Algoseek Dataset ID
US1020
Data Format
Reference
Data Class
Equity
Data Type
Reference
Time Granularity
Event
Region
US
Universe
All stocks, ETFs/ETNs from US exchanges
Version
1.0
Update Frequency Options
Intraday
Start Date
01/01/2023
End Date
12/31/2023
Access Methods
SQL
Description
One year of data (2023) for the full universe of symbols
Data Size
1.6 MB / year
Update Size
600 bytes
Update Frequency
6 Hour
Start Date
2020-01-01
End Date
Ongoing
SQL (ArdaDB)
Easily connect to your data using SQL with a database connection. No complex setup, just instant access to your data - run queries, retrieve insights, and manage data effortlessly. Secure, fast, and built for developers, analysts, and teams who need reliable access without the hassle.
USEquityReferenceData.IPOBasic
Update Time
06:00 ET
Database Table
USEquityReferenceData.IPOBasic
Database Schema
USEquityReferenceData
Object Type
Table
Primary Date Column
CreatedDate
Timestamp Column
--
Internal ID Column
SecId
Identifier Column
Ticker
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | CreatedDate | Date | Trading date when the record was created |
| 2 | ModifiedDate | Date | Trading date when record was updated |
| 3 | Revision | Integer | Version number |
| 4 | SecId | Integer | A unique identifier for a security |
| 5 | Ticker | String | Symbol name |
| 6 | Name | String | Security name |
| 7 | USIdentifier | String | USIdentifiers for US securities |
| 8 | ISIN | String | International Securities Identification Number |
| 9 | FirstTradingDate | Date | First trading Date |
| 10 | ExchangeCode | String | Code for an exchange |
| 11 | Status | String | Indicates the status of IPO |
CSV (S3)
Easily connect to your data stored in S3 and access CSV files without hassle. Streamline data retrieval with fast, secure, and scalable access, whether for analytics, processing, or integration.
us-equity-ipo-basic
S3 Bucket Name
us-equity-ipo-basic
Update Time
06:00 ET
S3 Bucket Path
ipo_basic.csv.gz
S3 Bucket Path Description
One csv file with initial public offering list
S3 Start Year
N/A
S3 End Year
N/A
S3 Bucket Size
157 KB / year
Sample Data File
Data Fields
Preview Data
| # | name | data type | description |
|---|---|---|---|
| 1 | CreatedDate | String | Trading date when the record was created |
| 2 | ModifiedDate | String | Trading date and version number (_n suffix) when record was updated |
| 3 | SecId | Integer | algoseek unique security identifier |
| 4 | Ticker | String | Symbol name |
| 5 | Name | String | Security name |
| 6 | USIdentifier | String | USIdentifiers for US securities |
| 7 | ISIN | String | ISIN code |
| 8 | FirstTradingDate | String | First trading Date |
| 9 | ExchangeCode | String | Code for an exchange |
| 10 | Status | String | Indicates the status of IPO |