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

Gbpusd X
@kaggle.benjaminpo_sp500_spx_components_stock_price.gbpusd_x

  • 167.43 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)1.3533630371093751.3533630371093751.3533630371093751.3533630371093751.353363037109375
Mon Feb 07 2022 00:01:00 GMT+0000 (Coordinated Universal Time)1.35321664810180661.35321664810180661.35321664810180661.35321664810180661.3532166481018066
Mon Feb 07 2022 00:02:00 GMT+0000 (Coordinated Universal Time)1.3533630371093751.3533630371093751.3533630371093751.3533630371093751.353363037109375
Mon Feb 07 2022 00:03:00 GMT+0000 (Coordinated Universal Time)1.35283219814300541.35283219814300541.35283219814300541.35283219814300541.3528321981430054
Mon Feb 07 2022 00:04:00 GMT+0000 (Coordinated Universal Time)1.3531433343887331.3531433343887331.3531433343887331.3531433343887331.353143334388733
Mon Feb 07 2022 00:05:00 GMT+0000 (Coordinated Universal Time)1.35316169261932351.35316169261932351.35316169261932351.35316169261932351.3531616926193235
Mon Feb 07 2022 00:06:00 GMT+0000 (Coordinated Universal Time)1.3532348871231081.3532348871231081.3532348871231081.3532348871231081.353234887123108
Mon Feb 07 2022 00:07:00 GMT+0000 (Coordinated Universal Time)1.35332655906677251.35332655906677251.35332655906677251.35332655906677251.3533265590667725
Mon Feb 07 2022 00:08:00 GMT+0000 (Coordinated Universal Time)
Mon Feb 07 2022 00:09:00 GMT+0000 (Coordinated Universal Time)1.35325312614440921.35325312614440921.35325312614440921.35325312614440921.3532531261444092

CREATE TABLE gbpusd_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.