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

Blk
@kaggle.benjaminpo_sp500_spx_components_stock_price.blk

  • 80.47 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)815.5999755859375815.5999755859375815.97998046875815.5999755859375815.9799804687590087
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)815.4400024414062815.4400024414062816815.4400024414062815.770019531251903
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)812.02001953125812.02001953125812.5999755859375812.02001953125812.1699829101562914
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)813.9149780273438813.9149780273438814.8956298828125812.0499877929688812.64001464843751976
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)813.7100219726562813.7100219726562814.5399780273438812.989990234375813.2800292968754229
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)813.1699829101562813.1699829101562813.3200073242188813.0687866210938813.0687866210938861
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)813.405029296875813.405029296875814.280029296875813.3200073242188814.20001220703122339

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