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

Apa

@kaggle.artemburenok_sp_500_stock_prices.apa

414.22 KB
10991 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue May 15 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.559403896331787	3.607503890991211	3.5113039016723637	3.559403896331787	1.9577537775039675	22349
Wed May 16 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.583453893661499	3.823954105377197	3.583453893661499	3.799904108047485	2.0900352001190186	66008
Thu May 17 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.799904108047485	3.848004102706909	3.799904108047485	3.848004102706909	2.1164915561676025	57692
Fri May 18 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.848004102706909	3.9923040866851807	3.848004102706909	3.9682540893554688	2.1826295852661133	119023
Mon May 21 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.9682540893554688	4.064454078674316	3.920154094696045	4.040403842926025	2.2223150730133057	106549
Tue May 22 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	4.040403842926025	4.136603832244873	4.040403842926025	4.088503837585449	2.2487711906433105	127339
Wed May 23 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	4.088503837585449	4.088503837585449	3.9682540893554688	3.9682540893554688	2.1826295852661133	85759
Thu May 24 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.9682540893554688	3.9923040866851807	3.872054100036621	3.920154094696045	2.1561756134033203	80561
Fri May 25 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.920154094696045	3.9923040866851807	3.872054100036621	3.9682540893554688	2.1826295852661133	63410
Tue May 29 1979 00:00:00 GMT+0000 (Coordinated Universal Time)	3.9682540893554688	4.184703826904297	3.9682540893554688	4.11255407333374	2.2619993686676025	123181


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