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

Lh
@kaggle.benjaminpo_sp500_spx_components_stock_price.lh

  • 74.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)275.1099853515625275.1099853515625275.1099853515625273.29998779296875273.47000122070314709
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)273.2200012207031273.2200012207031273.75273.1700134277344273.753738
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)273.1000061035156273.1000061035156274.9100036621094273.0799865722656273.220001220703110554
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)274.0299987792969274.0299987792969274.0299987792969273.79998779296875273.79998779296875595
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)274.67999267578125274.67999267578125274.67999267578125272.8800048828125274.45999145507811612
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)274.5274.5275.2850036621094274.5275.27999877929692429
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)274.5274.5274.5274.5274.5227
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)274.45001220703125274.45001220703125274.4549865722656274.3900146484375274.3900146484375660
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)274.45001220703125274.45001220703125274.6700134277344274.3299865722656274.440002441406251513

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