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

Cnc

@kaggle.artemburenok_sp_500_stock_prices.cnc

241.58 KB
5287 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Dec 13 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.189167022705078	1.475000023841858	1.189167022705078	1.4333330392837524	1.4333330392837524	56373600
Fri Dec 14 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.4341670274734497	1.4408329725265503	1.3708330392837524	1.3916670083999634	1.3916670083999634	11307600
Mon Dec 17 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.3916670083999634	1.4249999523162842	1.3833329677581787	1.4149999618530271	1.4149999618530271	1756800
Tue Dec 18 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.4083329439163208	1.4474999904632568	1.3916670083999634	1.4383330345153809	1.4383330345153809	3585600
Wed Dec 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.4375	1.774999976158142	1.4333330392837524	1.7258330583572388	1.7258330583572388	3352800
Thu Dec 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7000000476837158	1.899999976158142	1.6458330154418943	1.6541670560836792	1.6541670560836792	3855600
Fri Dec 21 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6741670370101929	1.6749999523162842	1.6541670560836792	1.6583329439163208	1.6583329439163208	3246000
Mon Dec 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.661666989326477	1.6875	1.634166955947876	1.662500023841858	1.662500023841858	968400
Wed Dec 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.6583329439163208	1.7166670560836792	1.6516669988632202	1.6933330297470093	1.6933330297470093	2115600
Thu Dec 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7083330154418943	1.740833044052124	1.690000057220459	1.7333329916000366	1.7333329916000366	2372400


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