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

Cprt

@kaggle.artemburenok_sp_500_stock_prices.cprt

291.53 KB
7238 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Mar 17 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.28125	0.3098959922790527	0.2708329856395721	0.3046880066394806	0.3046880066394806	94171200
Fri Mar 18 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3125	0.3177079856395721	0.2994790077209472	0.3177079856395721	0.3177079856395721	18096000
Mon Mar 21 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3177079856395721	0.328125	0.3098959922790527	0.3177079856395721	0.3177079856395721	4584000
Tue Mar 22 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.328125	0.3333329856395721	0.3177079856395721	0.3177079856395721	0.3177079856395721	7243200
Wed Mar 23 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3229170143604278	0.3229170143604278	0.3125	0.3177079856395721	0.3177079856395721	3216000
Thu Mar 24 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3203130066394806	0.3203130066394806	0.3125	0.3203130066394806	0.3203130066394806	2606400
Fri Mar 25 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3203130066394806	0.3333329856395721	0.3125	0.3333329856395721	0.3333329856395721	2587200
Mon Mar 28 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3333329856395721	0.3333329856395721	0.3125	0.3151040077209472	0.3151040077209472	4838400
Tue Mar 29 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.3177079856395721	0.3177079856395721	0.296875	0.296875	0.296875	1699200
Wed Mar 30 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.296875	0.3072920143604278	0.296875	0.3020829856395721	0.3020829856395721	2289600


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