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

Syy
@kaggle.benjaminpo_sp500_spx_components_stock_price.syy

  • 63.54 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)75.349998474121175.349998474121175.8000030517578174.8000030517578175.03500366210938155715
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)76.0950012207031276.0950012207031276.4199981689453175.349998474121175.5699996948242284505
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)76.5899963378906276.5899963378906276.8000030517578175.9899978637695376.0950012207031232559
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)76.0899963378906276.0899963378906276.519996643066475.9899978637695376.400001525878951249
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)75.7099990844726675.7099990844726676.3799972534179775.7099990844726676.1699981689453137784
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)75.7149963378906275.7149963378906275.900001525878975.2575.900001525878926035
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)75.5100021362304775.5100021362304775.7799987792968875.4414978027343875.7799987792968812973
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)75.8899993896484475.8899993896484476.1600036621093875.4899978637695375.5500030517578138850
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)76.2600021362304776.2600021362304776.349998474121175.599998474121175.7900009155273436598
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)76.3000030517578176.3000030517578176.5800018310546975.980003356933676.2799987792968842032

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