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

Reg
@kaggle.benjaminpo_sp500_spx_components_stock_price.reg

  • 62.2 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)71.3700027465820371.3700027465820371.3700027465820370.1299972534179770.129997253417976513
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)69.9400024414062569.9400024414062569.9550018310546969.849998474121169.8499984741211519
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)70.3099975585937570.3099975585937570.4100036621093870.0800018310546970.080001831054692487
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)70.4049987792968870.4049987792968870.4700012207031270.349998474121170.3499984741211926
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)70.3000030517578170.3000030517578170.3199996948242270.3000030517578170.319999694824221294
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)70.1200027465820370.1200027465820370.2450027465820370.1200027465820370.24500274658203863
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)69.9599990844726669.9599990844726670.099998474121169.9100036621093869.910003662109383199
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)69.9150009155273469.9150009155273469.9899978637695369.9100036621093869.919998168945312549
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)69.956398010253969.956398010253970.0500030517578169.956398010253969.98999786376953680
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)70.099998474121170.099998474121170.099998474121170.0699996948242270.06999969482422537

CREATE TABLE reg (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);