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

Aon
@kaggle.benjaminpo_sp500_spx_components_stock_price.aon

  • 74.09 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)284.5899963378906284.5899963378906285.2650146484375283.7799987792969284.3500061035156135632
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)284.3599853515625284.3599853515625285.3599853515625284.1099853515625284.825012207031253766
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)284.05499267578125284.05499267578125284.1499938964844283.44000244140625284.13000488281251184
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)283.5950012207031283.5950012207031283.8299865722656282.9100036621094283.82998657226561815
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)282.8500061035156282.8500061035156283.94000244140625281.8999938964844281.89999389648444087
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)281.9100036621094281.9100036621094282.5299987792969281.9100036621094282.52999877929691194
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)281.44000244140625281.44000244140625282.6391906738281281.2200012207031282.63919067382814197
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)281.4100036621094281.4100036621094281.760009765625281.19000244140625281.7600097656251338
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)280.54998779296875280.54998779296875281.6600036621094280.54998779296875281.42001342773443922
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)280.1300048828125280.1300048828125280.8599853515625279.8500061035156280.859985351562510311

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