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

Ir
@kaggle.benjaminpo_sp500_spx_components_stock_price.ir

  • 55.59 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)54.72000122070312554.72000122070312554.7799987792968854.65000152587890654.740001678466818791
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)54.6899986267089854.6899986267089854.81000137329101654.6699981689453154.759998321533214406
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)54.70999908447265654.70999908447265654.8600006103515654.70999908447265654.770000457763676711
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)54.5999984741210954.5999984741210954.7799987792968854.5999984741210954.779998779296882591
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)54.61999893188476654.61999893188476654.61999893188476654.61999893188476654.619998931884766105
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)54.5900001525878954.5900001525878954.70999908447265654.5900001525878954.63499832153326765
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)54.63000106811523454.63000106811523454.65000152587890654.5900001525878954.590000152587892964
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)54.5299987792968854.5299987792968854.66500091552734454.554.66500091552734411217
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)54.554.554.5499992370605554.47000122070312554.529998779296882591
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)54.4300003051757854.4300003051757854.47000122070312554.4300003051757854.4700012207031251379

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