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

Awk
@kaggle.benjaminpo_sp500_spx_components_stock_price.awk

  • 68.72 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)155.6199951171875155.6199951171875155.9550018310547155.5155.59726
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)155.23500061035156155.23500061035156155.4199981689453155.23500061035156155.4199981689453827
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)155.52999877929688155.52999877929688155.52999877929688155.19000244140625155.360000610351562314
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)155.5399932861328155.5399932861328155.5399932861328155.5399932861328155.5399932861328435
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)155.6750030517578155.6750030517578155.8800048828125155.59500122070312155.59500122070312916
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)155.9600067138672155.9600067138672155.9600067138672155.82000732421875155.82000732421875763
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)155.77000427246094155.77000427246094155.86000061035156155.63999938964844155.660003662109381556
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)155.86000061035156155.86000061035156155.94000244140625155.84500122070312155.84500122070312432
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)155.7550048828125155.7550048828125155.7550048828125155.74000549316406155.751137

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