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

Sjm
@kaggle.benjaminpo_sp500_spx_components_stock_price.sjm

  • 56.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)137.3300018310547137.3300018310547137.3300018310547137.02499389648438137.024993896484387959
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)137.39999389648438137.39999389648438137.39999389648438137.32000732421875137.320007324218751386
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)137.19000244140625137.19000244140625137.19000244140625137.1699981689453137.17999267578125718
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)137.44000244140625137.44000244140625137.44000244140625137.36000061035156137.3699951171875902
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)137.22000122070312137.22000122070312137.22000122070312137.22000122070312137.22000122070312756
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)136.98500061035156136.98500061035156137.1999969482422136.98500061035156137.1999969482422750
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)137.10000610351562137.10000610351562137.2100067138672136.9949951171875137.110000610351562080
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)137.2010040283203137.2010040283203137.32000732421875137.2010040283203137.30000305175782998
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)137.43499755859375137.43499755859375137.44000244140625137.43499755859375137.44000244140625803

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