I analyzed more than a million bitcoin tweets. Here’s what that looks like

I recently got my hands on more than 1.3 million tweets, all mentioning bitcoin or creator Satoshi Nakamoto, spanning the entire month of February 2014. My goal was to get a sense of who’s actually interested in bitcoin (enough to tweet about it, at least) and to see how activity on Twitter tracked with big news stories.
Here’s what I found. Click on any image for a larger version.
(Disclaimer: I’m neither a statistician nor a programmer, so I used relatively simple tools for analysis and worked with companies on other aspects. Gnip, which is now part of Twitter, supplied the data. I used Chartio’s cloud-based analytics service for much of the quantitative analysis and some of the visualizations. I used Google Fusion Tables for the Marc Andreessen graphs, Tableau for the analysis of news content and AlchemyAPI analyzed the Mt. Gox tweets for sentiment.)

Who’s tweeting about Bitcoin

All told, 333,144 unique accounts posted messages related to bitcoin. But not all accounts are created equal. Some are clearly spam accounts or other types of bots — thousands had posted between zero and one tweets — while others seemingly constantly churn out the latest Bitcoin rates and new items. Here are the top 10 most-active accounts for February.

Most active accounts (number of tweets)
Username Number of tweets
BTCNewsticker 16,136
AllThingsBTC 15,013
bit8coin 8,790
Cryptogeeks 7,832
ProjectCoin 7,587
forexrelvo 7,176
BTC_LTC_Xchange 6,480
alt_bit_coins 6,237
Regarding BTC 5,018
AlertCoin 4,837

Here are the 10 usernames that received the most @ mentions. Not surprisingly, bitcoin news specialist Coindesk takes the cake. Most of these numbers are actually higher (some much higher) because tweets often reference multiple accounts but the data format made it difficult to include those tweets in the count.

Most @ mentions (not tweets w/ mentioning multiple users)
Username Number of mentions
Coindesk 13,203
Bitcoin 6,929
BitCoinReporter 5,587
BTCNewsTicker 4,925
baconbkk 4,491
BitcoinVOX, ShareThis 4,310
Forbes 4,026
aantonop 3,869
ConanOBrien 3,447
ProjectCoin 3,366

Some were one-hit wonders with massively retweeted posts, such as talk show host Conan O’Brien.

And someone called Bacon Bangkok.

I filtered out one account that’s still active but generated in about an hour more than 4,400 spammy retweets of a post, now removed, about opening a free bitcoin wallet. (That message accounts for the spike in tweets on the evening of Feb. 8, which is shown below.)

Marc Andreessen gets a lot of bang for his buck

I thought it was also worth looking at the most-active verified accounts to get a sense of which (presumably) respected individuals and publications are tweeting the most about bitcoin. Venture capitalist Marc Andreessen (@pmarca) topped the list in February.

Most active verified accounts (number of tweets)
Username Number of tweets
pmarca 145
binarybits 84
businessinsider 78
ForbesTech 70
MarketWatch 67
paulvigna 66
Forbes 64
AsheSchow 62
CNNMoney 58
kashhill 53

It shouldn’t be surprising that Andreessen gets a lot of mentions — more than 3,600 (including those including other users) — which is impressive compared with his mere 145 tweets. Here’s an interactive graph (and here’s a link to it) showing the vast network he’s created. Small yellow nodes represent tweets mentioning Andreessen and someone else, and blue nodes are the accounts doing the tweeting. Andreessen is the large yellow node, which connects with who has mentioned mentioned him alone and who he has mentioned.
[protected-iframe id=”01fa585aedcd38b6bb7b171209c7c4bb-14960843-6578147″ info=”https://www.google.com/fusiontables/embedviz?containerId=googft-gviz-canvas&viz=GVIZ&t=GRAPH&gc=true&gd=true&sdb=1&rmax=100000&uiversion=2&q=select+col0%2C+col1+from+1OlVuGM3KiB0KgduZ3alX7MVuUWSdLNxThypzMokK&qrs=+where+col0+%3E%3D+&qre=+and+col0+%3C%3D+&qe=&state=%7B%22ps%22%3A%221_1_-1x_j_y_a_-1h_d_-m_2m_b_1i_-1l_2k_15_2s_1u_11_5_c_-3y_-1q_f_-x_-2j_1q_-1i_-2y_14_30_g_z_-n_-14_j_2i_-1l_28_-39_28_x_-28_-2d_n_-24_-30_29_6_1i_13_2s_-z_o_1r_u_1m_-l_1c_2g_4_-26_1e_1w_8_2l_e_-24_15_-1v_-19_4_-q_-1t_1l_-4p_0_2_-14_-1k_1o_x_24_24_w_r_19_n_-1v_26_10_-1p_1h_18_-z_h_1t_1u_e_-3s_-j_p_-9_-21_r_-37_-2k_2f_-2k_-2r_1v_-26_-1y_2i_-3_-2g_i_-1i_2y_w_d_-q_t_11_-r_1k_4_27_1t_k_29_5_1p_h_v_-z_-28_1c_c_6_g_-16_-2u_q_v_-c_12_-1z_-1k_3_1a_z_16_-3m_1r_17_1a_1w_0_d_-b_6_x_-17_1a_-a_-1n_k_e_14_1d_1k_2i_l_-2b_-13_1f_-f_-2m_1g_-2u_2r_u_18_g_1i_2u_-6_1j_1y_-2e_m_-1r_-2m_9_z_1a_1n_-2s_-1e_20_9_w_1p_-2k_2d_1r_-p_36_1s_-2g_31_8_-1c_-22_2m_1j_3_1w_-1o_29_1x_-3l_-o_1y_-17_33_1z_-1x_2q_1b_v_1n_21_-3i_o_22_-3m_10_23_-6_k_a_-2_1j_25_1g_-d_27_2l_t_2a_-3l_-18_2b_-i_1x_2c_l_2y_2d_c_2s_2e_-4d_1p_s_-11_-1b_10_1d_-n_2h_-38_-14_18_-8_-10_2j_2n_1f_7_1c_-5_11_-2u_-25_%22%2C%22cx%22%3A-15.285941304291608%2C%22cy%22%3A29.645618313667658%2C%22sw%22%3A741.2099829669105%2C%22sh%22%3A384.61273954168524%2C%22z%22%3A2.7535890940923826%7D&gco_forceIFrame=true&gco_hasLabelsColumn=true&width=500&height=300″ width=”500″ height=”300″ scrolling=”no”]
As you can see, though, the network of users to whom Andreessen actually replies or tweets directly is significantly smaller.

Where is bitcoin (possibly) popular

Here are the top Twitter time zones for tweets, which should be taken with a grain of salt, of course, given the number of spam accounts and accounts with either no time zone listed or false time zones. Also, these numbers are for aggregate tweets, not the number of unique accounts tweeting from each time zone. For example, the more than 15,000 tweets from AllThingsBTC account for about 20 percent of tweets from the London time zone.
Breaking it down by users’ specified locations, things look a little different. You’ll notice the myriad ways of saying New York City, for example, and Cryptogeeks representing #Bitcoin #Litecoin #Altcoins.
If you wonder what this looks like visually, here’s a relatively small sample of user locations mapped using Google Fusion Tables. It’s not entirely accurate — Fusion Tables appears to try to place everything even if it’s not a real location — but it gives a sense of how global Bitcoin is.

The Mt. Gox meltdown

While the above charts are high-level info about who’s tweeting, any analysis of bitcoin in February isn’t complete without analyzing the demise of popular — and original — bitcoin exchange service Mt. Gox.
Its death throes are represented in these timelines. The bump on Feb. 7 corresponding to Mt. Gox’s official announcement that it was temporarily suspending bitcoin withdrawals. Feb. 10 is the date Mt. Gox extended its suspension on withdrawals and sent the price of Bitcoin plummeting. The evening of Feb. 24 is when news broke that Mt. Gox had “lost” about 750,00 bitcoins worth about $375 million at the time, and tweets skyrocketed the next morning. Mt. Gox filed for bankruptcy on Feb. 28.
Here’s how it looks by the hour. Notice the aforementioned spam spike on Feb. 8.
Not surprisingly, while the media really began picking up on the Mt. Gox meltdown after its late-night announcement on Feb. 6, chatter about withdrawal problems and the imminent demise of Mt. Gox had been growing on Twitter. The roughly $100 decrease in bitcoin value on Mt. Gox in one day on Feb. 5 didn’t help the cause.

On Feb. 4, Swedish Pirate Party founder Rick Falkvinge reported that Mt. Gox had already racked up more than $38 million in unfulfilled withdrawals (i.e., Bitcoins left users’ accounts but never made it to the users).

Overall, sentiment about Mt. Gox seemed to follow the news pretty closely. In the chart below, the blue line represents negative tweets, the yellow line represents positive tweets and the purple line represents all tweets that day about bitcoin. On Feb. 25, negative tweets mentioning Mt. Gox represented more than a quarter of all tweets about bitcoin.

Bring in the journalists

When journalists finally do get wind of a story, their articles tend to spread pretty well. Overall, there were more than 247,000 “unique” URLs shared in February, and they were shared more than 1.02 million times. I analyzed the top 10,705 URLs, which ended up being anything shared at least 12 times. Of those, 1,328 (well less than 1 percent of the total unique URLs) came from — in some way, shape or form — 25 technology and general-purpose news sites that I chose to examine. They were shared 121,931 times, which accounts for about 12 percent of all sharing activity for February.
(A note about URLs, though: It’s difficult to put an exact number on unique URLs because so many are syndicated or shared via RSS, Google or other social sites that alter the URL in some way. I shortened the cells in Excel to 100 characters, which seemed like a good way to catch cells with multiple links and still cut off a good number of single-URL cells before the social tagging kicks in.)
Long story, short: Total shares is a more-accurate measure than unique URLs for assessing the popularity of a publication. Running this same analysis with the top 44,810 URLs, for example, results in a lot more URLs for each publication but minimally higher total shares.
scatter square
Now watch what happens when we include Coindesk, a news site focused on crypto-currencies. Check out the interactive version of this chart here.
Still, though, news sites are no match for spam messages and links to Bitcoin wallets, exchanges, monitors and other types of non-news sites. The top 15 of all shared URLs were for such sites and accounted for 76,534 total shares. You can examine them here. This article from Wired (well an earlier version, the URL of which appears to have been replaced) was the most-popular news URL, with 1,404 shares..

Ode to Satoshi

And amid all those tweets, I found this. Enough said.