2000+ Assets (Stock & FX) Historical Price
frequency update, 2000+ assets, since IPO, included S&P500, NASDAQ and FX
@kaggle.benjaminpo_sp500_spx_components_stock_price
frequency update, 2000+ assets, since IPO, included S&P500, NASDAQ and FX
@kaggle.benjaminpo_sp500_spx_components_stock_price
datetimeDatetime | adj_closeAdj Close | closeClose | highHigh | lowLow | openOpen | volumeVolume |
---|---|---|---|---|---|---|
Tue Feb 08 2022 14:30:00 GMT+0000 (Coordinated Universal Time) | 71.37000274658203 | 71.37000274658203 | 71.37000274658203 | 70.12999725341797 | 70.12999725341797 | 6513 |
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time) | 69.94000244140625 | 69.94000244140625 | 69.95500183105469 | 69.8499984741211 | 69.8499984741211 | 519 |
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time) | 70.30999755859375 | 70.30999755859375 | 70.41000366210938 | 70.08000183105469 | 70.08000183105469 | 2487 |
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time) | 70.40499877929688 | 70.40499877929688 | 70.47000122070312 | 70.3499984741211 | 70.3499984741211 | 926 |
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time) | 70.30000305175781 | 70.30000305175781 | 70.31999969482422 | 70.30000305175781 | 70.31999969482422 | 1294 |
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time) | 70.12000274658203 | 70.12000274658203 | 70.24500274658203 | 70.12000274658203 | 70.24500274658203 | 863 |
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time) | 69.95999908447266 | 69.95999908447266 | 70.0999984741211 | 69.91000366210938 | 69.91000366210938 | 3199 |
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time) | 69.91500091552734 | 69.91500091552734 | 69.98999786376953 | 69.91000366210938 | 69.91999816894531 | 2549 |
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time) | 69.9563980102539 | 69.9563980102539 | 70.05000305175781 | 69.9563980102539 | 69.98999786376953 | 680 |
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time) | 70.0999984741211 | 70.0999984741211 | 70.0999984741211 | 70.06999969482422 | 70.06999969482422 | 537 |
CREATE TABLE reg (
"datetime" TIMESTAMP,
"adj_close" DOUBLE,
"close" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"open" DOUBLE,
"volume" DOUBLE
);
Anyone who has the link will be able to view this.