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

Trow
@kaggle.benjaminpo_sp500_spx_components_stock_price.trow

  • 73.35 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)151.99000549316406151.99000549316406152.63710021972656151.55999755859375151.82000732421875150727
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)151.2050018310547151.2050018310547151.77999877929688151.1300048828125151.779998779296882520
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)150.64999389648438150.64999389648438151.57000732421875150.3699951171875151.179992675781255252
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)150.8000030517578150.8000030517578150.94000244140625150.64999389648438150.83000183105473270
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)150.75150.75150.91270446777344150.75150.912704467773441971
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)151.16000366210938151.16000366210938151.25999450683594151.0399932861328151.059997558593755127
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)151.35000610351562151.35000610351562151.35000610351562151.0301055908203151.03010559082035452
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)151.66000366210938151.66000366210938151.66000366210938151.4600067138672151.46000671386721407
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)151.72000122070312151.72000122070312151.72000122070312151.72000122070312151.720001220703122756
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)151.55999755859375151.55999755859375151.81500244140625151.55999755859375151.695007324218751557

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