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

Amp

@kaggle.artemburenok_sp_500_stock_prices.amp

209.94 KB
4342 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Sep 15 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	38.02000045776367	38.09999847412109	37	37.0099983215332	25.85664176940918	1529800
Fri Sep 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	37	37	36.59999847412109	36.59999847412109	25.57019805908203	62400
Mon Sep 19 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	36.59999847412109	36.70000076293945	36.45000076293945	36.70000076293945	25.640060424804688	1162300
Tue Sep 20 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	36.59999847412109	37	36.59999847412109	36.70000076293945	25.640060424804688	654900
Wed Sep 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	36.59999847412109	36.59999847412109	36	36.400001525878906	25.43047332763672	424300
Thu Sep 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	36.400001525878906	37.20000076293945	36.400001525878906	37.20000076293945	25.989389419555664	864800
Fri Sep 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	37.20000076293945	38.09999847412109	37.20000076293945	37.68000030517578	26.32473564147949	1249900
Mon Sep 26 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	37.75	38.150001525878906	37.75	37.75	26.373640060424805	821400
Tue Sep 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	37.75	37.900001525878906	37.13999938964844	37.25	26.024309158325195	1514000
Wed Sep 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	37.2400016784668	37.400001525878906	36.79999923706055	37	25.84966278076172	875700


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