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

Xon

@kaggle.cprimozi_robinhood_stock_popularity_history.xon

153.72 kB
14,580 rows
2 columns

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

Xone

@kaggle.cprimozi_robinhood_stock_popularity_history.xone

153.23 kB
14,931 rows
2 columns

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

Xop

@kaggle.cprimozi_robinhood_stock_popularity_history.xop

157.82 kB
14,919 rows
2 columns

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

Xout

@kaggle.cprimozi_robinhood_stock_popularity_history.xout

30.41 kB
2,863 rows
2 columns

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

Xoxo

@kaggle.cprimozi_robinhood_stock_popularity_history.xoxo

149.67 kB
14,919 rows
2 columns

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

Xp

@kaggle.cprimozi_robinhood_stock_popularity_history.xp

15.59 kB
1,322 rows
2 columns

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

Xpel

@kaggle.cprimozi_robinhood_stock_popularity_history.xpel

51.11 kB
4,759 rows
2 columns

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

Xper

@kaggle.cprimozi_robinhood_stock_popularity_history.xper

152 kB
14,970 rows
2 columns

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

Xph

@kaggle.cprimozi_robinhood_stock_popularity_history.xph

142.09 kB
14,149 rows
2 columns

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

Xpl

@kaggle.cprimozi_robinhood_stock_popularity_history.xpl

145.93 kB
14,267 rows
2 columns

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

Xplr

@kaggle.cprimozi_robinhood_stock_popularity_history.xplr

123.84 kB
12,238 rows
2 columns

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

Xpo

@kaggle.cprimozi_robinhood_stock_popularity_history.xpo

161.04 kB
14,914 rows
2 columns

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

Xpp

@kaggle.cprimozi_robinhood_stock_popularity_history.xpp

144.87 kB
14,531 rows
2 columns

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

Xray

@kaggle.cprimozi_robinhood_stock_popularity_history.xray

155.12 kB
14,934 rows
2 columns

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

Xrf

@kaggle.cprimozi_robinhood_stock_popularity_history.xrf

17.86 kB
1,562 rows
2 columns

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

Xrlv

@kaggle.cprimozi_robinhood_stock_popularity_history.xrlv

148.02 kB
14,902 rows
2 columns

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

Xrm

@kaggle.cprimozi_robinhood_stock_popularity_history.xrm

136.93 kB
13,704 rows
2 columns

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

Xrt

@kaggle.cprimozi_robinhood_stock_popularity_history.xrt

153.93 kB
14,914 rows
2 columns

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

Xrx

@kaggle.cprimozi_robinhood_stock_popularity_history.xrx

48.15 kB
4,448 rows
2 columns

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

Xsd

@kaggle.cprimozi_robinhood_stock_popularity_history.xsd

151.75 kB
14,936 rows
2 columns

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

Xshd

@kaggle.cprimozi_robinhood_stock_popularity_history.xshd

149.2 kB
14,958 rows
2 columns

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

Xslv

@kaggle.cprimozi_robinhood_stock_popularity_history.xslv

149.97 kB
14,925 rows
2 columns

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

Xsmo

@kaggle.cprimozi_robinhood_stock_popularity_history.xsmo

22.4 kB
2,106 rows
2 columns

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

Xsoe

@kaggle.cprimozi_robinhood_stock_popularity_history.xsoe

148.32 kB
14,959 rows
2 columns

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

Xspa

@kaggle.cprimozi_robinhood_stock_popularity_history.xspa

85.43 kB
8,126 rows
2 columns

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