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

Viac
@kaggle.benjaminpo_sp500_spx_components_stock_price.viac

  • 62.51 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)33.8300018310546933.8300018310546934.1699981689453133.8300018310546934.0200004577636794509
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)33.77999877929687533.77999877929687533.90000152587890633.77999877929687533.839000701904342053
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)33.65000152587890633.65000152587890633.88000106811523433.65000152587890633.79000091552734418058
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)33.7910003662109433.7910003662109433.81000137329101633.6599998474121133.6599998474121112734
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)33.77999877929687533.77999877929687533.8199996948242233.74499893188476633.81000137329101617721
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)33.8300018310546933.8300018310546933.9099998474121133.77999877929687533.7799987792968759536
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)33.8199996948242233.8199996948242233.8300018310546933.759998321533233.8300018310546914834
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)33.9099998474121133.9099998474121133.92119979858398433.8400001525878933.88000106811523429682
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)33.8300018310546933.8300018310546933.9300003051757833.8199996948242233.9199981689453150497
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)33.86999893188476633.86999893188476633.90000152587890633.8300018310546933.8400001525878911222

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