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

Ihrt

@kaggle.cprimozi_robinhood_stock_popularity_history.ihrt

51.34 kB
4,782 rows
2 columns

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

Iht

@kaggle.cprimozi_robinhood_stock_popularity_history.iht

154.08 kB
14,943 rows
2 columns

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

Ihta

@kaggle.cprimozi_robinhood_stock_popularity_history.ihta

37.84 kB
3,728 rows
2 columns

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

Ihy

@kaggle.cprimozi_robinhood_stock_popularity_history.ihy

148.34 kB
14,923 rows
2 columns

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

Ihyd

@kaggle.cprimozi_robinhood_stock_popularity_history.ihyd

128.39 kB
13,069 rows
2 columns

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

Ihyv

@kaggle.cprimozi_robinhood_stock_popularity_history.ihyv

129.67 kB
13,069 rows
2 columns

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

Iid

@kaggle.cprimozi_robinhood_stock_popularity_history.iid

150.64 kB
14,960 rows
2 columns

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

Iif

@kaggle.cprimozi_robinhood_stock_popularity_history.iif

148.86 kB
14,960 rows
2 columns

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

Iigd

@kaggle.cprimozi_robinhood_stock_popularity_history.iigd

128.1 kB
13,069 rows
2 columns

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

Iigv

@kaggle.cprimozi_robinhood_stock_popularity_history.iigv

129.63 kB
13,069 rows
2 columns

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

Iii

@kaggle.cprimozi_robinhood_stock_popularity_history.iii

152.12 kB
14,948 rows
2 columns

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

Iiin

@kaggle.cprimozi_robinhood_stock_popularity_history.iiin

151.55 kB
14,940 rows
2 columns

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

Iiiv

@kaggle.cprimozi_robinhood_stock_popularity_history.iiiv

139.32 kB
13,869 rows
2 columns

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

Iim

@kaggle.cprimozi_robinhood_stock_popularity_history.iim

149.57 kB
14,960 rows
2 columns

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

Iin

@kaggle.cprimozi_robinhood_stock_popularity_history.iin

153.79 kB
14,948 rows
2 columns

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

Iipr

@kaggle.cprimozi_robinhood_stock_popularity_history.iipr

168.62 kB
14,970 rows
2 columns

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

Iivi

@kaggle.cprimozi_robinhood_stock_popularity_history.iivi

156.2 kB
14,937 rows
2 columns

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

Ijan

@kaggle.cprimozi_robinhood_stock_popularity_history.ijan

10.11 kB
842 rows
2 columns

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

Ijh

@kaggle.cprimozi_robinhood_stock_popularity_history.ijh

151.28 kB
14,920 rows
2 columns

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

Ijj

@kaggle.cprimozi_robinhood_stock_popularity_history.ijj

148.16 kB
14,921 rows
2 columns

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

Ijk

@kaggle.cprimozi_robinhood_stock_popularity_history.ijk

148.4 kB
14,921 rows
2 columns

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

Ijr

@kaggle.cprimozi_robinhood_stock_popularity_history.ijr

156.55 kB
14,920 rows
2 columns

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

Ijs

@kaggle.cprimozi_robinhood_stock_popularity_history.ijs

149.23 kB
14,920 rows
2 columns

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

Ijt

@kaggle.cprimozi_robinhood_stock_popularity_history.ijt

149.76 kB
14,920 rows
2 columns

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

Ijul

@kaggle.cprimozi_robinhood_stock_popularity_history.ijul

52.29 kB
5,190 rows
2 columns

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