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

Expd
@kaggle.benjaminpo_sp500_spx_components_stock_price.expd

  • 60.78 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)110.3000030517578110.3000030517578110.3000030517578109.40499877929688109.9100036621093815790
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)110.18000030517578110.18000030517578110.29000091552734110.16999816894533110.290000915527341510
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)110.0500030517578110.0500030517578110.0500030517578110110203
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)110.04499816894533110.04499816894533110.04499816894533110.04499816894533110.04499816894533593
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)110.11499786376952110.11499786376952110.19000244140624110.0250015258789110.02500152587891785
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)110.2699966430664110.2699966430664110.2699966430664110.12999725341795110.23999786376952791
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)110.22550201416016110.22550201416016110.2699966430664110.13500213623048110.13500213623048864
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)110.13500213623048110.13500213623048110.2699966430664110.13500213623048110.2699966430664236
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)109.76000213623048109.76000213623048110109.739997863769521103741
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)109.53500366210938109.53500366210938109.66000366210938109.53500366210938109.66000366210938422

CREATE TABLE expd (
  "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.