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

Ctxs
@kaggle.benjaminpo_sp500_spx_components_stock_price.ctxs

  • 45.87 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)102.16999816894533102.16999816894533102.22000122070312101.95999908447266102.1299972534179515594
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)102.27999877929688102.27999877929688102.29000091552734102.12999725341795102.139999389648447008
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)102.22000122070312102.22000122070312102.29000091552734102.20999908447266102.290000915527348081
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)102.16000366210938102.16000366210938102.2125015258789102.16000366210938102.209999084472663035
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)102.19000244140624102.19000244140624102.2300033569336102.16000366210938102.199996948242215459
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)102.13999938964844102.13999938964844102.1999969482422102.11000061035156102.199996948242222956
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)102.1050033569336102.1050033569336102.1500015258789102.1050033569336102.110000610351561900
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)102.1500015258789102.1500015258789102.1999969482422102.12999725341795102.1800003051757811271
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)102.12000274658205102.12000274658205102.12999725341795102.12000274658205102.12999725341795771
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)102.16999816894533102.16999816894533102.1999969482422102.13999938964844102.1900024414062410688

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