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

Zbh

@kaggle.artemburenok_sp_500_stock_prices.zbh

252.37 KB
5382 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Jul 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	28.640777587890625	30.04854393005371	28.640777587890625	28.89320373535156	26.376163482666016	2512582
Thu Jul 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	28.058252334594727	28.058252334594727	27.184465408325195	27.281553268432617	24.904903411865234	2755662
Fri Jul 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.37864112854004	28.165048599243164	27.37864112854004	27.572816848754883	25.17080307006836	1440146
Mon Jul 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.572816848754883	27.718446731567383	27.572816848754883	27.631067276000977	25.223974227905277	789907
Tue Jul 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.631067276000977	27.815534591674805	27.60194206237793	27.766990661621094	25.34806251525879	1003838
Wed Aug 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	28.15534019470215	28.98058319091797	28.15534019470215	28.640777587890625	26.145721435546875	1919611
Thu Aug 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	28.62135887145996	28.83495140075684	27.669902801513672	27.815534591674805	25.392370223999023	808550
Fri Aug 03 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.572816848754883	27.62135887145996	27.087379455566406	27.184465408325195	24.816274642944336	1240635
Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.184465408325195	27.37864112854004	26.504854202270508	26.95145606994629	24.60356712341309	1612465
Tue Aug 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	27.669902801513672	29.611650466918945	27.37864112854004	29.067960739135746	26.535694122314453	8050274


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