My initial thought for this assignment was to determine whether each DEX (Sushiswap & Uniswap) had their own seperate correlations to individual token prices. For example, is Sushiswap more correlated with the price of ETH than Uniswap, while Uniswap is more correlated with the price of MATIC than Sushiswap.

In order to accomplish this I needed a way to determine the average price of a token on each DEX, by day (I couldn't find a table for this, so needed a way to derive it). To do this I found all swaps where the Symbol_In = USDC, and used the amount and price to determine the equivalent USD value of the Symbol_out.

Lastly, I did an Inner Join to only find tokens that were traded on each DEX on the same day, and found the avergage USD. Note that this is not 100% accurate due to gas and transaction fees, but it is what I had to work with.

The below chart shows the results, giving the Date, Token, and average price in USD for each DEX. I also include a column showing which DEX had the best average price for that day.

The chart below will show the number of days, for each Token, you could have gotten a better price on Sushiswap or Uniswap.

Out of curiosity I wanted to see how correlated token prices are across DEX's. For example, when WETH goes on up Uniswap, does it also go up proportionately in Sushiswap?

The results show a high degree of correlation - not surprisingly. At first glance it was interesting to see a negative correlation for USDT and DAI, but since these are stablecoins it makes sense, since the price would be impacted by transaction fees.

This simple pie chart shows the total number of days, across multiple tokens, where you would have gotten a better price on Sushiswap vs Uniswap.

The following two chart compares the daily price of WETH (purple line chart) versus the daily number of transactions on Uniswap (top chart) and Sushiswap (bottom chart). The daily prices of WETH is meant to indicate the overall health of the crypto market.

From January 1st to present day, Uniswap has seen an increase in daily transactions despite an decrease in the price of WETH. Sushiswap, on the other hand, has seen its daily transactions decrease by roughly 2/3rds.

Comparing each DEX by unique Users (origin_from_address), Uniswap has seen a reduction in roughly 1/3rd of it's users, while Sushiswap has seen a reduction by roughly 2/3rds.

This final chart compares average number of transactions per user on each DEX. At the start of the calendar year, both Uniswap and Sushiswap had roughly 1.8 transactions per user each day and this metrics moved closely together for each DEX until August.

In August Uniswap began to gain on Transactions per User, with Uniswap having rougly 3.7 transactions per user consistently in December, while Sushiwap had roughly 2.1.

Note: The dip at the end of the chart is because the final day is not completed yet