Question:

Q2. What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.

Approach:

MetaMask allows users to store and manage account keys, broadcast transactions, send and receive Ethereum-based cryptocurrencies and tokens, and securely connect to decentralized applications through a compatible web browser or the mobile app's built-in browser.

In this essay after obtaining the Metamask users, the behavior of these users has been estimated based on the most common transactions.

The analysis of this essay contains the following investigation:

1. First found the main sectors that Metamask users interacted with
2. Analyze the sub-sectors by programs name.

Results:

The main sectors that users of Metamask interacted with have been shown in this pie graph.

According to this graph, the most used sector by these users is DEXs. It can be said that, these users use DEXs to swap cryptocurrencies or provide liquidity to pool.

The NFT and Layer2 sectors are in the next places as shown in this graph.

The most use DEXs by Metamask users is Uniswap as illustrated in this figure.

According to the first graph of results sections, the second most used sector by Metamask users is NFT. As presented in this graph, the very large group of users interacted with OpenSea as a NFT marketplace on Ethereum.

The domination of Opensea is obvious and expected because of the popularity of this NFT marketplace.

Top 10 DeFi programs by Metamask users arranged and shown in this graph. Based on this graph, the Aave and Compound are two of the most used programs by Metamask users.

The OlympusDao stands in the third rank with 15% of transactions by Metamask users in DeFi programs.

One the most common transactions by Metamask users is Layer2. The application of Layer2 by Metamask users demonstrated in this bar graph. As revealed in this graph, the HOP protocol and Poylgon bridges are two of the most used Layer2 bridges between Metamask users.

The methodology of this essay has been shown as:

• Identification of Metamask users

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

• The analyze of these users activity

     from ethereum.core.fact_transactions by joining label table with destination address
     
  

Finally, the application of Dapps by Metamask users displayed in this pie chart. According to this chart, the Umbria and PoolTogheter are most used Dapps by Metamask users respectively.