Introduction

Ethereum is moving to a consensus mechanism called the ( PoS ) participation test from the test work ( PoW ). This has always been the plan, as it is a key part of the community's strategy to scale Ethereum through the updates. However, getting a correct PoS is a great technical challenge and it is not as simple as using PoW to reach consensus across the network. Link

Method

Ethereum had an important upgrade on 2022-09-15 and in block number 15537394, as the merge event. To check the behavior of users, we look at on September as the month of the merge event.

• All metrics on this dashboard separated by block number of 15537394, so that block_number < 15537394 indentified as before merge andblock_number >= 15537394as after merge.
• Also the selected time period was between ‘2022-09-01’ and ‘2022-09-29’

• To deal with this bounty, we use the ethereum.core schema and fact_transactions, core.fact_blocks, aave.ez_deposits, ez_eth_transfers and fact_hourly_token_prices tables.
• The selected platforms to evaluate the staking behaving were, Lido, Stakewise, stkr, Rocket Pool, Cream & Aave, which you can chose them by your own favorite in the header tape.

• Following method have used to calculate the block Interval of various blockchain and compared with Ethereum by POW consensus and POS consensus:

lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as block_time,
datediff(second,block_time,BLOCK_TIMESTAMP) as block_time_diff

Analysis

:telescope: Findings:

As can be seen the price of ETH has decreased from $1640 to $1247 after the Merge compared to before the Merge, which means that the price has decreased by about 25%

✍🏻 Conclusion

• It can be seen that the merge event has had a significant positive effect on all aspects of the Ethereum ecosystem.
• The merge would result in a 99.99% reduction in Ethereum's energy consumption. Therefore, Ethereum will be more environmentally friendly platform.
• As a result of the merge, Ethereum will be able to process transactions more quickly, lower transactions fees, and operate on a most scalability.
• Because of the Ethereum merging, major corporations and financial institutions now have access to a more sustainable platform. For the crypto industry as a whole, this might mean more institutional money flowing into the market.

About:

• Author: HaM☰d

  \

• Discord: 0xHaM☰d#8391

  \

• Twitter: @arjmandi_hamed

  \

• Email: h_arjmandi2012@yahoo.com

Add Text Here

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 prove 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.

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I’m Hamed, Ph.D. In Civil Engineering and interested in data science.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please have a look at my various contact information and let me know what you think.

:telescope: Findings:

• It is clear from the following data that the daily transaction volume and total number of users did not change much either before or after the merger.
• We calculated a drop from 54% to 46% in the given time period, which equates to a drop of around 24% in the total amount of fees paid after the merger.
• There is no discernible difference between the quantity of ETH that has been transferred before and after the merge, however there was a discernible difference in the two days prior to the merge, and its trend was upward.
• The biggest volume of ETH transactions occurs on September 14th (one day before the merge).

:telescope: Findings:

• As you can see from the figures presented above, everyday activity on Ethereum was quite active throughout the month of September, which was the month in which the merging took place.
• Activity levels across the Ethereum ecosystem were quite low in the month leading up to the integration, as can be observed.
• Since the day of the merge, daily transaction execution, TPS, and active wallets have all reached new highs in each instance.
• Moreover. Throughout the month of September, these three peaks represented the highest point.

:telescope: Findings:

• As can be seen from the stats presented above, everyday ETH staking activity on Lido was quite active during the merge month.

• This pattern indicates that a considerable quantity of ETH has been staked since the merge date.

• Prior to the integration, fewer than 2,000 ETH were deposited, most notably on Lido. After the integration, however, the number of ETH appears to have skyrocketed, reaching a daily high of about $18,000 on September 26.

• Average, Max, Min, and Median metrics were all significantly higher after the merge.

The platforms are changeable with the header tape.

:telescope: Findings:

As of two bar charts in the right side, can be observed that, block time interval for Ethereum after the merge is significantly different from before the merge, and also compare to other L1 and POS consensus blockchains.

More than 99% of blocks executed between 10 to 15 sec, while before the merge this range was only 15%, that means the speed of creation block was too raised.

Also the Max of tx per sec from 13k dropped to 55 after the merge.