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

Mck
@kaggle.benjaminpo_sp500_spx_components_stock_price.mck

  • 74.29 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)269.6000061035156269.6000061035156271.5269.6000061035156271.550841
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)270.17999267578125270.17999267578125271.6099853515625270.17999267578125271.60998535156251602
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)271.7300109863281271.7300109863281272.1549987792969270.95001220703125270.950012207031257100
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)271.67999267578125271.67999267578125272.2799987792969271.04998779296875271.85000610351562344
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)271.3299865722656271.3299865722656271.7099914550781271.3099975585937271.35998535156251822
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)271.2200012207031271.2200012207031271.489990234375270.8500061035156271.38000488281254497
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)271.95001220703125271.95001220703125271.95001220703125271.3349914550781271.33499145507811979
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)271.0599975585937271.0599975585937271.7699890136719271.0599975585937271.76998901367191334
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)271.6199951171875271.6199951171875271.6199951171875270.92999267578125270.929992675781252462
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)271.4700012207031271.4700012207031271.7699890136719271.4700012207031271.7699890136719903

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