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

Etf
@kaggle.benjaminpo_sp500_spx_components_stock_price.etf

  • 78.82 KB
  • 2824 rows
  • 10 columns
symbol

Symbol

name

Name

type

Type

asset_class

Asset Class

issuer

Issuer

brand

Brand

natural_resource

Natural Resource

commodity

Commodity

sector

Sector

industry

Industry

AAAAAF First Priority CLO Bond ETFAsset ClassBondnannannannannan
AAAUGoldman Sachs Physical Gold ETFAsset ClassCommoditynannanPrecious MetalsGoldnan
AADRAdvisorShares Dorsey Wright ADR ETFAsset ClassEquitiesnannannannannan
AAXJiShares MSCI All Country Asia ex-Japan ETFAsset ClassEquitiesBlackrock Financial ManagementiSharesnannannan
ABEQAbsolute Core Strategy ETFAsset ClassEquitiesnannannannannan
ACESALPS Clean Energy ETFAsset ClassEquitiesnannannannanClean Energy
ACIOAptus Collared Income Opportunity ETFAsset ClassMulti-Assetnannannannannan
ACSIAmerican Customer Satisfaction ETFAsset ClassEquitiesnannannannannan
ACTVLeaderShares Activist Leaders ETFAsset ClassEquitiesnannannannannan
ACVFAmerican Conservative Values ETFAsset ClassEquitiesnannannannannan

CREATE TABLE etf (
  "symbol" VARCHAR,
  "name" VARCHAR,
  "type" VARCHAR,
  "asset_class" VARCHAR,
  "issuer" VARCHAR,
  "brand" VARCHAR,
  "natural_resource" VARCHAR,
  "commodity" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR
);

Share link

Anyone who has the link will be able to view this.