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

Aee
@kaggle.benjaminpo_sp500_spx_components_stock_price.aee

  • 55.53 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)87.6999969482421987.6999969482421987.6999969482421987.6999969482421987.699996948242196152
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)87.5849990844726687.5849990844726687.5849990844726687.5849990844726687.584999084472661026
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)87.400001525878987.400001525878987.4899978637695387.349998474121187.430000305175783859
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)87.2350006103515687.2350006103515687.2900009155273487.1600036621093887.290000915527347346
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)87.2200012207031287.2200012207031287.2200012207031287.2200012207031287.22000122070312100
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)87.3199996948242287.3199996948242287.4100036621093887.275001525878987.27500152587891167
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)87.2850036621093887.2850036621093887.3700027465820387.2850036621093887.3499984741211706

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