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

Pbct
@kaggle.benjaminpo_sp500_spx_components_stock_price.pbct

  • 50.09 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)20.8199996948242220.8199996948242220.95000076293945320.8199996948242220.940000534057617299666
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)20.879999160766620.879999160766620.9099998474121120.8400001525878920.840000152587891523
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)20.879999160766620.879999160766620.879999160766620.78000068664550820.85000038146972717862
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)20.8798999786376920.8798999786376920.89999961853027720.8400001525878920.8757635
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)20.9300003051757820.9300003051757820.93050003051757520.879999160766620.87999916076663779
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)20.85000038146972720.85000038146972720.9300003051757820.85000038146972720.909999847412115218
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)20.8400001525878920.8400001525878920.8600006103515620.8299999237060520.8500003814697272966
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)20.85499954223632820.85499954223632820.86499977111816420.8400001525878920.840000152587894903
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)20.870000839233420.870000839233420.870000839233420.8400001525878920.840000152587895304
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)20.85000038146972720.85000038146972720.879999160766620.85000038146972720.87999916076662341

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