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

Gbpjpy X
@kaggle.benjaminpo_sp500_spx_components_stock_price.gbpjpy_x

  • 208.02 KB
  • 9695 rows
  • 7 columns
datetime

Datetime

adj_close

Adj Close

close

Close

high

High

low

Low

open

Open

volume

Volume

Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)155.95399475097656155.95399475097656155.96200561523438155.89999389648438155.927001953125
Mon Feb 07 2022 00:01:00 GMT+0000 (Coordinated Universal Time)155.94700622558594155.94700622558594155.96200561523438155.91900634765625155.95399475097656
Mon Feb 07 2022 00:02:00 GMT+0000 (Coordinated Universal Time)155.9429931640625155.9429931640625155.95799255371094155.9199981689453155.94500732421875
Mon Feb 07 2022 00:03:00 GMT+0000 (Coordinated Universal Time)155.91799926757812155.91799926757812155.94900512695312155.88699340820312155.94900512695312
Mon Feb 07 2022 00:04:00 GMT+0000 (Coordinated Universal Time)155.89500427246094155.89500427246094155.92599487304688155.8699951171875155.91900634765625
Mon Feb 07 2022 00:05:00 GMT+0000 (Coordinated Universal Time)155.86900329589844155.86900329589844155.89700317382812155.85000610351562155.89599609375
Mon Feb 07 2022 00:06:00 GMT+0000 (Coordinated Universal Time)155.86300659179688155.86300659179688155.87600708007812155.82000732421875155.875
Mon Feb 07 2022 00:07:00 GMT+0000 (Coordinated Universal Time)155.88900756835938155.88900756835938155.90899658203125155.83999633789062155.8699951171875
Mon Feb 07 2022 00:08:00 GMT+0000 (Coordinated Universal Time)155.86900329589844155.86900329589844155.89100646972656155.8300018310547155.8699951171875
Mon Feb 07 2022 00:09:00 GMT+0000 (Coordinated Universal Time)155.87100219726562155.87100219726562155.89599609375155.85000610351562155.8730010986328

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