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

Irm
@kaggle.benjaminpo_sp500_spx_components_stock_price.irm

  • 57.93 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)45.0900001525878945.0900001525878945.2299995422363345.009998321533245.2000007629394544638
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)44.9420013427734444.9420013427734445.06000137329101644.9199981689453145.06000137329101629577
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)44.8899993896484444.8899993896484444.9799995422363344.8899993896484444.9000015258789067218
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)44.76010131835937544.76010131835937544.88000106811523444.70999908447265644.88000106811523415651
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)44.80450057983398444.80450057983398444.81000137329101644.7939987182617244.793998718261721593
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)44.6899986267089844.6899986267089844.7718009948730544.6799011230468844.755405
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)44.7686004638671944.7686004638671944.81000137329101644.6899986267089844.689998626708984967
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)44.7350006103515644.7350006103515644.7350006103515644.7350006103515644.73500061035156634
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)44.812999725341844.812999725341844.812999725341844.7109985351562544.710998535156252485
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)44.8400001525878944.8400001525878944.88000106811523444.8300018310546944.849998474121094065

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