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

Psx
@kaggle.benjaminpo_sp500_spx_components_stock_price.psx

  • 64.39 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)89.9100036621093889.9100036621093890.0950012207031289.3600006103515689.4499969482421949207
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)89.980003356933689.980003356933689.980003356933689.730003356933689.889999389648447981
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)89.6299972534179789.6299972534179789.8700027465820389.589.864997863769534113
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)89.4300994873046989.4300994873046989.7900009155273489.3099975585937589.6600036621093810287
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)89.4700012207031289.4700012207031289.7099990844726689.4700012207031289.709999084472662748
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)89.4400024414062589.4400024414062589.650001525878989.4400024414062589.440002441406253769
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)89.4899978637695389.4899978637695389.5800018310546989.3300018310546989.330001831054698316
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)89.4199981689453189.4199981689453189.589.3199996948242289.449996948242193143
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)89.6999969482421989.6999969482421989.7099990844726689.5400009155273489.64489746093755524
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)89.8899002075195389.8899002075195389.8899002075195389.5899963378906289.699996948242198291

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