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

Jci
@kaggle.benjaminpo_sp500_spx_components_stock_price.jci

  • 60.15 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)66.9700012207031266.9700012207031267.0400009155273466.8000030517578166.8000030517578140763
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)66.7799987792968866.7799987792968867.0100021362304766.7600021362304767.0100021362304710925
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)66.9700012207031266.9700012207031266.9700012207031266.8600006103515666.879997253417972194
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)66.730003356933666.730003356933666.9899978637695366.730003356933666.989997863769537551
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)66.6900024414062566.6900024414062566.7799987792968866.650001525878966.779998779296887265
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)66.6399993896484466.6399993896484466.7200012207031266.6399993896484466.690002441406259540
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)66.5899963378906266.5899963378906266.6800003051757866.5500030517578166.6299972534179729066
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)66.400001525878966.400001525878966.5899963378906266.3799972534179766.589996337890624287
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)66.3799972534179766.3799972534179766.4700012207031266.349998474121166.40000152587896329
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)66.3799972534179766.3799972534179766.4499969482421966.3300018310546966.4100036621093810893

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