Baselight
Sign In

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

Xel
@kaggle.benjaminpo_sp500_spx_components_stock_price.xel

  • 55.18 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)69.1299972534179769.1299972534179769.269996643066469.019996643066469.150001525878944592
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)69.0299987792968869.0299987792968869.0800018310546969.0299987792968869.029998779296883484
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)69.0400009155273469.0400009155273469.0400009155273468.9100036621093868.919998168945313350
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)69.0699996948242269.0699996948242269.1600036621093869.0599975585937569.129997253417977684
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)68.980003356933668.980003356933669.0500030517578168.9100036621093869.050003051757816302
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)68.9700012207031268.9700012207031268.9700012207031268.9700012207031268.970001220703123547
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)68.8399963378906268.8399963378906268.9150009155273468.8206024169921968.915000915527344846
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)68.8000030517578168.8000030517578168.8300018310546968.8000030517578168.830001831054691857
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)68.8799972534179768.8799972534179768.9400024414062568.8399963378906268.839996337890624020
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)68.8399963378906268.8399963378906268.8799972534179768.8399963378906268.860000610351563444

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