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

Bwa
@kaggle.benjaminpo_sp500_spx_components_stock_price.bwa

  • 57.34 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)43.6699981689453143.6699981689453143.7000007629394543.5299987792968843.7000007629394514833
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)43.6599998474121143.6599998474121143.6599998474121143.6399993896484443.639999389648442229
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)43.6100006103515643.6100006103515643.65000152587890643.6100006103515643.650001525878906535
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)43.4399986267089843.4399986267089843.5110015869140643.3899993896484443.511001586914063406
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)43.3499984741210943.3499984741210943.40000152587890643.3199996948242243.389999389648442254
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)43.29000091552734443.29000091552734443.3190002441406343.29000091552734443.319000244140632096
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)43.3300018310546943.3300018310546943.3499984741210943.2999992370605543.340000152587893469
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)43.3499984741210943.3499984741210943.4099998474121143.3499984741210943.360000610351562602
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)43.3600006103515643.3600006103515643.40000152587890643.3600006103515643.4000015258789062182
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)43.2700004577636743.2700004577636743.3320007324218843.2700004577636743.319999694824222559

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