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

Pnc
@kaggle.benjaminpo_sp500_spx_components_stock_price.pnc

  • 67.55 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)212.6100006103516212.6100006103516213.17999267578125212.13999938964844212.13999938964844273389
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)212.5399932861328212.5399932861328212.9600067138672212.31500244140625212.315002441406252657
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)212.0500030517578212.0500030517578212.2100067138672212.0500030517578212.21000671386721624
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)212.05999755859372212.05999755859372212.05999755859372211.82000732421875211.86000061035163483
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)212.6100006103516212.6100006103516212.6100006103516212.06500244140625212.065002441406251379
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)212.0800018310547212.0800018310547212.4600067138672212.0800018310547212.46000671386722234
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)212.27999877929688212.27999877929688212.27999877929688212.27999877929688212.27999877929688504
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)212.1499938964844212.1499938964844212.3999938964844212.0500030517578212.339996337890659210
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)211.97999572753903211.97999572753903212.3800048828125211.8800048828125212.22500610351565138
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)211.91000366210935211.91000366210935212.1199951171875211.91000366210935212.1199951171875851

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