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

Pru
@kaggle.benjaminpo_sp500_spx_components_stock_price.pru

  • 67.48 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)120.54000091552734120.54000091552734120.97000122070312120.5120.97000122070312268831
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)120.11000061035156120.11000061035156120.44000244140624120.05500030517578120.389999389648446834
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)120.08999633789062120.08999633789062120.20999908447266120120.209999084472665453
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)120.13999938964844120.13999938964844120.31999969482422120.13999938964844120.290000915527342490
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)120.19000244140624120.19000244140624120.33000183105467120.1061019897461120.10610198974613101
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)120.02999877929688120.02999877929688120.23999786376952120120.180702209472663621
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)120.0199966430664120.0199966430664120.06999969482422119.90750122070312119.930000305175784099
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)120.01000213623048120.01000213623048120.02999877929688119.91000366210938119.919998168945333755
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)120.15499877929688120.15499877929688120.2300033569336120.01000213623048120.059997558593765291
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)120.08999633789062120.08999633789062120.23500061035156119.91999816894533120.2111968994140631803

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