- 1. Bitcoin and Cryptocurrencies: Full dataset, filtering, and reproducibility
- 2. Discard the cryptocurrencies without a market capitalization
- 3. How big is Bitcoin compared with the rest of the cryptocurrencies?
- 4. Making the plot easier to read and more informative
- 5. What is going on?! Volatility in cryptocurrencies
- 6. Well, we can already see that things are a bit crazy
- 7. Ok, those are... interesting. Let's check the weekly Series too.
- 8. How small is small?
- 9. Most coins are tiny
Since the launch of Bitcoin in 2008, hundreds of similar projects based on the blockchain technology have emerged. We call these cryptocurrencies (also coins or cryptos in the Internet slang). Some are extremely valuable nowadays, and others may have the potential to become extremely valuable in the future1. In fact, on the 6th of December of 2017, Bitcoin has a market capitalization above $200 billion.
The astonishing increase of Bitcoin market capitalization in 2017.
*1 WARNING: The cryptocurrency market is exceptionally volatile2 and any money you put in might disappear into thin air. Cryptocurrencies mentioned here might be scams similar to Ponzi Schemes or have many other issues (overvaluation, technical, etc.). Please do not mistake this for investment advice. *
2 Update on March 2020: Well, it turned out to be volatile indeed :D
That said, let's get to business. We will start with a CSV we conveniently downloaded on the 6th of December of 2017 using the coinmarketcap API (NOTE: The public API went private in 2020 and is no longer available) named
import pandas as pd # Importing matplotlib and setting aesthetics for plotting later. import matplotlib.pyplot as plt %matplotlib inline %config InlineBackend.figure_format = 'svg' plt.style.use('fivethirtyeight') # Reading datasets/coinmarketcap_06122017.csv into pandas dec6 = pd.read_csv('./dataset/coinmarketcap_06122017.csv') # Selecting the 'id' and the 'market_cap_usd' columns market_cap_raw = dec6[['id', 'market_cap_usd']] # Counting the number of values market_cap_raw.count()
id 1326 market_cap_usd 1031 dtype: int64
Why do the
market_cap_usd differ above? It is because some cryptocurrencies listed in coinmarketcap.com have no known market capitalization, this is represented by
NaN in the data, and
NaNs are not counted by
count(). These cryptocurrencies are of little interest to us in this analysis, so they are safe to remove.
cap = market_cap_raw.query('market_cap_usd > 0') # Counting the number of values again cap.count()
id 1031 market_cap_usd 1031 dtype: int64
TOP_CAP_TITLE = 'Top 10 market capitalization' TOP_CAP_YLABEL = '% of total cap' # Selecting the first 10 rows and setting the index cap10 = cap.iloc[:10].set_index('id') # Calculating market_cap_perc cap10 = cap10.assign(market_cap_perc = lambda x: (x.market_cap_usd / cap.market_cap_usd.sum()) * 100) # Plotting the barplot with the title defined above ax = cap10.plot.bar(title=TOP_CAP_TITLE) # Annotating the y axis with the label defined above ax.set_ylabel(TOP_CAP_YLABEL);
While the plot above is informative enough, it can be improved. Bitcoin is too big, and the other coins are hard to distinguish because of this. Instead of the percentage, let's use a log10 scale of the "raw" capitalization. Plus, let's use color to group similar coins and make the plot more informative1.
For the colors rationale: bitcoin-cash and bitcoin-gold are forks of the bitcoin blockchain2. Ethereum and Cardano both offer Turing Complete smart contracts. Iota and Ripple are not minable. Dash, Litecoin, and Monero get their own color.
1 This coloring is a simplification. There are more differences and similarities that are not being represented here.
2 The bitcoin forks are actually very different, but it is out of scope to talk about them here. Please see the warning above and do your own research.
COLORS = ['orange', 'green', 'orange', 'cyan', 'cyan', 'blue', 'silver', 'orange', 'red', 'green'] # Plotting market_cap_usd as before but adding the colors and scaling the y-axis ax = cap10.market_cap_usd.plot.bar(color=COLORS, logy=True, title=TOP_CAP_TITLE) # Annotating the y axis with 'USD' ax.set_ylabel('USD'); # Final touch! Removing the xlabel as it is not very informative ax.set_xlabel('');
The cryptocurrencies market has been spectacularly volatile since the first exchange opened. This notebook didn't start with a big, bold warning for nothing. Let's explore this volatility a bit more! We will begin by selecting and plotting the 24 hours and 7 days percentage change, which we already have available.
volatility = dec6[['id', 'percent_change_24h', 'percent_change_7d']] # Setting the index to 'id' and dropping all NaN rows volatility = volatility.set_index('id').dropna() # Sorting the DataFrame by percent_change_24h in ascending order volatility = volatility.sort_values(by='percent_change_24h', ascending=True) # Checking the first few rows volatility.head()
def top10_subplot(volatility_series, title): # Making the subplot and the figure for two side by side plots fig, axes = plt.subplots(nrows=1, ncols=2, figsize=(10, 6)); # Plotting with pandas the barchart for the top 10 losers ax = volatility_series.iloc[:10].plot.bar(color='darkred', ax=axes) # Setting the figure's main title to the text passed as parameter fig.suptitle(title) # Setting the ylabel to '% change' ax.set_ylabel('% change') # Same as above, but for the top 10 winners ax = volatility_series.iloc[-10:].plot.bar(color='darkblue', ax=axes) plt.tight_layout() # Returning this for good practice, might use later return fig, ax DTITLE = "24 hours top losers and winners" # Calling the function above with the 24 hours period series and title DTITLE fig, ax = top10_subplot(volatility.percent_change_24h, DTITLE)
800% daily increase?! Why are we doing this tutorial and not buying random coins?1
After calming down, let's reuse the function defined above to see what is going weekly instead of daily.
1 Please take a moment to understand the implications of the red plots on how much value some cryptocurrencies lose in such short periods of time
volatility7d = volatility.sort_values(by='percent_change_7d', ascending=True) WTITLE = "Weekly top losers and winners" # Calling the top10_subplot function fig, ax = top10_subplot(volatility7d.percent_change_7d, WTITLE)
The names of the cryptocurrencies above are quite unknown, and there is a considerable fluctuation between the 1 and 7 days percentage changes. As with stocks, and many other financial products, the smaller the capitalization, the bigger the risk and reward. Smaller cryptocurrencies are less stable projects in general, and therefore even riskier investments than the bigger ones1. Let's classify our dataset based on Investopedia's capitalization definitions for company stocks.
1 Cryptocurrencies are a new asset class, so they are not directly comparable to stocks. Furthermore, there are no limits set in stone for what a "small" or "large" stock is. Finally, some investors argue that bitcoin is similar to gold, this would make them more comparable to a commodity instead.
largecaps = cap.query('market_cap_usd >= 10000000000') # Printing out largecaps print(largecaps)
id market_cap_usd 0 bitcoin 2.130493e+11 1 ethereum 4.352945e+10 2 bitcoin-cash 2.529585e+10 3 iota 1.475225e+10
# "cap" DataFrame. Returns an int. def capcount(query_string): return cap.query(query_string).count().id # Labels for the plot LABELS = ["biggish", "micro", "nano"] # Using capcount count the biggish cryptos biggish = capcount('market_cap_usd > 3E+8') # Same as above for micro ... micro = capcount('market_cap_usd > 50000000 and market_cap_usd < 300000000') # ... and for nano nano = capcount('market_cap_usd < 50000000') # Making a list with the 3 counts values = [biggish, micro, nano] # Plotting them with matplotlib plt.bar(height=values, x=LABELS);