Baselight

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

Ph
@kaggle.benjaminpo_sp500_spx_components_stock_price.ph

  • 71.33 KB
  • 1951 rows
  • 7 columns
datetime

Datetime

adj_close

Adj Close

close

Close

high

High

low

Low

open

Open

volume

Volume

Tue Feb 08 2022 14:30:00 GMT+0000 (Coordinated Universal Time)304.3999938964844304.3999938964844304.8900146484375304.0799865722656304.1499938964844115291
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)303.8399963378906303.8399963378906304.1099853515625303.8399963378906304.1099853515625772
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)303.57000732421875303.57000732421875303.57000732421875303.57000732421875303.57000732421875390
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)303.8999938964844303.8999938964844303.95001220703125303.8999938964844303.95001220703125271
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)303.0400085449219303.0400085449219303.0400085449219303.0400085449219303.0400085449219495
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)302.17999267578125302.17999267578125303302.179992675781253033936
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)301.6499938964844301.6499938964844302.010009765625301.6499938964844302.010009765625599
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)301.6000061035156301.6000061035156301.8900146484375301.5301.799987792968752419
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)301.2699890136719301.2699890136719301.5301.25301.48001098632812522
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)300.94000244140625300.94000244140625301300.64001464843753011568

CREATE TABLE ph (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);

Share link

Anyone who has the link will be able to view this.