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) | 188.16000366210935 | 188.16000366210935 | 188.16000366210935 | 187.47999572753903 | 187.47999572753903 | 5888 |
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time) | ||||||
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time) | 187.47999572753903 | 187.47999572753903 | 187.8999938964844 | 187.47999572753903 | 187.8999938964844 | 462 |
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time) | 187.94000244140625 | 187.94000244140625 | 188.30999755859372 | 187.41000366210935 | 188.30999755859372 | 875 |
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time) | 187.4199981689453 | 187.4199981689453 | 187.5399932861328 | 187.4199981689453 | 187.5200042724609 | 586 |
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time) | 187.1699981689453 | 187.1699981689453 | 187.1699981689453 | 187.1699981689453 | 187.1699981689453 | 320 |
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time) | 187.08999633789065 | 187.08999633789065 | 187.52999877929688 | 187.08999633789065 | 187.52999877929688 | 1012 |
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time) | 187.13499450683597 | 187.13499450683597 | 187.47000122070312 | 187.13499450683597 | 187.47000122070312 | 324 |
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time) | 187.27130126953125 | 187.27130126953125 | 187.27130126953125 | 187.08999633789065 | 187.08999633789065 | 305 |
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time) | 187.50999450683597 | 187.50999450683597 | 187.83999633789065 | 187.50999450683597 | 187.6999969482422 | 1055 |
CREATE TABLE are (
"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.