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

Lvs
@kaggle.benjaminpo_sp500_spx_components_stock_price.lvs

  • 59.25 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)45.545.545.8680000305175845.4099998474121145.79000091552734493537
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)45.5900001525878945.5900001525878945.70999908447265645.5200004577636745.5200004577636720653
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)45.4199981689453145.4199981689453145.65000152587890645.4199981689453145.6100006103515614984
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)45.4300003051757845.4300003051757845.545.3400001525878945.4199981689453121483
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)45.2799987792968845.2799987792968845.4399986267089845.20999908447265645.4399986267089819971
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)45.3199996948242245.3199996948242245.45999908447265645.26010131835937545.26010131835937573250
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)45.4399986267089845.4399986267089845.47000122070312545.3499984741210945.3499984741210911917
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)45.545.545.5200004577636745.4500007629394545.4500007629394552115
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)45.545.545.509998321533245.3899993896484445.47000122070312525168
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)45.5800018310546945.5800018310546945.63000106811523445.45999908447265645.529211

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