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

Vici

@kaggle.artemburenok_sp_500_stock_prices.vici

57.82 KB
1247 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20.600000381469727	19.950000762939453	20.100000381469727	15.702136039733888	427900
Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.5	20.600000381469727	20	20.15999984741211	15.749008178710938	231300
Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.149999618530277	20.5	20.100000381469727	20.200000762939453	15.78026008605957	447800
Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.200000762939453	20.200000762939453	20.149999618530277	20.200000762939453	15.78026008605957	78300
Mon Jan 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.200000762939453	20.200000762939453	20.049999237060547	20.200000762939453	15.78026008605957	59200
Tue Jan 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.200000762939453	20.209999084472656	20	20.209999084472656	15.788066864013672	224700
Wed Jan 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	19.899999618530277	20.200000762939453	19.899999618530277	20	15.624019622802734	367500
Thu Jan 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20	19.850000381469727	20	15.624019622802734	37800
Fri Jan 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20	19.5	19.989999771118164	15.616203308105469	1109300
Tue Jan 16 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20.5	22.989999771118164	20.5	21.5	16.795818328857422	2005000


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