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

Ice

@kaggle.artemburenok_sp_500_stock_prices.ice

212.21 KB
4298 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Nov 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	7.800000190734863	8.842000007629395	7.711999893188477	7.849999904632568	7.011962890625	97759000
Thu Nov 17 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	8.0600004196167	8.350000381469727	6.800000190734863	7.050000190734863	6.297368049621582	34308500
Fri Nov 18 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	7.239999771118164	7.389999866485596	6.912000179290772	7	6.252704620361328	12810000
Mon Nov 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	7.050000190734863	7.191999912261963	6.964000225067139	7.179999828338623	6.413486957550049	6404000
Tue Nov 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	7.090000152587891	7.0920000076293945	6.860000133514404	6.989999771118164	6.243772506713867	6533000
Wed Nov 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	6.940000057220459	6.989999771118164	6.309999942779541	6.789999961853027	6.065123081207275	12421000
Fri Nov 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	6.75	6.889999866485596	6.730000019073486	6.829999923706055	6.100852966308594	1316000
Mon Nov 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	6.78000020980835	6.78000020980835	6.510000228881836	6.659999847412109	5.949001312255859	3155000
Tue Nov 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	6.659999847412109	6.697999954223633	6.254000186920166	6.394000053405762	5.711400032043457	4477500
Wed Nov 30 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	6.420000076293945	6.48199987411499	6.320000171661377	6.460000038146973	5.770354270935059	3894500


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