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

Alle

@kaggle.artemburenok_sp_500_stock_prices.alle

110.99 KB
2284 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Nov 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	49.75	50	47.4900016784668	48.47999954223633	44.60575485229492	587100
Tue Nov 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	48.9900016784668	49	45.29999923706055	45.79999923706055	42.139930725097656	1682000
Wed Nov 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.97999954223633	46	43.9900016784668	44.650001525878906	41.08182907104492	1106900
Thu Nov 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	44.5	45.150001525878906	43.040000915527344	43.790000915527344	40.290557861328125	730200
Fri Nov 22 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.900001525878906	44.09999847412109	43.25	43.9900016784668	40.47457504272461	947600
Mon Nov 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	44.27999877929688	45.619998931884766	43.70000076293945	44.18000030517578	40.649391174316406	727300
Tue Nov 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45	45	43.040000915527344	43.20000076293945	39.74771118164063	873700
Wed Nov 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.54999923706055	43.54999923706055	42.5	43.2400016784668	39.784515380859375	1153300
Fri Nov 29 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	42.75	43.84999847412109	42.75	43.2400016784668	39.784515380859375	949900
Mon Dec 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.08000183105469	43.66999816894531	41.52000045776367	43.13999938964844	39.69249725341797	5130700


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