Baselight
Sign In

Company IPOs Over Time

Predicting Future Success of Investing

@kaggle.thedevastator_dataset_on_ipo_from_2010_2018

Loading...
Loading...

About this Dataset

Company IPOs Over Time

Dataset on IPO from 2010-2018

Predicting Future Success of Investing

By [source]

About this dataset

import pandas as pd
from IPython.display import display
pd.options.display.max_columns = None
ipo_data_2010_2018 = pd.read_csv(datasets/IPO Stock - 2010-2018.csv)
ipo_data_2010_2018

This dataset contains information on IPOs from 2010 to 2018, including company name, symbol, market, price, shares, offer amount, date priced, employees, address, US state, descriptions, link to Nasdaq yearfirst day adjusted closefirst day openfirst day spreadfirst day volumein month adjusted closein month openin month spreadin month volumein week adjusted close in week open in week spread in week volume sectorindustryemployees as of 2019CEO payCEO birth year and inyear adjusted close and inyear open for each company that went public during that time period

More Datasets

For more datasets, click here.

Featured Notebooks

  • 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset was collected from Kaggle and it contains data on IPOs from 2010 to 2018. The data includes information on the company, the offering, the date of the offering, the Employees, the address, US state, sector and industry. This dataset can be used to study trends in IPOs, to examine how different factors affect IPO success and to predict future IPO success

Research Ideas

  • Identifying potential investment opportunities in new companies that are about to go public
  • Determining which industries may be ripe for investment in the near future based on recent IPO activity
  • analyzing historical data to predict how a company's stock may perform following its IPO

Acknowledgements

If you use this dataset in your research, please credit the original authors.

Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: ipo_clean_2010_2018.csv

Column name Description
Company Name The name of the company. (String)
Symbol The stock ticker symbol for the company. (String)
Market The market the company is listed on. (String)
Price The price of the stock at the time of the IPO. (Float)
Shares The number of shares offered in the IPO. (Integer)
Offer Amount The total amount of the IPO. (Float)
Date Priced The date of the IPO. (Date)
Employees The number of employees at the company. (Integer)
Address The address of the company. (String)
US_state The US state the company is located in. (String)
Year The year of the IPO. (Integer)
descriptions A description of the company. (String)
link_nasdaq A link to the company's Nasdaq profile. (String)

File: ipo_stock_2010_2018.csv

Column name Description
Company Name The name of the company. (String)
Symbol The stock ticker symbol for the company. (String)
Market The market the company is listed on. (String)
Price The price of the stock at the time of the IPO. (Float)
Shares The number of shares offered in the IPO. (Integer)
Offer Amount The total amount of the IPO. (Float)
Date Priced The date of the IPO. (Date)
Employees The number of employees at the company. (Integer)
Address The address of the company. (String)
US_state The US state the company is located in. (String)
descriptions A description of the company. (String)
link_nasdaq A link to the company's Nasdaq profile. (String)
Year The year of the IPO. (Integer)
firstday_adjclose The first day's adjusted close price. (Float)
firstday_open The first day's open price. (Float)
firstday_spread The difference between the first day's open and close price. (Float)
firstday_volume The number of shares traded on the first day. (Integer)
inmonth_adjclose The stock's adjusted close price for the month. (Float)
inmonth_open The stock's open price for the month. (Float)
inmonth_spread The difference between the stock's open and close price for the month. (Float)
inmonth_volume The number of shares traded in the month. (Integer)
inweek_adjclose The stock's adjusted close price for the week. (Float)
inweek_open The stock's open price for the week. (Float)
inweek_spread The difference between the stock's open and close price for the week. (Float)
inweek_volume The number of shares traded in the week. (Integer)
sector The sector the company is in. (String)
industry The industry the company is in. (String)
employees2019 The number of employees at the company as of 2019. (Integer)
CEO_pay The CEO's total pay. (Float)
CEO_born The CEO's year of birth. (Integer)

File: ipo_stock_2010_2018_v2.csv

Column name Description
Company Name The name of the company. (String)
Symbol The stock ticker symbol for the company. (String)
Market The market the company is listed on. (String)
Price The price of the stock at the time of the IPO. (Float)
Shares The number of shares offered in the IPO. (Integer)
Offer Amount The total amount of the IPO. (Float)
Date Priced The date of the IPO. (Date)
Employees The number of employees at the company. (Integer)
Address The address of the company. (String)
US_state The US state the company is located in. (String)
descriptions A description of the company. (String)
link_nasdaq A link to the company's Nasdaq profile. (String)
Year The year of the IPO. (Integer)
firstday_adjclose The first day's adjusted close price. (Float)
firstday_open The first day's open price. (Float)
inmonth_adjclose The stock's adjusted close price for the month. (Float)
inmonth_open The stock's open price for the month. (Float)
inweek_adjclose The stock's adjusted close price for the week. (Float)
inweek_open The stock's open price for the week. (Float)
sector The sector the company is in. (String)
industry The industry the company is in. (String)
employees2019 The number of employees at the company as of 2019. (Integer)
CEO_pay The CEO's total pay. (Float)
CEO_born The CEO's year of birth. (Integer)
inyear_adjclose The stock's adjusted close price for the year. (Float)
inyear_open The stock's open price for the year. (Float)

File: spy.csv

Column name Description
Date The date of the observation. (Date)
Open The opening price of the stock on the date of the observation. (Numeric)
High The highest price of the stock on the date of the observation. (Numeric)
Low The lowest price of the stock on the date of the observation. (Numeric)
Close The closing price of the stock on the date of the observation. (Numeric)
Adj Close The adjusted closing price of the stock on the date of the observation. (Numeric)
Volume The volume of shares traded on the date of the observation. (Numeric)

Acknowledgements

If you use this dataset in your research, please credit the original authors.
If you use this dataset in your research, please credit .

Tables

Ipo Clean 2010–2018

@kaggle.thedevastator_dataset_on_ipo_from_2010_2018.ipo_clean_2010_2018
  • 4.8 MB
  • 1600 rows
  • 13 columns
Loading... 

CREATE TABLE ipo_clean_2010_2018 (
  "company_name" VARCHAR,
  "symbol" VARCHAR,
  "market" VARCHAR,
  "price" DOUBLE,
  "shares" DOUBLE,
  "offer_amount" DOUBLE,
  "date_priced" TIMESTAMP,
  "employees" DOUBLE,
  "address" VARCHAR,
  "us_state" VARCHAR,
  "descriptions" VARCHAR,
  "link_nasdaq" VARCHAR,
  "year" BIGINT
);

Ipo Stock 2010–2018

@kaggle.thedevastator_dataset_on_ipo_from_2010_2018.ipo_stock_2010_2018
  • 3.55 MB
  • 1136 rows
  • 30 columns
Loading... 

CREATE TABLE ipo_stock_2010_2018 (
  "company_name" VARCHAR,
  "symbol" VARCHAR,
  "market" VARCHAR,
  "price" DOUBLE,
  "shares" DOUBLE,
  "offer_amount" DOUBLE,
  "date_priced" TIMESTAMP,
  "employees" DOUBLE,
  "address" VARCHAR,
  "us_state" VARCHAR,
  "descriptions" VARCHAR,
  "link_nasdaq" VARCHAR,
  "year" TIMESTAMP,
  "firstday_adjclose" DOUBLE,
  "firstday_open" DOUBLE,
  "firstday_spread" DOUBLE,
  "firstday_volume" DOUBLE,
  "inmonth_adjclose" DOUBLE,
  "inmonth_open" DOUBLE,
  "inmonth_spread" DOUBLE,
  "inmonth_volume" DOUBLE,
  "inweek_adjclose" DOUBLE,
  "inweek_open" DOUBLE,
  "inweek_spread" DOUBLE,
  "inweek_volume" DOUBLE,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "employees2019" DOUBLE,
  "ceo_pay" DOUBLE,
  "ceo_born" DOUBLE
);

Ipo Stock 2010–2018 V2

@kaggle.thedevastator_dataset_on_ipo_from_2010_2018.ipo_stock_2010_2018_v2
  • 2.57 MB
  • 834 rows
  • 26 columns
Loading... 

CREATE TABLE ipo_stock_2010_2018_v2 (
  "company_name" VARCHAR,
  "symbol" VARCHAR,
  "market" VARCHAR,
  "price" DOUBLE,
  "shares" DOUBLE,
  "offer_amount" DOUBLE,
  "date_priced" TIMESTAMP,
  "employees" DOUBLE,
  "address" VARCHAR,
  "us_state" VARCHAR,
  "descriptions" VARCHAR,
  "link_nasdaq" VARCHAR,
  "year" TIMESTAMP,
  "firstday_adjclose" DOUBLE,
  "firstday_open" DOUBLE,
  "inmonth_adjclose" DOUBLE,
  "inmonth_open" DOUBLE,
  "inweek_adjclose" DOUBLE,
  "inweek_open" DOUBLE,
  "inyear_adjclose" DOUBLE,
  "inyear_open" DOUBLE,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "employees2019" DOUBLE,
  "ceo_pay" DOUBLE,
  "ceo_born" DOUBLE
);

Spy

@kaggle.thedevastator_dataset_on_ipo_from_2010_2018.spy
  • 227.44 KB
  • 4897 rows
  • 7 columns
Loading... 

CREATE TABLE spy (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Share link

Anyone who has the link will be able to view this.