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

Tgt
@kaggle.benjaminpo_sp500_spx_components_stock_price.tgt

  • 71.73 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)211.2700042724609211.2700042724609211.5200042724609211.0800018310547211.080001831054746224
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)211.1699981689453211.1699981689453211.2400054931641210.83999633789065211.13000488281259173
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)211.1000061035156211.1000061035156211.4499969482422211.09500122070312211.095001220703125917
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)211.0500030517578211.0500030517578211.0500030517578210.6499938964844210.910003662109355629
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)211.00999450683597211.00999450683597211.0449981689453210.85499572753903211.04499816894531963
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)211.7100067138672211.7100067138672211.75999450683597211.1100006103516211.11000061035169001
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)212.3999938964844212.3999938964844212.3999938964844211.75999450683597211.770004272460919932
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)212.6000061035156212.6000061035156212.75999450683597212.33999633789065212.339996337890659948
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)212.92999267578125212.92999267578125212.92999267578125212.4600067138672212.66999816894538970
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)212.52099609375212.52099609375212.7949981689453212.50010681152344212.79159545898448078

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