MultiversX Tracker is Live!

How does BTC price affect the activity in r/Cryptocurrency? I collected the data and took a look (This is a long one, so buckle up)

All Cryptocurrencies

by COINS NEWS 225 Views

How does BTC price affect the activity in r/Cryptocurrency? I collected the data and took a look (This is a long one, so buckle up)

I recently started trying to predict the Moon to Karma ratio, because how cool would that be?

I figured out that the total karma per Moon round correlates with the activity in the daily discussion threads.

Like this:

https://preview.redd.it/y4tm13i1w4a71.png?899&format=png&auto=webp&s=189cf98d79906c94d9b7f24a0afdf70a1b7c8b7e

I thought it would be close, but I didn't expect it to be that close.

Then I wondered how the BTC price activity affects what goes on in the daily discussion.

So I collected all the data. I went back to when Moons were introduced and organised it in Moon rounds, just so its easier for me to graph with other stuff.

I got the BTC price from CMC and took the closing figure for each day, then I managed to get the comment count for each daily since 13th May 2020 (There are some gaps with the daily's as they were deleted or something like that, but its not many and it averages out alright on the whole I think)

Then I made a fucking spreadsheet, didn't I.

And some graphs

Here's one:

https://preview.redd.it/5gegpd9gw4a71.png?908&format=png&auto=webp&s=692a50d510c1e5aab0e728cbf6ce2d7debf54e7f

Yeah of course the price going up will increase activity round here, so what you dork? So I took a closer look.

I graphed each round.

Rounds 1-7 look kind of boring, the same as the market was at the time. I played around with the axis scales and you can see a little bit of what's going on but we'll skip them for this post.

Round 8 & 9 were when BTC started smashing ATH's and shit started kicking off around here.

Round 8

https://preview.redd.it/y34tevvuy4a71.png?919&format=png&auto=webp&s=6c0dbf9627c742c7cd639d57a013ff43c407c176

Round 9

https://preview.redd.it/wc85fmdwy4a71.png?919&format=png&auto=webp&s=21ca4f87e93bc53eab6adff2b7063f3eea19df54

This is when we started getting easily into the multiple thousand comments per day in the daily.

Round 10

(This one is broken because I couldn't find all the comment counts, so I just averaged them)

https://preview.redd.it/tt3ji3lmz4a71.png?919&format=png&auto=webp&s=5f9df09a60d58bde47c15769e64f8f497bfeb9bc

(If anyone has got the numbers for the daily in round 10 then hook me up please)

Round 11

https://preview.redd.it/le0qsybb05a71.png?919&format=png&auto=webp&s=191a6b7022d271aafca0efa6819c18dffd2a29eb

This is where the good stuff starts. (If you're weird like me)

I always thought that the price going up would be the major driver in comment amounts. People posting "To the Moon" and all the other good hype and mania.

But it looks like its quite the opposite.

It looks like misery really does enjoy company

We get the most activity and the highest peaks when the price freefalls.

Rounds 12 - 15

Almost every time the price dips a decent amount, the comment count spikes.

https://preview.redd.it/4lxeju0v05a71.png?919&format=png&auto=webp&s=98874346a2b20098a6fe464e5161d4d46d4db16b

https://preview.redd.it/y5mpv4yv05a71.png?919&format=png&auto=webp&s=6e0ea10b36a066131cc2b822b6c5e233172aac15

https://preview.redd.it/y3l2lr1x05a71.png?908&format=png&auto=webp&s=f42a64382b920e0a87f6edba5c0dc5eee3167116

Can anyone remember what happened on 19/05 other than the price dip? That spike is the highest daily I've recorded at 58,550 comments.

https://preview.redd.it/bwr85i2y05a71.png?908&format=png&auto=webp&s=4cbe4e069aeb63165f59f27e5ae2309525df9d4d

My original idea to predict the Moon ratio is still a work in progress, it uses the daily comment count so it looks like it might be easier for me to just build a BTC price prediction and work from there. For round 15 I predicted 0.292 when it was 0.304, so I was close.

TL;DR Misery likes company and I fucking love spreadsheets

submitted by /u/IHaventEvenGotADog
[link] [comments]

Get BONUS $200 for FREE!

You can get bonuses upto $100 FREE BONUS when you:
πŸ’° Install these recommended apps:
πŸ’² SocialGood - 100% Crypto Back on Everyday Shopping
πŸ’² xPortal - The DeFi For The Next Billion
πŸ’² CryptoTab Browser - Lightweight, fast, and ready to mine!
πŸ’° Register on these recommended exchanges:
🟑 Binance🟑 Bitfinex🟑 Bitmart🟑 Bittrex🟑 Bitget
🟑 CoinEx🟑 Crypto.com🟑 Gate.io🟑 Huobi🟑 Kucoin.



Comments