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

Lin
@kaggle.benjaminpo_sp500_spx_components_stock_price.lin

  • 78.28 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)296.4049987792969296.4049987792969296.7300109863281296.19000244140625296.519989013671948909
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)296.3299865722656296.3299865722656296.6499938964844296.3299865722656296.41000366210945355
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)296.1000061035156296.1000061035156296.4200134277344296.0400085449219296.350006103515610041
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)295.6199951171875295.6199951171875296.20001220703125295.6000061035156296.14999389648445857
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)295.5950012207031295.5950012207031295.8699951171875295.57000732421875295.73999023437523856
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)295.7300109863281295.7300109863281295.9100036621094295.5799865722656295.57998657226566074
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)295.8699951171875295.8699951171875296295.7550048828125295.79501342773445577
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)295.739990234375295.739990234375296.1050109863281295.739990234375296.02499389648447016
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)295.7550048828125295.7550048828125295.7550048828125295.3999938964844295.64001464843754175
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)295.70001220703125295.70001220703125295.7850036621094295.6400146484375295.679992675781254719

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