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

Zts
@kaggle.benjaminpo_sp500_spx_components_stock_price.zts

  • 69.57 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)198.9600067138672198.9600067138672199.7100067138672198.8800048828125198.8800048828125213416
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)198.7749938964844198.7749938964844199.0399932861328198.7749938964844199.03999328613283446
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)199.11749267578125199.11749267578125199.25198.7519989013672198.940002441406254651
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)199.3300018310547199.3300018310547199.3300018310547199.0050048828125199.0599975585937213814
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)199.2100067138672199.2100067138672199.5500030517578199.0500030517578199.33000183105476573
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)199.3600006103516199.3600006103516199.4199981689453199.1499938964844199.14999389648442285
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)199.25199.25199.27999877929688199.1100006103516199.11000061035165470
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)199.21499633789065199.21499633789065199.3600006103516199.1699981689453199.258976
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)199.25199.25199.27999877929688199.0500030517578199.08000183105472940
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)199.21499633789065199.21499633789065199.42999267578125199.2001037597656199.33000183105477032

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