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

Ter
@kaggle.benjaminpo_sp500_spx_components_stock_price.ter

  • 73.5 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)113.70999908447266113.70999908447266113.73999786376952113.25113.2525348
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)114.22000122070312114.22000122070312114.4800033569336113.91999816894533113.919998168945331938
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)113.70999908447266113.70999908447266114.58000183105467113.70999908447266114.580001831054673695
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)113.54000091552734113.54000091552734113.81999969482422113.54000091552734113.819999694824225617
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)113.5500030517578113.5500030517578113.69000244140624113.5199966430664113.669998168945333637
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)113.81999969482422113.81999969482422113.9499969482422113.6999969482422113.69999694824223442
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)113.91500091552734113.91500091552734114.12999725341795113.79000091552734113.794998168945335357
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)114.18000030517578114.18000030517578114.18000030517578113.77999877929688113.779998779296882691
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)114.12000274658205114.12000274658205114.30999755859376114.12000274658205114.26429748535156422
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)114.05999755859376114.05999755859376114.1500015258789114.05999755859376114.110000610351563754

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