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

Bll
@kaggle.benjaminpo_sp500_spx_components_stock_price.bll

  • 58.17 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)92.9199981689453392.9199981689453392.9199981689453392.769996643066492.8300018310546718457
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)92.7399978637695292.7399978637695292.7399978637695292.7399978637695292.73999786376952441
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)92.800003051757892.800003051757892.938697814941492.599998474121192.690002441406243239
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)92.855003356933692.855003356933692.8600006103515692.7200012207031292.809997558593762485
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)92.8399963378906292.8399963378906292.9700012207031292.7649993896484492.90000152587893547
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)92.7099990844726692.7099990844726692.9700012207031292.7099990844726692.910003662109383184
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)92.8050003051757892.8050003051757892.9384002685546792.7900009155273492.790000915527344912
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)92.8399963378906292.8399963378906292.9199981689453392.8300018310546792.84999847412112515
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)92.7099990844726692.7099990844726692.8399963378906292.7099990844726692.839996337890621167
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)92.5899963378906292.5899963378906292.7900009155273492.5699996948242292.72499847412116613

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