What is the Ethereum Merge?

This Ethereum upgrade or "Merge," as it's being referred to, changed how new crypto transactions take place on the blockchain.

Previously, the Ethereum blockchain, like the Bitcoin blockchain, ran on a proof-of-work model, which involves nodes — computers that are part of a large network — competing with one another to solve complicated math problems. The successful ones are then able to mine the next block of a transaction and create new coins.

The upgrade transitioned Ethereum to the proof-of-stake model, which is a more energy-efficient and environmentally-friendly system. It entails nodes being selected via an algorithm that has a preference for nodes that hold more of a network's currency.

In other words, their "stake" in the network is rewarded over the computer power that's rewarded in the proof-of-work system.

Methodology:

To make this dashboard, instead of using the date of Merge event, we used Merge block number for division. We examine the following parameters in this dashboard:

• data about Blocks

• data about Swap transactions to Ether

• data about transactions

• data about ether stake

We have to build this dashboard from tables:

• ethereum.core.ez_eth_transfers

• ethereum.core.ez_dex_swaps

• ethereum.core.fact_blocks

• ethereum.core.fact_transactions

  Because at the time of preparing this dashboard, 9 days have passed since Merge, to compare the data, we checked the last 18 days (9 days before Merge and 9 days after Merge).

BLOCKS:

As can be seen in the graphs below, the number of unique miners after Merge is almost 30 times higher than the same time period before Merge , but the number of blocks mined before Merge is almost 2 times that of blocks mined after Merge , but the number of transactions per block is more in the period before Merge.

SWAPS:

But in the swap section, we do not see significant changes in different sections For example, in the sections of the number of unique swappers and the number of swap transactions performed in the time period we have defined, no noticeable change can be seen, but in the section of the volume of swap transactions after Merge, we see an increase in the volume of swaps to ETH.

TRANSACTIONS:

In the transactions section, we have seen an increase of approximately 25% in the total number of transactions and daily transactions, but despite the fact that the number of transactions and gas used for each transaction has increased, but transaction fee for each transaction has decreased, and this is one of the effects of Merge.

STAKES:

In this section, we used Ankr, Lido, Rocket, Pool, Stakewise pools

ankr origin to address: ‘0x84db6ee82b7cf3b47e8f19270abde5718b936670’

Lido origin to address: '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

Rocket Pool origin to address: '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58'

Stakewise origin to address: '0xc874b064f465bdd6411d45734b56fac750cda29a'

But in the stake section, we see a significant difference in our defined time frame in the section before and after Merge For example, the number of staked ethereums after Merge has grown approximately 8 times compared to the same time period before Merge, and the number of stakers has also grown approximately 2 times.

Conclusion:

After the Merge, there have been changes in the users behavior in the Ethereum network, for example, the number of transactions has increased due to the decrease in the transactions fee, but we had the biggest change in the number of transactions and the volume of stake transactions, which is also due to the change in the working mechanism of the main Ethereum network from POW has been to POS.

BLOCKS: