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

Pki
@kaggle.benjaminpo_sp500_spx_components_stock_price.pki

  • 63.92 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)
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)181.18499755859372181.18499755859372181.18499755859372181.18499755859372181.18499755859372225
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)181.1649932861328181.1649932861328181.1649932861328181.1649932861328181.1649932861328100
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)181.16000366210935181.16000366210935181.17999267578125181.16000366210935181.179992675781251046
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)180.66000366210935180.66000366210935180.66000366210935180.66000366210935180.66000366210935326
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)181.1699981689453181.1699981689453181.1699981689453180.7100067138672181.02000427246092358
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)181.5399932861328181.5399932861328181.5399932861328181.5399932861328181.5399932861328107
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)181.83999633789065181.83999633789065181.83999633789065181.22999572753903181.565002441406252684
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)181.6300048828125181.6300048828125181.6300048828125181.625181.625218

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