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

Awk

@kaggle.artemburenok_sp_500_stock_prices.awk

171.63 KB
3688 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Apr 23 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	20.600000381469727	21.450000762939453	20.21999931335449	20.600000381469727	14.3499116897583	23402800
Thu Apr 24 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	20.71999931335449	21	20.309999465942383	20.809999465942383	14.496192932128906	4960900
Fri Apr 25 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21	21.25	20.700000762939453	21.170000076293945	14.74697208404541	1956800
Mon Apr 28 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21.489999771118164	21.489999771118164	20.809999465942383	21	14.628544807434082	709400
Tue Apr 29 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21.38999938964844	21.38999938964844	20.81999969482422	21.06999969482422	14.6773099899292	859700
Wed Apr 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21.07999992370605	21.200000762939453	20.920000076293945	21.149999618530277	14.733036041259766	893300
Thu May 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21.21999931335449	22	21	21.90999984741211	15.262452125549316	2999000
Fri May 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	22.15999984741211	22.15999984741211	21.489999771118164	22.01000022888184	15.332112312316896	1639400
Mon May 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	22.450000762939453	22.450000762939453	21.559999465942383	21.90999984741211	15.262452125549316	579000
Tue May 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	21.799999237060547	21.86000061035156	21.3700008392334	21.549999237060547	15.011679649353027	1040200


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