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

Frt
@kaggle.benjaminpo_sp500_spx_components_stock_price.frt

  • 61.58 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)123.11000061035156123.11000061035156123.11000061035156123.11000061035156123.110000610351562754
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)122.87999725341795122.87999725341795122.9000015258789122.87999725341795122.9000015258789258
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)122.7300033569336122.7300033569336123.08000183105467122.7300033569336123.08000183105467783
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)122.8000030517578122.8000030517578123.0199966430664122.58999633789062122.870002746582051249
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)122.75122.75122.98999786376952122.75122.98999786376952872

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