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 |
---|---|---|---|---|---|---|
Fri Nov 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.8125 | 3.75 | 3.78125 | 3.78125 | 12706000 |
Mon Nov 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.78125 | 3.75 | 3.75 | 3.75 | 1213200 |
Tue Nov 21 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.78125 | 3.75 | 3.75 | 3.75 | 909600 |
Wed Nov 22 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.78125 | 3.75 | 3.75 | 3.75 | 1314800 |
Fri Nov 24 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.78125 | 3.75 | 3.75 | 3.75 | 275200 |
Mon Nov 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.75 | 3.78125 | 3.75 | 3.75 | 3.75 | 1011600 |
Tue Nov 28 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.625 | 3.625 | 3.3125 | 3.53125 | 3.53125 | 3952000 |
Wed Nov 29 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.5 | 3.5625 | 3.34375 | 3.4375 | 3.4375 | 708400 |
Thu Nov 30 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.4375 | 3.75 | 3.40625 | 3.6875 | 3.6875 | 1346000 |
Fri Dec 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time) | 3.6875 | 3.6875 | 3.53125 | 3.5625 | 3.5625 | 790800 |
CREATE TABLE wat (
"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.