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

Aiz

@kaggle.artemburenok_sp_500_stock_prices.aiz

216.83 KB
4748 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Feb 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	23.75	24.940000534057617	23.25	24.700000762939453	17.737003326416016	27565200
Fri Feb 06 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.709999084472656	24.940000534057617	24.149999618530277	24.850000381469727	17.844711303710938	5284400
Mon Feb 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.600000381469727	24.700000762939453	24	24.46999931335449	17.571826934814453	3252900
Tue Feb 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.149999618530277	24.46999931335449	24.049999237060547	24.350000381469727	17.48566436767578	1651600
Wed Feb 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.280000686645508	24.5	24.149999618530277	24.25	17.41385269165039	2010200
Thu Feb 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.190000534057617	25	24.170000076293945	24.68000030517578	17.72263526916504	1637500
Fri Feb 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.790000915527344	24.84000015258789	24.280000686645508	24.700000762939453	17.737003326416016	612000
Tue Feb 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.75	24.899999618530277	24.5	24.600000381469727	17.66518783569336	592300
Wed Feb 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	24.600000381469727	25.399999618530277	24.350000381469727	25.399999618530277	18.239669799804688	805700
Thu Feb 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	25.25	25.979999542236328	25.25	25.68000030517578	18.440732955932617	1494600


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