Multiple Stock Prices By Industry

Stock Prices by Industry for Time Series Analysis

@kaggle.chayanonc_multiple_stock_prices_by_industry_updated_daily

Table List

2 tables(788.92 KB)

Stock Prices

@kaggle.chayanonc_multiple_stock_prices_by_industry_updated_daily.stock_prices

485.06 KB
2720 rows
25 columns

unnamed_0 Unnamed: 0	tech Tech	tech_1 Tech.1	tech_2 Tech.2	tech_3 Tech.3	finance Finance	finance_1 Finance.1	finance_2 Finance.2	finance_3 Finance.3	pharma Pharma	pharma_1 Pharma.1	pharma_2 Pharma.2	pharma_3 Pharma.3	food Food	food_1 Food.1	food_2 Food.2	food_3 Food.3	education Education	education_1 Education.1	education_2 Education.2	education_3 Education.3	energy Energy	energy_1 Energy.1	energy_2 Energy.2	energy_3 Energy.3
nan	MSFT	GOOGL	META	NVDA	JPM	BAC	MA	V	JNJ	PFE	MRK	AZN	YUM	MCD	SBUX	DPZ	UDMY	DUOL	COUR	CHGG	XOM	CVX	SHEL	NEE
Date	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
2014-01-02	37.15999984741211	27.85585594177246	54.709999084472656	0.39649999141693115	58.209999084472656	16.100000381469727	83.41400146484375	55.252498626708984	91.02999877929688	28.899431228637695	47.22328186035156	29.28499984741211	53.98274612426758	96.41000366210938	38.584999084472656	68.94000244140625	nan	nan	nan	8.3100004196167	99.75	124.13999938964844	70.6500015258789	21.0625
2014-01-03	36.90999984741211	27.652652740478516	54.560001373291016	0.3917500078678131	58.65999984741211	16.40999984741211	83.08100128173828	55.290000915527344	91.8499984741211	28.956356048583984	47.45228958129883	29.43000030517578	54.32063293457031	96.54000091552734	38.474998474121094	68.9800033569336	nan	nan	nan	8.210000038146973	99.51000213623047	124.3499984741211	70.77999877929688	21.09000015258789
2014-01-06	36.130001068115234	27.960960388183594	57.20000076293945	0.3970000147819519	59.0	16.65999984741211	82.66899871826172	54.95750045776367	92.33000183105469	28.984819412231445	47.461830139160156	29.44499969482422	54.277496337890625	95.8499984741211	38.084999084472656	69.0999984741211	nan	nan	nan	8.260000228881836	99.66000366210938	124.0199966430664	70.30999755859375	21.100000381469727
2014-01-07	36.40999984741211	28.5	57.91999816894531	0.4034999907016754	58.31999969482422	16.5	83.70899963378906	55.377498626708984	94.29000091552734	29.165084838867188	47.814884185791016	29.2549991607666	55.0395393371582	96.37999725341797	38.60499954223633	69.66999816894531	nan	nan	nan	8.220000267028809	101.06999969482422	125.06999969482422	70.91999816894531	21.2549991607666
2014-01-08	35.7599983215332	28.559309005737305	58.22999954223633	0.4090000092983246	58.869998931884766	16.579999923706055	83.68399810791016	55.55500030517578	94.16000366210938	29.36432647705078	47.50954055786133	29.260000228881836	55.017974853515625	95.41000366210938	39.01499938964844	69.77999877929688	nan	nan	nan	7.78000020980835	100.73999786376953	123.29000091552734	70.41000366210938	21.322500228881836
2014-01-09	35.529998779296875	28.284284591674805	57.220001220703125	0.39375001192092896	58.7599983215332	16.829999923706055	84.36000061035156	55.477500915527344	94.7300033569336	29.34535026550293	47.25190734863281	29.684999465942383	53.9539909362793	95.45999908447266	38.79999923706055	70.27999877929688	nan	nan	nan	7.800000190734863	99.76000213623047	123.29000091552734	70.6500015258789	21.5049991607666
2014-01-10	36.040000915527344	28.28278350830078	57.939998626708984	0.3932499885559082	58.4900016784668	16.770000457763672	83.47599792480469	55.282501220703125	94.73999786376953	29.117647171020508	47.595420837402344	30.239999771118164	53.93242263793945	95.80000305175781	38.834999084472656	71.20999908447266	nan	nan	nan	7.610000133514404	100.5199966430664	121.01000213623047	72.0	21.8125
2014-01-13	34.97999954223633	28.102603912353516	55.90999984741211	0.3840000033378601	57.70000076293945	16.43000030517578	81.0	54.724998474121094	94.5	28.975332260131836	50.6870231628418	29.809999465942383	52.77498245239258	94.83000183105469	37.560001373291016	70.94999694824219	nan	nan	nan	7.179999828338623	98.55000305175781	119.25	71.05000305175781	21.670000076293945


CREATE TABLE stock_prices (
  "unnamed_0" VARCHAR,
  "tech" VARCHAR,
  "tech_1" VARCHAR,
  "tech_2" VARCHAR,
  "tech_3" VARCHAR,
  "finance" VARCHAR,
  "finance_1" VARCHAR,
  "finance_2" VARCHAR,
  "finance_3" VARCHAR,
  "pharma" VARCHAR,
  "pharma_1" VARCHAR,
  "pharma_2" VARCHAR,
  "pharma_3" VARCHAR,
  "food" VARCHAR,
  "food_1" VARCHAR,
  "food_2" VARCHAR,
  "food_3" VARCHAR,
  "education" VARCHAR,
  "education_1" VARCHAR,
  "education_2" VARCHAR,
  "education_3" VARCHAR,
  "energy" VARCHAR,
  "energy_1" VARCHAR,
  "energy_2" VARCHAR,
  "energy_3" VARCHAR
);