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

Rop
@kaggle.benjaminpo_sp500_spx_components_stock_price.rop

  • 65.05 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)441.5849914550781441.5849914550781442.989990234375440.9599914550781441.82998657226567662
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)439.0650024414063439.0650024414063441.7000122070313439.0650024414063441.04998779296882264
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)439.1950073242188439.1950073242188439.989990234375439.1950073242188439.989990234375260
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)438.5729064941406438.5729064941406438.6549987792969437.1300048828125438.42001342773441593
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)439.0150146484375439.0150146484375439.0150146484375439.0150146484375439.0150146484375119
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)440440440437.9599914550781439.7000122070313790
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)440.5299987792969440.5299987792969440.5299987792969439.33999633789064402476
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)439.6600036621094439.6600036621094441.9100036621094439.6600036621094441.5199890136719874
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)440.8900146484375440.8900146484375440.8900146484375440.7950134277344440.7950134277344597
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)440.8999938964844440.8999938964844440.8999938964844440.8999938964844440.8999938964844231

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