Dataset: Stock Information

About this Dataset

Stock Information

Context

Information about more than 4600 companies tradable on Robinhood website

Source

The information is scraped from Robinhood website

Inspiration

The dataset contains useful information about Public Companies are being traded in US Stock market. Information about company size, market cap, PE ratio, list date, etc. is provided which can provide some insights about stock market in the US.

Tables

Robinhood

@kaggle.vaghefi_robinhood.robinhood

1.95 MB
4610 rows
33 columns


CREATE TABLE robinhood (
  "simple_name" VARCHAR,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "bloomberg_unique" VARCHAR,
  "margin_initial_ratio" DOUBLE,
  "maintenance_ratio" DOUBLE,
  "country" VARCHAR,
  "day_trade_ratio" DOUBLE,
  "list_date" TIMESTAMP,
  "type" VARCHAR,
  "default_collar_fraction" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "volume" BIGINT,
  "average_volume_2_weeks" DOUBLE,
  "average_volume" DOUBLE,
  "high_52_weeks" DOUBLE,
  "dividend_yield" DOUBLE,
  "float" DOUBLE,
  "low_52_weeks" DOUBLE,
  "market_cap" DOUBLE,
  "pb_ratio" DOUBLE,
  "pe_ratio" DOUBLE,
  "shares_outstanding" DOUBLE,
  "description" VARCHAR,
  "ceo" VARCHAR,
  "headquarters_city" VARCHAR,
  "headquarters_state" VARCHAR,
  "sector" VARCHAR,
  "industry" VARCHAR,
  "num_employees" DOUBLE,
  "year_founded" DOUBLE
);