Baselight
Sign In

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

Msci
@kaggle.benjaminpo_sp500_spx_components_stock_price.msci

  • 71.41 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)532.719970703125532.719970703125534.9099731445312527.6199951171875528.940002441406252322
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)534.0599975585938534.0599975585938534.9099731445312534.0599975585938534.78997802734381545
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)534.239990234375534.239990234375536.0399780273438530.3699951171875533.929992675781232864
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)532.1699829101562532.1699829101562533.1599731445312532.1699829101562532.48327636718751810
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)532.6900024414062532.6900024414062533.9000244140625531.6199951171875533.84997558593751805
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)536536536533.9400024414062533.979980468753033
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)537.3499755859375537.3499755859375537.3499755859375536.5399780273438536.53997802734381107
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)536.5499877929688536.5499877929688537.094970703125536.5499877929688537.0949707031251093
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)535.87158203125535.87158203125537.5798950195312535.87158203125537.5798950195312410
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)536.5499877929688536.5499877929688537.3300170898438536.0999755859375536.58502197265621594

CREATE TABLE msci (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);