Description of work

In this Bounties we want to examine the Most Common Transactions in Metamask users. To do this, we do the following:

• What are the most common transactions for Metamask users?
• What are the most common platforms for those transactions?

To address common transactions, we examine several types of transactions:

• Swap
• Mint NFT
• Sell NFT
• Buy NFT
• Stake ETH with Lido

Note

• We use [ethereum.core] schema, [ez_dex_swaps], [erc20_balances], [ez_nft_mints], [ez_nft_sales] and [fact_event_logs] tables

• The Metamask swap feature contract address is 0x881D40237659C251811CEC9c364ef91dC08D300C

  • etherscan
  • Metamask: Swap Router

• To find Metamask users we use the [ez_dex_swaps] table to find users who have interacted with Metamask swap. So we have:

  • count(distinct origin_from_address) ---> Count Metamask users
  • where
    • origin_to_address= '0x881d40237659c251811cec9c364ef91dc08d300c' ---> Interacted with Metamask swap
    • origin_function_signature = 0x5f575529 ---> Swap transaction list

1 ---> Common transactions by Metamask users

In this section, we calculate the total number of transactions performed by Metamask users. Then we calculate the number of transactions for swap, NFT mint, NFT sale, NFT buy and ETH stake.

The total number of Metamask users is 1003479

According to the results, it can be seen that:

• Metamask users are more inclined to swap and then more sell NFT and buy NFT

According to the results, it can be seen that:

• The highest number of daily transactions for Metamask users is related to swaps, followed by NFT sales
• It is interesting that Metamask users have not done any swap before the swap feature on this platform and have mostly minted NFT, and after creating the swap feature in Metamask in 2020, the swap rate on this platform has increased significantly and in 2021 It has reached its peak.
• From Jun 2021 onwards, Metamask users have a strong interest in 8Mint*, Sales and Buy NFT, and this type of transaction has increased dramatically.

2 ---> Common platforms for Metamask users

To do this, we examine swap and buy and sales NFT transactions separately to find common platforms among Metamask users.

2.1 ---> Common platforms for swap

According to the results, it can be seen that:

• Metamask users are more inclined to swap on uniswap-v2, and the common platform among them is more uniswap-v2.

2.2 ---> Common platforms for NFT sales / buy

According to the results, it can be seen that:

• Metamask users are more likely to buy / sell NFT on opensea, and the common platform among them is more opensea, followed by x2y2
• Metamask users have recently become more inclined to buy / sell NFT on x2y2 From May 2022 onwards