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

Rol
@kaggle.benjaminpo_sp500_spx_components_stock_price.rol

  • 49.92 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)30.35000038146972730.35000038146972730.379999160766630.35000038146972730.37999916076669064
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)30.35000038146972730.35000038146972730.3899993896484430.3400001525878930.38999938964844607
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)30.3600006103515630.3600006103515630.3600006103515630.3600006103515630.36000061035156211
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)30.2849998474121130.2849998474121130.30999946594238330.2849998474121130.2999992370605471603
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)30.28000068664550830.28000068664550830.29000091552734430.2530.264999389648442808
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)30.3400001525878930.3400001525878930.370000839233430.30999946594238330.37000083923341386
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)30.31500053405761730.31500053405761730.31500053405761730.31500053405761730.315000534057617997
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)30.3199996948242230.3199996948242230.3199996948242230.30999946594238330.309999465942383333
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)30.29500007629394530.29500007629394530.3199996948242230.29000091552734430.319999694824227268

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