COVID-19 Vaccine Companies : Stock Data
Latest Stock Data of COVID-19 Vaccine Companies from 2019
@kaggle.akpmpr_covid_vaccine_companies_stock_data_from_2019
Latest Stock Data of COVID-19 Vaccine Companies from 2019
@kaggle.akpmpr_covid_vaccine_companies_stock_data_from_2019
Stock data of the following companies from Oct 2019 is included in this dataset.
(BioNTech , Moderna , Johnson & Johnson , Inovio Pharmaceuticals, Sinovac , Sinopharm , Novavax ,Astrazeneca(Oxford))
(The date 2019 was chosen because few companies got IPO just in 2019)
To do more analysis on the performance of the companies with the influence of covid vaccine.
Please let me know if any more companies are to be included or any changes have to be made to improve the quality of the dataset in the discussion section.
CREATE TABLE vaccine_stocks (
"date" TIMESTAMP,
"high_biontech" DOUBLE,
"low_biontech" DOUBLE,
"open_biontech" DOUBLE,
"close_biontech" DOUBLE,
"volume_biontech" BIGINT,
"adj_close_biontech" DOUBLE,
"high_moderna" DOUBLE,
"low_moderna" DOUBLE,
"open_moderna" DOUBLE,
"close_moderna" DOUBLE,
"volume_moderna" BIGINT,
"adj_close_moderna" DOUBLE,
"high_johnson_johnson" DOUBLE -- High Johnson \u0026 Johnson,
"low_johnson_johnson" DOUBLE -- Low Johnson \u0026 Johnson,
"open_johnson_johnson" DOUBLE -- Open Johnson \u0026 Johnson,
"close_johnson_johnson" DOUBLE -- Close Johnson \u0026 Johnson,
"volume_johnson_johnson" BIGINT -- Volume Johnson \u0026 Johnson,
"adj_close_johnson_johnson" DOUBLE -- Adj Close Johnson \u0026 Johnson,
"high_inovio_pharmaceuticals" DOUBLE,
"low_inovio_pharmaceuticals" DOUBLE,
"open_inovio_pharmaceuticals" DOUBLE,
"close_inovio_pharmaceuticals" DOUBLE,
"volume_inovio_pharmaceuticals" BIGINT,
"adj_close_inovio_pharmaceuticals" DOUBLE,
"high_sinovac" DOUBLE,
"low_sinovac" DOUBLE,
"open_sinovac" DOUBLE,
"close_sinovac" DOUBLE,
"volume_sinovac" BIGINT,
"adj_close_sinovac" DOUBLE,
"high_sinopharm" DOUBLE,
"low_sinopharm" DOUBLE,
"open_sinopharm" DOUBLE,
"close_sinopharm" DOUBLE,
"volume_sinopharm" BIGINT,
"adj_close_sinopharm" DOUBLE,
"high_novavax" DOUBLE,
"low_novavax" DOUBLE,
"open_novavax" DOUBLE,
"close_novavax" DOUBLE,
"volume_novavax" BIGINT,
"adj_close_novavax" DOUBLE,
"high_astrazeneca" DOUBLE,
"low_astrazeneca" DOUBLE,
"open_astrazeneca" DOUBLE,
"close_astrazeneca" DOUBLE,
"volume_astrazeneca" BIGINT,
"adj_close_astrazeneca" DOUBLE
);Anyone who has the link will be able to view this.