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

Pld
@kaggle.benjaminpo_sp500_spx_components_stock_price.pld

  • 69.34 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)152.61000061035156152.61000061035156152.7899932861328152.22999572753906152.5899963378906221163
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)152.25152.25152.7899932861328152.22000122070312152.44999694824228656
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)152.52000427246094152.52000427246094152.69000244140625152.44000244140625152.440002441406256028
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)152.18499755859375152.18499755859375152.8300018310547152.1699981689453152.63000488281257465
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)151.9600067138672151.9600067138672152.3300018310547151.91000366210938152.240005493164068927
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)151.6999969482422151.6999969482422151.97000122070312151.58999633789062151.94999694824228540
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)151.60000610351562151.60000610351562151.86000061035156151.60000610351562151.809997558593754554
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)151.6199951171875151.6199951171875151.75999450683594151.5500030517578151.58000183105472591
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)151.9600067138672151.9600067138672152.00999450683594151.6199951171875151.61999511718752473
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)151.86000061035156151.86000061035156152.11000061035156151.85000610351562152.059997558593753603

CREATE TABLE pld (
  "datetime" TIMESTAMP,
  "adj_close" DOUBLE,
  "close" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "volume" DOUBLE
);