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

Csgp

@kaggle.artemburenok_sp_500_stock_prices.csgp

269.73 KB
6155 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Jul 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	0.8999999761581421	0.949999988079071	0.8999999761581421	0.918749988079071	0.918749988079071	7524000
Thu Jul 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	0.931249976158142	0.975000023841858	0.918749988079071	0.975000023841858	0.975000023841858	369000
Mon Jul 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	0.975000023841858	1.0625	0.975000023841858	1.006250023841858	1.006250023841858	1881000
Tue Jul 07 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1.037500023841858	1.0499999523162842	1.024999976158142	1.024999976158142	1.024999976158142	201000
Wed Jul 08 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1.0125000476837158	1.0499999523162842	1	1.0125000476837158	1.0125000476837158	864000
Thu Jul 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1.024999976158142	1.0499999523162842	1.0125000476837158	1.0499999523162842	1.0499999523162842	158000
Fri Jul 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1.068750023841858	1.068750023841858	0.975000023841858	0.975000023841858	0.975000023841858	962000
Mon Jul 13 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	1.024999976158142	1.024999976158142	0.987500011920929	1	1	935000
Tue Jul 14 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	0.987500011920929	1	0.962499976158142	0.975000023841858	0.975000023841858	605000
Wed Jul 15 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	0.962499976158142	0.987500011920929	0.949999988079071	0.975000023841858	0.975000023841858	619000


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