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

Bsep

@kaggle.cprimozi_robinhood_stock_popularity_history.bsep

37.06 kB
3,653 rows
2 columns

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

Bset

@kaggle.cprimozi_robinhood_stock_popularity_history.bset

149.13 kB
14,934 rows
2 columns

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

Bsgm

@kaggle.cprimozi_robinhood_stock_popularity_history.bsgm

120.79 kB
11,743 rows
2 columns

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

Bsig

@kaggle.cprimozi_robinhood_stock_popularity_history.bsig

49.48 kB
4,854 rows
2 columns

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

Bsji

@kaggle.cprimozi_robinhood_stock_popularity_history.bsji

147.48 kB
14,893 rows
2 columns

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

Bsjk

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjk

147.69 kB
14,895 rows
2 columns

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

Bsjl

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjl

147.09 kB
14,899 rows
2 columns

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

Bsjm

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjm

147.85 kB
14,899 rows
2 columns

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

Bsjn

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjn

147.76 kB
14,904 rows
2 columns

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

Bsjo

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjo

148.21 kB
14,962 rows
2 columns

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

Bsjp

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjp

143.67 kB
14,479 rows
2 columns

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

Bsjq

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjq

126.3 kB
12,723 rows
2 columns

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

Bsjr

@kaggle.cprimozi_robinhood_stock_popularity_history.bsjr

35.28 kB
3,463 rows
2 columns

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

Bsl

@kaggle.cprimozi_robinhood_stock_popularity_history.bsl

148.88 kB
14,959 rows
2 columns

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

Bsm

@kaggle.cprimozi_robinhood_stock_popularity_history.bsm

153.92 kB
14,962 rows
2 columns

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

Bsml

@kaggle.cprimozi_robinhood_stock_popularity_history.bsml

24.66 kB
2,357 rows
2 columns

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

Bsmm

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmm

24.66 kB
2,357 rows
2 columns

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

Bsmn

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmn

24.66 kB
2,357 rows
2 columns

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

Bsmo

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmo

24.67 kB
2,357 rows
2 columns

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

Bsmp

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmp

24.63 kB
2,357 rows
2 columns

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

Bsmq

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmq

24.63 kB
2,357 rows
2 columns

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

Bsmr

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmr

24.68 kB
2,357 rows
2 columns

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

Bsms

@kaggle.cprimozi_robinhood_stock_popularity_history.bsms

24.67 kB
2,357 rows
2 columns

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

Bsmt

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmt

24.64 kB
2,357 rows
2 columns

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

Bsmx

@kaggle.cprimozi_robinhood_stock_popularity_history.bsmx

134.75 kB
13,204 rows
2 columns

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