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

Avy
@kaggle.benjaminpo_sp500_spx_components_stock_price.avy

  • 65.43 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)181.69500732421875181.69500732421875181.6999969482422181.4600067138672181.460006713867211103
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)182.15499877929688182.15499877929688182.15499877929688181.72999572753903181.9550018310547758
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)182.47000122070312182.47000122070312182.47000122070312182.4499969482422182.4499969482422363
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)182.8999938964844182.8999938964844182.8999938964844182.8999938964844182.8999938964844268
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)181.6450042724609181.6450042724609181.7100067138672181.6450042724609181.6499938964844786
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)181.58999633789065181.58999633789065181.58999633789065181.58999633789065181.58999633789065237
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)180.27999877929688180.27999877929688181.07000732421875180.27999877929688181.070007324218753076
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)179.8300018310547179.8300018310547180.3999938964844179.36000061035156180.39999389648442665

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