Name: Robinhood Stock Popularity History
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Robinhood Stock Popularity History

Context

This data set consists of >1 year of historical data about the number of users that hold each stock available on the Robinhood stock brokerage. It is the dataset that powers https://robintrack.net/

Content

Data was collected from the Robinhood API once per hour over the entire period.

The popularity metric represents the number of unique accounts that hold at least one share of the asset. This only includes normal, long shares (not options).

Acknowledgements

Robinhood provides their popularity data publicly, which I feel is a great step in the right direction for an industry (finance) where data has traditionally been expensive, low-quality, and hard to find. I feel it's only right that I share this historical popularity data freely as well.

Caveats + Possible Issues

Robinhood gives free shares of a certain set of stocks as rewards to users for referring others to their platform. Some of the most popular stocks are at the top because of this.

The popularity metrics change over weekends and when the market is closed due to the fact that Robinhood accounts can be created/closed/transferred over those periods. The metric reported at each timestamp is the exact value that the Robinhood API reported at that instant.

Inspiration

This data can be used as a measure of retail sentiment. By seeing what traders do in response to changes in price and different news events, it can be determined if retail traders are "buying the dip" or panicking and leaving the market.

I didn't include price data due to possible legal limitations. However, it should be relatively easy to obtain this data yourself from a different source and combine it with this data set.

Tables

Fsb

@kaggle.cprimozi_robinhood_stock_popularity_history.fsb

148.97 kB
14,962 rows
2 columns

CREATE TABLE fsb (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsbc

@kaggle.cprimozi_robinhood_stock_popularity_history.fsbc

146.48 kB
14,969 rows
2 columns

CREATE TABLE fsbc (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsbw

@kaggle.cprimozi_robinhood_stock_popularity_history.fsbw

148.42 kB
14,925 rows
2 columns

CREATE TABLE fsbw (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsct

@kaggle.cprimozi_robinhood_stock_popularity_history.fsct

154.75 kB
14,980 rows
2 columns

CREATE TABLE fsct (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsd

@kaggle.cprimozi_robinhood_stock_popularity_history.fsd

149.26 kB
14,959 rows
2 columns

CREATE TABLE fsd (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsea

@kaggle.cprimozi_robinhood_stock_popularity_history.fsea

48.64 kB
4,806 rows
2 columns

CREATE TABLE fsea (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsfg

@kaggle.cprimozi_robinhood_stock_popularity_history.fsfg

147.96 kB
14,926 rows
2 columns

CREATE TABLE fsfg (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsi

@kaggle.cprimozi_robinhood_stock_popularity_history.fsi

154.38 kB
14,914 rows
2 columns

CREATE TABLE fsi (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsk

@kaggle.cprimozi_robinhood_stock_popularity_history.fsk

156.23 kB
14,955 rows
2 columns

CREATE TABLE fsk (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fslr

@kaggle.cprimozi_robinhood_stock_popularity_history.fslr

159.89 kB
14,936 rows
2 columns

CREATE TABLE fslr (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsly

@kaggle.cprimozi_robinhood_stock_popularity_history.fsly

69.18 kB
6,237 rows
2 columns

CREATE TABLE fsly (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsm

@kaggle.cprimozi_robinhood_stock_popularity_history.fsm

157.5 kB
14,914 rows
2 columns

CREATE TABLE fsm (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsmb

@kaggle.cprimozi_robinhood_stock_popularity_history.fsmb

106.22 kB
10,741 rows
2 columns

CREATE TABLE fsmb (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsmd

@kaggle.cprimozi_robinhood_stock_popularity_history.fsmd

79.98 kB
8,053 rows
2 columns

CREATE TABLE fsmd (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsp

@kaggle.cprimozi_robinhood_stock_popularity_history.fsp

150.03 kB
14,958 rows
2 columns

CREATE TABLE fsp (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsrv

@kaggle.cprimozi_robinhood_stock_popularity_history.fsrv

12.45 kB
1,082 rows
2 columns

CREATE TABLE fsrv (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fss

@kaggle.cprimozi_robinhood_stock_popularity_history.fss

150.91 kB
14,914 rows
2 columns

CREATE TABLE fss (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsta

@kaggle.cprimozi_robinhood_stock_popularity_history.fsta

151 kB
14,943 rows
2 columns

CREATE TABLE fsta (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fstr

@kaggle.cprimozi_robinhood_stock_popularity_history.fstr

148.88 kB
14,943 rows
2 columns

CREATE TABLE fstr (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsugy

@kaggle.cprimozi_robinhood_stock_popularity_history.fsugy

124.68 kB
12,293 rows
2 columns

CREATE TABLE fsugy (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsv

@kaggle.cprimozi_robinhood_stock_popularity_history.fsv

63.65 kB
6,311 rows
2 columns

CREATE TABLE fsv (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fsz

@kaggle.cprimozi_robinhood_stock_popularity_history.fsz

147.96 kB
14,914 rows
2 columns

CREATE TABLE fsz (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Ft

@kaggle.cprimozi_robinhood_stock_popularity_history.ft

149.37 kB
14,961 rows
2 columns

CREATE TABLE ft (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Fta

@kaggle.cprimozi_robinhood_stock_popularity_history.fta

148.24 kB
14,942 rows
2 columns

CREATE TABLE fta (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);

Ftac

@kaggle.cprimozi_robinhood_stock_popularity_history.ftac

92.13 kB
9,162 rows
2 columns

CREATE TABLE ftac (
  "timestamp" TIMESTAMP,
  "users_holding" BIGINT
);