Question:

Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.

Approach:

One the main features of the Metamask is its application to swap assets. The aim of this essay is comparing the swap feature of Metamask vs Uniswap and Sushiswap as largest swap tools on Ethereum.

The metrics that used to handle this comparison and the methodology of calculation represented as below:

• The Metamask users identification

   from ethereum.core.fact_event_logs
   where ORIGIN_TO_ADDRESS='0x881d40237659c251811cec9c364ef91dc08d300c'
   and EVENT_NAME='Swap'
  

• The volume of Metamask swaps

   According to investigation it appears on transfer table so use
   from ethereum.core.ez_token_transfers and selecting metamask users as sender
  

• Uniswap and Sushiswap

   from ethereum.core.ez_dex_swaps
   by selecting where PLATFORM='uniswap-v2' and where PLATFORM='sushiswap'
  

• Fee analysis

   sum(TX_FEE)
   FROM ethereum.core.fact_transactions 
  

• Time period

   BLOCK_TIMESTAMP>='2022-05-01' -- Analyze since start of May, 2022
   
  

Results:

The analysis related to the swap volume and average amount of swapped presented in two graphs. According to these graphs:

The blue color is stands for Metamask. The red one is for Sushiswap and the green lines for Uniswap.

1. The swap volume of Metamask and Uniswap are close together but volume of Sushiswap are lower than these two.
2. The volume of swaps for all platforms increased on May 12th, 2022 and the main reason of that is the market downturn.
3. The average swapped amount for Metamask is larger than other two platforms as can be seen from the second graph.
4. The swap volume and average amount of Metamask swaps experienced its higher level on June 16th, 2022.

The number of swaps executed by various platforms displays in this line graph.

From this graph, it can be seen that the Uniswap has dominated the swap count in daily basis. Furthermore, the swap count of Sushiswap and Metamask are colse together but Sushiswap has a little more swaps than Metamask.

The captured fee by various swap platforms has been illustrated and compared according to this chart.

By the use of results of this graph, the captured fee from Metamask swaps is lower than other two . Most of the fees captured from Uniswap swaps and Sushiswap stands in the second place.