Baselight
Sign In

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

Fmc
@kaggle.benjaminpo_sp500_spx_components_stock_price.fmc

  • 65.54 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)108.45500183105467108.45500183105467108.7300033569336108.45500183105467108.73000335693367278
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)108.7699966430664108.7699966430664108.7699966430664108.56999969482422108.56999969482422623
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)108.5199966430664108.5199966430664108.83999633789062108.51000213623048108.839996337890621040
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)108.58000183105467108.58000183105467108.58000183105467108.54000091552734108.54000091552734782
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)108.2300033569336108.2300033569336108.2300033569336108.2300033569336108.230003356933619
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)108.83000183105467108.83000183105467108.83000183105467108.7300033569336108.7300033569336879
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)108.93499755859376108.93499755859376108.93499755859376108.83999633789062108.83999633789062626

CREATE TABLE fmc (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);