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

Alb
@kaggle.benjaminpo_sp500_spx_components_stock_price.alb

  • 75.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)219.1000061035156219.1000061035156219.75218.2928009033203218.9299926757812515838
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)220.0399932861328220.0399932861328220.52999877929688219.0449981689453219.04499816894531799
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)220.21539306640625220.21539306640625220.82000732421875219.5200042724609220.820007324218755260
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)219.47999572753903219.47999572753903220.55499267578125219.47999572753903220.30000305175782680
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)218.4550018310547218.4550018310547219.6300048828125218.4550018310547219.46000671386722135
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)219.3500061035156219.3500061035156219.67999267578125218.7899932861328219.410003662109351639
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)219.8500061035156219.8500061035156219.8500061035156219.4900054931641219.49000549316411228
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)219.5500030517578219.5500030517578220.22000122070312219.5500030517578219.83000183105472666
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)219.65499877929688219.65499877929688219.9900054931641219.51190185546875219.66999816894531364
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)219.8800048828125219.8800048828125220.1300048828125219.58999633789065219.589996337890651442

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