Baselight
Sign In

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

Ato
@kaggle.benjaminpo_sp500_spx_components_stock_price.ato

  • 59.8 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)106.5999984741211106.5999984741211106.62999725341795106.25106.2517022
Tue Feb 08 2022 14:31:00 GMT+0000 (Coordinated Universal Time)
Tue Feb 08 2022 14:32:00 GMT+0000 (Coordinated Universal Time)106.16999816894533106.16999816894533106.16999816894533106.16999816894533106.16999816894533400
Tue Feb 08 2022 14:33:00 GMT+0000 (Coordinated Universal Time)105.9800033569336105.9800033569336106.0999984741211105.9800033569336106.01000213623048972
Tue Feb 08 2022 14:34:00 GMT+0000 (Coordinated Universal Time)106.13999938964844106.13999938964844106.13999938964844106.12999725341795106.129997253417951571
Tue Feb 08 2022 14:35:00 GMT+0000 (Coordinated Universal Time)106.11000061035156106.11000061035156106.12000274658205106.0199966430664106.120002746582051531
Tue Feb 08 2022 14:36:00 GMT+0000 (Coordinated Universal Time)106.04000091552734106.04000091552734106.0999984741211106.0199966430664106.09999847412111151
Tue Feb 08 2022 14:37:00 GMT+0000 (Coordinated Universal Time)106.0250015258789106.0250015258789106.08000183105467106.0250015258789106.08000183105467718
Tue Feb 08 2022 14:38:00 GMT+0000 (Coordinated Universal Time)105.97000122070312105.97000122070312106.0250015258789105.97000122070312106.0250015258789425
Tue Feb 08 2022 14:39:00 GMT+0000 (Coordinated Universal Time)106.27999877929688106.27999877929688106.3000030517578106.04499816894533106.059997558593766843

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