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

Kim
@kaggle.benjaminpo_sp500_spx_components_stock_price.kim

  • 53.84 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)23.97999954223632823.97999954223632824.0900001525878923.89999961853027724.0799999237060538777
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)24.0100002288818424.0100002288818424.0100002288818423.97999954223632823.9799995422363286188
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)24.10000038146972724.10000038146972724.10000038146972724.04000091552734424.0499992370605478543
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)24.14999961853027724.14999961853027724.1800003051757824.10000038146972724.13699913024902318588
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)24.1399993896484424.1399993896484424.1599998474121124.120000839233424.159999847412116904
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)24.05999946594238324.05999946594238324.1399993896484424.04999923706054724.1350002288818410647
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)23.95000076293945323.95000076293945324.05999946594238323.95000076293945324.05999946594238310590
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)23.92000007629394523.92000007629394523.95000076293945323.92000007629394523.9249992370605476468
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)23.94000053405761723.94000053405761723.94000053405761723.8899993896484423.92000007629394511738
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)23.95000076293945323.95000076293945323.995000839233423.95000076293945323.95000076293945311337

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