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

Uri
@kaggle.benjaminpo_sp500_spx_components_stock_price.uri

  • 73.3 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)318.7099914550781318.7099914550781318.7099914550781317.8099975585937318.36999511718759515
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)319.5319.5319.7749938964844318.79998779296875319.57998657226562191
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)318.07000732421875318.07000732421875319.489990234375318.07000732421875319.440002441406251371
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)318.5299987792969318.5299987792969318.5299987792969317.364990234375318.14999389648441901
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)318.95001220703125318.95001220703125319.1499938964844318.9349975585937318.9700012207031616
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)318.8999938964844318.8999938964844318.8999938964844318.5299987792969318.5299987792969868
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)319.3999938964844319.3999938964844319.3999938964844319.32000732421875319.32000732421875417
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)319.3999938964844319.3999938964844319.3999938964844319.3999938964844319.3999938964844139
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)318.8399963378906318.8399963378906319.260009765625318.8399963378906319.260009765625892

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