Analyzing the r/wallstreetbets hivemind — August 2021
Tags: datascience, python, analytics
Published: 2021-09-08 10:06:03

The activity in the Reddit r/wallstreetbets community is staggering. Each day, there are around 800 posts and 50,000 comments debating approximately 280 different stocks. But by just browsing Reddit, between the memes and degenerate gamblers, it can be hard to understand the full nature of the discussion.

In this post, I’ve turned to a bit of SQL and Python to explore what’s happening in the wallstreetbets hivemind. I’ve analyzed **stock popularity**, **sophisticated but overlooked discussions**, and **community influencers**.

If you’re interested, here’s the [raw Reddit data](https://beneath.dev/examples/reddit), my [data pipeline](https://github.com/beneath-hq/beneath/blob/master/examples/wallstreetbets-analytics/stock-mentions/find_mentions_pipeline.py), the [derived data](https://beneath.dev/examples/wallstreetbets-analytics/), and my [Jupyter notebook](https://github.com/beneath-hq/beneath/blob/master/examples/wallstreetbets-analytics/explore/explore.ipynb). I’m using [Beneath](https://about.beneath.dev/), an open data platform I’m building, to stream and save the data.

Btw, this isn’t investment advice… DYOR.

## The meme stock rankings

Let’s start with the basics. What are the most discussed stocks and how have they changed over time?

The stocks on wallstreetbets can be broadly bucketed into two categories: long-standing wallstreetbets’ interests and stocks related to current events. We can see these two categories by inspecting a line graph of mentions over time (select stocks):

![ebbs-and-flows](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/42y236j2l32kgn0dozbi.png)
<figcaption><a href="https://chart-studio.plotly.com/~ericpgreen/8.embed">Click here to view interactive chart</a></figcaption>
<br/>

The long-standing wallstreetbets interests jump out: these are the lines that occupy a significant percentage of mentions over the whole time period. These include staples like Gamestop (GME) and AMC, but the community has also long been tracking Clover Health (CLOV) and AMD, the semiconductor manufacturer. It doesn’t look like wallstreetbets will lose interest in these anytime soon.

On the other hand, we see stocks that spike suddenly due to specific events, such as Robinhood (HOOD) and Microvast (MVST), a lithium-ion battery manufacturer. Both of these stocks went public at the end of July and received bursts of attention from the community, but the interest hasn’t lasted. As of September 1st, both stocks now have a near-zero percent share of daily mentions.

In this next chart, we zoom in on the most discussed stocks in the month of August.

![top10](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6ewmfe7ycqhb9s2a0qct.png)
<figcaption><a href="https://chart-studio.plotly.com/~ericpgreen/6.embed">Click here to view interactive chart</a></figcaption>
<br/>

GME and AMC have long been community favorites, and even in August, they remain the most mentioned stocks. I’ve been collecting data from wallstreetbets since March, and the two companies have been the most discussed for 4 of these 6 months. But it’s also clear that it’s not a power law distribution, and contending stocks get significant discussion, too.

## Discussions of the next big thing

The NASDAQ includes over 4000 public equities, and the NYSE over 3000, so how does the community come to rally around certain stocks? One of my hypotheses is that some initial post triggers a deep and unique discussion that ultimately leads to community-wide attention. So, let’s try to find some interesting conversations.

I’ve tried to uncover some under-appreciated discussions by filtering for posts with at least 15 comments and 25 upvotes, and sorting those posts by highest average words per comment. Here are the top 10 for the month of August:

![sophisticated](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/74b9htfi6a8qijrlrkv8.png)
<figcaption><a href="https://chart-studio.plotly.com/~ericpgreen/12.embed">Click here to view interactive chart</a></figcaption>
<br/>

*If you’d like to read the discussions, the [interactive chart](https://chart-studio.plotly.com/~ericpgreen/12.embed) includes a link to each post’s page on reddit.com. Note that the numbers might not reflect what you see on reddit.com because comments can be edited and deleted after-the-fact, and scores are continually changing.*

The posts above reveal fairly educated discussions about storylines that, for the most part, haven’t yet hit the wallstreetbets front page. Stocks like Lordstown Motors (RIDE), Ford (FORD), and Proterra (PRTA) haven’t yet garnered much attention, but, in light of these deep discussions, they could be worth keeping an eye on.

Another hypothesis I wanted to test is that the share of rocket emojis in a discussion could signal a stock’s momentum within the community. Here’s a ranking of the posts from August that had the highest percentage of commenters include a rocket emoji (filtered for posts with at least 25 comments):

![rockets](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3o0ktx9u5b09aknl69js.png)
<figcaption><a href="https://chart-studio.plotly.com/~ericpgreen/4.embed">Click here to view interactive chart</a></figcaption>
<br/>

Unsurprisingly, these posts reveal a number of meme stocks that have already made it to the front-page, like CLOV and WISH. But there are also companies like Pizza Hut (HUT) and Bitfarms (BITF) that haven’t made it to the front page (yet?). They’re definitely worth watching.

Behind every post and comment is a member of the wallstreetbets community. Let’s find out which authors are leading the discussion.

## The influencers of wallstreetbets

To identify influencers, I wanted to find the active authors who get the most upvotes on substantial, forward-looking posts. To that end, I’ve applied a couple criteria. First, I’ve excluded posts labeled as a “Meme,” “Gain,” or “Loss,” which are mostly retrospective. Second, I’ve filtered for authors who have posted at least once since July 1st. One of the most popular Redditors of all time was u/DeepF***ingValue, but his last post was on April 15th, and I want this analysis to be current.

Here are the top authors since I started collecting data in March:

![influencers](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/39t4n8jq2l6iulwcejz7.png)
<figcaption><a href="https://chart-studio.plotly.com/~ericpgreen/1.embed">Click here to view interactive chart</a></figcaption>
<br/>

The influencers that I found can be split into two categories: the analysts and the hype men.

The analysts, like the two top authors u/quantkim and u/nobjos, contribute breaking news, technical analysis, and quantitative reports. For example, u/quantkim shares articles about GameStop’s corporate turnaround, like [this one](https://www.reddit.com/r/wallstreetbets/comments/oesywr/gamestop_continues_expansion_of_fulfillment/), and has averaged 11,332 upvotes over 15 posts.

Conversely, the hype men typically talk up their big positions in popular stocks. Here’s one from u/dumbledoreRothIRA about [a $600k position in $CLOV](https://www.reddit.com/r/wallstreetbets/comments/osaz9c/600k_yolo_on_clov_bullish_as_ever_still_diamond/), and one from u/lookshee laying out his [intention to buy the entirety of the GameStop company](https://www.reddit.com/r/wallstreetbets/comments/loio0b/i_am_going_to_buy_gamestop_all_of_it_dont_upvote/).

All the authors above clearly influence the community, so, to jump ahead of the crowd, it’d be smart to set up notifications for whenever they post.

## What’s next

My analyses in this post really just scratch the surface of what you can infer from wallstreetbets data — there’s much more to do. To extend this work, I’m currently considering factoring in price movements, doing sentiment analysis, and creating a bot that mines for insights in real-time.

Last week, [a Wall Street Journal article detailed that forward-thinking hedge funds are diving into the r/wallstreetbets data](https://www.wsj.com/articles/wall-street-is-looking-to-reddit-for-investment-advice-11630056648). By making this data public and queryable on Beneath, I hope I’ve made it more accessible to the everyday person!

If you’re interested in any of this, come hangout in the Beneath [Discord community](https://discord.gg/f5yvx7YWau), follow me on twitter [@ericpgreen2](https://twitter.com/ericpgreen2), or [jump right into the data](https://beneath.dev/examples/wallstreetbets-analytics/) yourself 🚀🚀🚀