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

Pxd
@kaggle.benjaminpo_sp500_spx_components_stock_price.pxd

  • 75.14 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)224.9499969482422224.9499969482422225.5224.84500122070312225.130004882812525095
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)225.16000366210935225.16000366210935225.16000366210935224.3999938964844224.69999694824224808
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)224.84500122070312224.84500122070312226224.6000061035156224.970001220703125869
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)224.6499938964844224.6499938964844225.1000061035156224.25224.44999694824228199
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)224.67999267578125224.67999267578125225.0500030517578224.67999267578125225.05000305175781483
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)224.25224.25224.50999450683597224.25224.252371
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)223.83999633789065223.83999633789065224.1150054931641223.58999633789065224.11500549316415177
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)223.7250061035156223.7250061035156223.9600067138672223.7050018310547223.839996337890651936
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)223.7924041748047223.7924041748047223.7924041748047223.47999572753903223.617004394531253323
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)223.8699951171875223.8699951171875223.8699951171875223.33999633789065223.690002441406254216

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