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

Acn

@kaggle.artemburenok_sp_500_stock_prices.acn

250.99 KB
5386 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jul 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	15.100000381469728	15.289999961853027	15	15.170000076293944	11.101256370544434	34994300
Fri Jul 20 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	15.050000190734863	15.050000190734863	14.800000190734863	15.010000228881836	10.984173774719238	9238500
Mon Jul 23 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	15	15.010000228881836	14.550000190734863	15	10.976855278015137	7501000
Tue Jul 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.949999809265137	14.970000267028809	14.699999809265137	14.859999656677246	10.87440299987793	3537300
Wed Jul 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.699999809265137	14.949999809265137	14.649999618530272	14.949999809265137	10.940263748168944	4208100
Thu Jul 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.949999809265137	14.989999771118164	14.5	14.5	10.610955238342283	6335300
Fri Jul 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.510000228881836	14.59000015258789	14.5	14.510000228881836	10.618274688720703	3524000
Mon Jul 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.5	14.779999732971191	14.5	14.699999809265137	10.757315635681152	3654300
Tue Jul 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.710000038146973	15.010000228881836	14.600000381469728	14.960000038146973	10.94758415222168	1429000
Wed Aug 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	15	15.5	14.899999618530272	15.5	11.342750549316406	2087900


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