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

Efx

@kaggle.artemburenok_sp_500_stock_prices.efx

375.62 KB
10779 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7760419845581055	0.7604169845581055	0.765625	0.2514011859893799	57600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7604169845581055	0.75	0.75	0.2462707161903381	19200
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.75	0.75	0.75	0.75	0.2462707161903381
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7552080154418945	0.7552080154418945	0.7552080154418945	0.2479807734489441	2400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7447919845581055	0.7395830154418945	0.7395830154418945	0.242850124835968	12000
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.75	0.7395830154418945	0.7395830154418945	0.242850124835968	9600
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.734375	0.734375	0.734375	0.2411402016878128	2400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.734375	0.7291669845581055	0.7291669845581055	0.2394299060106277	9600
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7395830154418945	0.7291669845581055	0.7291669845581055	0.2394299060106277	28800
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.7291669845581055	0.7135419845581055	0.7239580154418945	0.2377195060253143	67200


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