S&P 500 Stock Prices
All companies which included in S&P 500 index
@kaggle.artemburenok_sp_500_stock_prices
All companies which included in S&P 500 index
@kaggle.artemburenok_sp_500_stock_prices
dateDate | openOpen | highHigh | lowLow | closeClose | adj_closeAdj Close | volumeVolume |
---|---|---|---|---|---|---|
Thu Jul 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.220001220703125 | 49.20000076293945 | 47.84000015258789 | 48.040000915527344 | 31.64081573486328 | 109200 |
Fri Jul 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 49.2400016784668 | 49.79999923706055 | 47.900001525878906 | 49.720001220703125 | 32.747337341308594 | 56800 |
Mon Jul 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 49.79999923706055 | 49.79999923706055 | 48.29999923706055 | 48.47999954223633 | 31.930627822875977 | 39600 |
Tue Jul 26 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.70000076293945 | 48.70000076293945 | 47.5 | 48 | 31.614484786987305 | 102450 |
Wed Jul 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48 | 48.2400016784668 | 47.29999923706055 | 48.13999938964844 | 31.70669937133789 | 98100 |
Thu Jul 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.20000076293945 | 48.2400016784668 | 47.81999969482422 | 48.09999847412109 | 31.68035125732422 | 93600 |
Fri Jul 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.20000076293945 | 48.70000076293945 | 47.70000076293945 | 48.68000030517578 | 32.062355041503906 | 60700 |
Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.459999084472656 | 49 | 48.20000076293945 | 48.70000076293945 | 32.07554244995117 | 164950 |
Tue Aug 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 52 | 52 | 47.27999877929688 | 48.09999847412109 | 31.68035125732422 | 299700 |
Wed Aug 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time) | 48.540000915527344 | 48.540000915527344 | 47.52000045776367 | 47.70000076293945 | 31.41689109802246 | 147750 |
CREATE TABLE expe (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);
Anyone who has the link will be able to view this.