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

Phm

@kaggle.artemburenok_sp_500_stock_prices.phm

368.49 KB
10779 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1914059966802597	0.1855469942092895	0.1855469942092895	0.1353991776704788	70400
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1835940033197403	0.1777340024709701	0.1835940033197403	0.1339741796255111	230400
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1796880066394806	0.1757809966802597	0.1796880066394806	0.1311237215995788	153600
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1796880066394806	0.1757809966802597	0.1777340024709701	0.1296978145837783	70400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1777340024709701	0.1777340024709701	0.1777340024709701	0.1777340024709701	0.1296978145837783
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1777340024709701	0.1699219942092895	0.1757809966802597	0.1282726973295211	179200
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1699219942092895	0.1640630066394806	0.1679690033197403	0.1225721016526222	76800
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1640630066394806	0.1582030057907104	0.1582030057907104	0.1154455319046974	198400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.15625	0.140625	0.1445309966802597	0.1054686158895492	473600
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1640630066394806	0.1503909975290298	0.1640630066394806	0.1197217404842376	268800


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