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

Aph
@kaggle.benjaminpo_sp500_spx_components_stock_price.aph

  • 62.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)77.7949981689453177.7949981689453178.0550003051757877.7399978637695377.900001525878936470
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)77.7649993896484477.7649993896484477.849998474121177.6900024414062577.73000335693368638
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)77.7577.7577.8099975585937577.650001525878977.809997558593758130
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)77.6800003051757877.6800003051757877.8700027465820377.6200027465820377.794998168945317843
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)77.4899978637695377.4899978637695377.6100006103515677.4899978637695377.610000610351562178
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)77.3600006103515677.3600006103515677.5299987792968877.2900009155273477.519996643066412128
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)77.355003356933677.355003356933677.4199981689453177.2900009155273477.34999847412115847
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)77.3099975585937577.3099975585937577.4300003051757877.3099975585937577.309997558593754377
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)77.1900024414062577.1900024414062577.355003356933677.1900024414062577.3099975585937510006
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)77.230003356933677.230003356933677.2577.1699981689453177.1699981689453121490

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