ETH Merge: Actually Good?
-- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. -- We want you to prov11e one side or the other, with the help of Flipside data. -- Demonstrate whether the Merge had positive or negative effects on the network. -- Include least three queries and visualizations in your submission.
NFT Metrics
Number of NFT Sales
-
Looking at the NFT Sales there is slight uptick in the number of sales after the merge.
- The highest daily was around 50K, whereas we see a lot of days around 60K after the merge.
- Opensea is still the dominant NFT Sale platform, with 618K sales before the merge and 591K sales after the merge.
- X2Y2 is comes in second, with 40K sales before the merge and 43K sales after the merge.
\
Number of NFT Buyers
-
Looking at the NFT Buyers there is slight uptick in the number of buyers after the merge.
- The highest daily was around 20K, whereas we see a lot of days around 25K after the merge.
- Opensea is still the dominant NFT Sale platform for buyers, with 297K before the merge and 266K sales after the merge.
- X2Y2 is comes in second, with 40K buyers before the merge and 43K buyers after the merge.
User and Transaction Metrics
Number of Users
- Looking at the number of users there is a slight uptick in the number of users after the merge as well.
- The highest daily was around 459K on Sep 4, 2022, whereas we see a lot of days around 410K after the merge.
- Sep 17, 2022 is quite surprising with 586K active users on a day.
- In total we saw 5.38M users in 90K blocks before the merge vs 5.25M users after the merge.
Number of Transactions
- Looking at the transaction frequency there is a slight uptick in the number of daily transactions after the merge, the numbers however seem like they are coming back to before the merge numbers.
- The highest daily was around 1M, whereas we see a lot of days around 1.1M-1.3M after the merge.
- In total we saw 15M transactions in 90K blocks before the merge vs 14..8M transactions after the merge.
Gas Used
- Looking at the Gas Used Numbers, there has been a reduction in the gas used per day, even though the number of transactions has increased.
- Now this very well might be due to price of ETH decreasing.
- The highest in the 90K blocks before the merge was 4M $USD vs 2.9M $USD before and after the merge.
- We do see the overall Gas being reduces quite a lot for the 90K blocks after vs before
- 40M $USD for 90K block before the merge.
- 26M $USD for 90K block after the merge.
$ETH Price
- ETH price however has seen quite a lot of decrease in value after the merge, it has nothing to with the merge, however it has more to do with the market overall.
- Before the merge it was around 1.6K $USD, whereas it is now at 1.36K $USD.
Swap Metrics
Number of Swaps
-
Looking at the swap frequency there is not much uptick in the number of swaps after the merge.
- The highest daily was around 110K, whereas we see a lot of days around 120K after the merge.
- Uniswap-V2 is still the dominant swap platform, with 893K swaps before the merge and 851K swaps after the merge.
- Uniswap-V3 is comes in second, with 497K swaps before the merge and 513K swaps after the merge.
- This is quite odd that the top two most popular swap platforms saw a decrease in swap frequency, where as a Sushiswap on the other hand saw an increase from 115K to 126K.
\
Number of Swappers
-
Looking at the number of swappers there is no change in the number of swappers after the merge as well.
- It has been consistent around 40K swappers.
- Uniswap-V2 is still the dominant swap platform, with 298K swappers before the merge and 258K swappers after the merge.
- Uniswap-V3 is comes in second, with 214K swappers before the merge and 196K swappers after the merge.
What Is the Ethereum Merge?
-
The Merge is the official name of the Ethereum blockchain's transition from PoW to PoS. Like Bitcoin, Ethereum is well known for its environmental impact, requiring more power than numerous large countries to keep its blockchain up and running and secure. After switching to PoS, it is thought Ethereum will consume 99.9 percent less energy.[1]
-
As gratuitous energy waste is one of the main criticisms of cryptocurrency in general and specifically NFTs (many of which are minted on the Ethereum blockchain), that the Merge will tackle one of the biggest consumers is likely to go down well across the board.
\
When Did the Ethereum Merge Happen? Is the Merge Complete?
- The Ethereum Merge took place on 15 September 2022 at block 15537351
- The Merge took years of planning, but as soon as the Ethereum blockchain hit the correct Total Terminal Difficult (TTD) of 58,750,000,000,000,000,000,000, the transition was instantaneous.
- There was no pause to boot up different software or load something else, the transition was automatic.
Methodology
- To get a comparative analysis we look at 90000 blocks in this analysis both before and after the merge block 15537351
- We look at the data from
ethereum.core.fact_transactions
,ethereum.core.ez_dex_swaps
andethereum.core.ez_nft_sales
tables and compute various metrics to answer the questions above. - Such as transactions frequency, swap frequency, NFT sales, etc.
Number of block before and after the merge can be updated via the parameter above
Conclusion
- All metrics expect the price see a slight uptick in the numbers after the Merge.
- There is nothing out of the ordinary though, except increase in the number of users on Sep 17, 2022.
- NFT Sales and Swaps have seen in increase overall as well.
- Ethereum after the merge seems to have been better in terms of the Gas used overall going down, and the block times being reduced as well.
- So overall I would say yes, Ethereum has become faster.
Overview
To answer if the merge is actually good we look at a few metrics like the following:
- Block Metrics
- Number of Transactions
- Number of Users transacting
- $ETH price affected
- Number of Swaps across various platforms.
- Number of Swappers across various platforms.
- Number of NFT Sales across various platforms.
- Number of NFT Buyers across various platforms.
Block metrics
Gas Metrics per Block
- Gas metrics before and after the merge are quite comparable at a block level, except the max gas used per block.
- We have seen the maximum gas used go down from 64 $ETH to 46.4 $ETH
Transactions per Block
- All the metrics are quite comparable, we don’t see much change in the numbers.
Time Difference(seconds) between two Blocks
- Minimum, Average and Medium number of quite comparable but slightly reduces after the merge.
- The clear winner is the max difference between two block as it is quite a bit low after the merge, 175 vs 55 seconds.
