Name: Stock Data With Industry Information
Creator: Kaggle
License: https://cdla.dev/permissive-1-0/

About this Dataset

Stock Data With Industry Information

Overview

This dataset aims to provide a comprehensive collection of stock market data for financial analysis, research, and education. Created to fill the gap of hard-to-find large-scale stock market information, this dataset is designed for use by academics, researchers, data scientists, financial analysts, and anyone interested in stock market analysis.

Features

Data Coverage

Stocks: The Dataset contains information on 425 companies from various exchanges such as the NYSE, NASDAQ, and others.
Time Period: The Dataset spans from January 2019 to September 2023.
Frequency: Data points were collected daily.

Data Points

Stock Data

Instrument is the RIC of the company
Date of observation
High and Low price of the day
Open and Close price of the day
Volume of the stock on that day

Sector Data

Instrument is the RIC of the company
Company Common Name of the company
Economic Sector Name of the company
Business Sector Name of the company
Industry Name of the company
Activity Name of the company
Economic and Business Sector Code of the company

Tables

Kaggle Stock Data

@kaggle.luisgilch_stock_data_with_industry_information.kaggle_stock_data

8.11 MB
501,625 rows
7 columns

CREATE TABLE kaggle_stock_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "instrument" VARCHAR,
  "date" VARCHAR,
  "price_high" DOUBLE,
  "price_close" DOUBLE,
  "price_open" DOUBLE,
  "volume" DOUBLE
);

Kaggle Stock Sector Information

@kaggle.luisgilch_stock_data_with_industry_information.kaggle_stock_sector_information

35.18 kB
437 rows
13 columns

CREATE TABLE kaggle_stock_sector_information (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "instrument" VARCHAR,
  "company_common_name" VARCHAR,
  "trbc_economic_sector_name" VARCHAR,
  "trbc_business_sector_name" VARCHAR,
  "trbc_industry_group_name" VARCHAR,
  "trbc_industry_name" VARCHAR,
  "trbc_activity_name" VARCHAR,
  "trbc_economic_sector_code" BIGINT,
  "trbc_business_sector_code" BIGINT,
  "trbc_industry_group_code" BIGINT,
  "trbc_industry_code" BIGINT,
  "trbc_activity_code" BIGINT
);

Stock Data

@kaggle.luisgilch_stock_data_with_industry_information.stock_data

8.12 MB
507,603 rows
7 columns

CREATE TABLE stock_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "instrument" VARCHAR,
  "date" VARCHAR,
  "price_high" DOUBLE,
  "price_close" DOUBLE,
  "price_open" DOUBLE,
  "volume" DOUBLE
);

Stock Sector Information

@kaggle.luisgilch_stock_data_with_industry_information.stock_sector_information

35.18 kB
437 rows
13 columns

CREATE TABLE stock_sector_information (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "instrument" VARCHAR,
  "company_common_name" VARCHAR,
  "trbc_economic_sector_name" VARCHAR,
  "trbc_business_sector_name" VARCHAR,
  "trbc_industry_group_name" VARCHAR,
  "trbc_industry_name" VARCHAR,
  "trbc_activity_name" VARCHAR,
  "trbc_economic_sector_code" BIGINT,
  "trbc_business_sector_code" BIGINT,
  "trbc_industry_group_code" BIGINT,
  "trbc_industry_code" BIGINT,
  "trbc_activity_code" BIGINT
);