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

Kmx
@kaggle.benjaminpo_sp500_spx_components_stock_price.kmx

  • 67.94 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)105.16000366210938105.16000366210938105.26000213623048105.16000366210938105.2600021362304816114
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)105.70999908447266105.70999908447266105.70999908447266105.41000366210938105.41000366210938458
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)105.52999877929688105.52999877929688105.62000274658205105.52999877929688105.620002746582051257
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)106.00420379638672106.00420379638672106.00420379638672105.77999877929688105.779998779296881126
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)106.3000030517578106.3000030517578106.38999938964844106.3000030517578106.360000610351561117
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)106.5199966430664106.5199966430664106.58000183105467106.37999725341795106.379997253417952197

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