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

Ea
@kaggle.benjaminpo_sp500_spx_components_stock_price.ea

  • 60.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)136.4149932861328136.4149932861328136.5800018310547135.85000610351562136.3200073242187556666
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)136.25136.25136.40499877929688136.1300048828125136.320007324218754404
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)136.05999755859375136.05999755859375136.30999755859375136.02999877929688136.25500488281251687
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)136.9149932861328136.9149932861328136.9149932861328136.2449951171875136.24499511718756481
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)136.99000549316406136.99000549316406137.14999389648438136.69000244140625136.794998168945310184
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)136.77000427246094136.77000427246094137.05499267578125136.77000427246094137.05000305175782549
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)136.8699951171875136.8699951171875136.89999389648438136.75136.770004272460944667
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)136.80499267578125136.80499267578125137.1199951171875136.80499267578125136.970001220703124561
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)136.96499633789062136.96499633789062136.96499633789062136.81500244140625136.815002441406253978
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)137.10000610351562137.10000610351562137.1750030517578137.0399932861328137.03999328613283956

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