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

Coo
@kaggle.benjaminpo_sp500_spx_components_stock_price.coo

  • 52.43 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)
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)392.5549926757813392.5549926757813393.3200073242188389.2349853515625393.320007324218812134
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)394.0799865722656394.0799865722656394.0799865722656392.885009765625392.8850097656256102
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)392.3949890136719392.3949890136719394.6000061035156392.3399963378906394.26998901367194704
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)393.6300048828125393.6300048828125395.0499877929688393.6300048828125395.0499877929688665
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)393.414306640625393.414306640625393.7950134277344392.7999877929688392.7999877929688801
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)392.9800109863281392.9800109863281393.0400085449219391.2000122070313392.16000366210942148
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)392.4599914550781392.4599914550781392.5899963378906392.4599914550781392.58999633789063269

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