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

Jpy X
@kaggle.benjaminpo_sp500_spx_components_stock_price.jpy_x

  • 180.17 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)115.24700164794922115.24700164794922115.25115.19000244140624115.22799682617188
Mon Feb 07 2022 00:01:00 GMT+0000 (Coordinated Universal Time)115.23999786376952115.23999786376952115.25700378417967115.20999908447266115.24700164794922
Mon Feb 07 2022 00:02:00 GMT+0000 (Coordinated Universal Time)115.25115.25115.26100158691406115.22000122070312115.24400329589844
Mon Feb 07 2022 00:03:00 GMT+0000 (Coordinated Universal Time)115.23799896240234115.23799896240234115.25115.1999969482422115.2490005493164
Mon Feb 07 2022 00:04:00 GMT+0000 (Coordinated Universal Time)115.22000122070312115.22000122070312115.24099731445312115.18000030517578115.2300033569336
Mon Feb 07 2022 00:05:00 GMT+0000 (Coordinated Universal Time)115.197998046875115.197998046875115.22000122070312115.16999816894533115.21399688720705
Mon Feb 07 2022 00:06:00 GMT+0000 (Coordinated Universal Time)115.18499755859376115.18499755859376115.2030029296875115.1500015258789115.1999969482422
Mon Feb 07 2022 00:07:00 GMT+0000 (Coordinated Universal Time)115.19400024414062115.19400024414062115.19499969482422115.16000366210938115.18499755859376
Mon Feb 07 2022 00:08:00 GMT+0000 (Coordinated Universal Time)115.19300079345705115.19300079345705115.197998046875115.1500015258789115.19000244140624
Mon Feb 07 2022 00:09:00 GMT+0000 (Coordinated Universal Time)115.19000244140624115.19000244140624115.1999969482422115.16000366210938115.19000244140624

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