Top crypto currencies analysis

For my first unguided SQL project I wanted to combine it with something of my personal interest and try to apply all the syntaxes I learnt so far. In this project, we will dive into cryptocurrency data and transform this data into knowledge and data-driven answers.


Technique: Data cleaning, data aggregation, data exploration, statistical analysis and data visualization.

Tools: SQL, Tableau.

September 15, 2021


  1. What are the 5 cryptocurrencies that have grown the most during the last year?
  2. Within the last year, which month did cryptocurrencies grow the most?
  3. Is the price of Cardano positively correlated with the price of Bitcoin?

The data-driven answers

  1. The 5 cryptocurrencies that grew the most during the period from 2020-07-06 until 2021-07-06, were Dogecoin, Solana, Binance Coin, Cardano and Ethereum, respectively.
  2. The month in which the studied cryptocurrencies grew the most was in April 2021. during this month the cryptocurrencies represented in the study grew 1300%.
  3. Since the p-value is <0,0001 we consider the correlation between Cardano and Bitcoin statistically significant. Due to the difference in magnitudes, probably Bitcoin is the one that affects the price of Cardano and not vice versa.

Biggest challenges

The biggest challenge during this project was the fact that I spent a lot of time analyzing a dataset that seemed very reliable but ultimately contained erroneous information. However, this serves as a lesson in not always trusting datasets with your eyes closed. From now on, I will be more critical and careful when selecting a dataset.

Highlighted code

    	top_23_crypto.Close AS close_price_cardano
LEFT JOIN top_23_crypto 
	ON bitcoin_cardano.date_ = 
	top_23_crypto.Name = 'Cardano'


Data Viz