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

Etn
@kaggle.benjaminpo_sp500_spx_components_stock_price.etn

  • 68.04 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)150.42999267578125150.42999267578125150.59500122070312150.1199951171875150.1900024414062522260
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)150.6699981689453150.6699981689453150.6699981689453150.6699981689453150.6699981689453325
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)150.52999877929688150.52999877929688150.97999572753906150.52999877929688150.774993896484385716
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)150.31500244140625150.31500244140625150.60000610351562150.31500244140625150.595001220703121685
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)150.31500244140625150.31500244140625150.3249969482422150.3000030517578150.3000030517578999
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)150.2949981689453150.2949981689453150.30499267578125150.19000244140625150.30499267578125481
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)150.17999267578125150.17999267578125150.1999969482422150150.16999816894534889
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)150.17999267578125150.17999267578125150.17999267578125149.99000549316406149.990005493164062703
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)149.94500732421875149.94500732421875150.03500366210938149.94500732421875150.035003662109381442
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)149.78509521484375149.78509521484375149.9149932861328149.78509521484375149.9149932861328954

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