S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Table List

500 tables(151.9 MB)

results for

Ftv

Qcom

Incy

Ceg

Pep

@kaggle.artemburenok_sp_500_stock_prices.pep

457.29 KB
12745 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)		1.6018520593643188	1.5833330154418943	1.6018520593643188	0.4172528088092804	318600
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6018520593643188	1.618056058883667	1.5972219705581665	1.5972219705581665	0.4160465598106384	140400
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5972219705581665	1.599537014961243	1.5439809560775757	1.5740740299224854	0.411209225654602	469800
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5601849555969238	1.5601849555969238	1.555556058883667	1.5601849555969238	0.4075806438922882	140400
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5601849555969238	1.5625	1.546296000480652	1.5509259700775146	0.4051620662212372	178200
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5509259700775146	1.555556058883667	1.5416669845581057	1.5509259700775146	0.4051620662212372	432000
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5509259700775146	1.555556058883667	1.548611044883728	1.5532410144805908	0.4057667553424835	199800
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5532410144805908	1.555556058883667	1.546296000480652	1.548611044883728	0.4045571386814117	183600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5509259700775146	1.5671299695968628	1.5509259700775146	1.5671299695968628	0.4093952476978302	415800
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	1.5717589855194092	1.587962985038757	1.5717589855194092	1.5833330154418943	0.4136279821395874	216000


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