Methodology

• While creating this dashboard, I mostly benefited from ethereum.core.ez_eth_transfers,

  ethereum.core.dim_labels,ethereum.core.ez_dex_swaps , ethereum.core.fact_hourly_token_prices and ethereum.core.fact_transactions tables.

  \

• I used block number '15537351' to filter before and after Merge. The ones below this number represent before the merge, while the ones above this number indicate after the merge.

  \

• After this filter, I created charts by taking values ​​such as volume, transaction number, gas fee from their tables. I divided the transaction number by 3600 to get the hourly tps value.

Introduction

After years of anticipation, The Merge has arrived. Early 15th September morning, Ethereum’s landmark transition to proof of stake went off without a hitch. With tens of billions of dollars of digital assets on the line and zero margin for error, the Ethereum merge consumed the focus and energy of the network’s elite cadre of core developers for almost half a decade which proponents say could boost crypto prices in the long run and significantly change the future of cryptocurrency. The Merge is an upgrade to the Ethereum blockchain, which powers innovations in the crypto ecosystem like non-fungible tokens (NFTs). There's been a boom in crypto investing in recent years, with the value of the overall market more than doubling at one point last year as people piled their money into bitcoin, ether, dogecoin and other cryptocurrencies. Whether you are super into crypto and following every latest development in the space or you own a bit of crypto via a platform like Coinbase or Venmo, if you've heard about the so-called Merge you may be wondering what it actually means for you.

The upgrade transitioned Ethereum from Proof of Work (PoW) to the Proof of Stake (PoS) 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. Proponents say that the transition allows the Ethereum network to reduce its energy consumption by around 99%.

Within the next month, the network’s core developers will have to collectively determine which features they plan to include in Ethereum’s next upgrade, Shanghai. Opinions within the group are torn. And once again, the decision will have multi-billion dollar implications.

Conclusion

In the above analysis, we have seen several increasing trends after the Merge upgrade on the Ethereum ecosystem. This event will have impressive good impacts on the number of transactions, number of users, number of swaps on DEXs, block performance, staking platforms, NFTs ecosystem, and also energy usage. Moreover in the long term (after inflation issue in the whole world and the bearish situation of market), it will have a great positive impact on the price of ETH and other cryptocurrencies and also the DeFi platforms such as AAVE and Compound.

Also, there will be more and more interesting features that will be added to the Ethereum network (such as shanghai upgrade or sharding or etc …). these updates could not be implemented on the Ethereum PoW mechanism. So, After switching to the PoS method, there is actually a bright future for the Ethereum ecosystem and its amazing handy upgrades.

In the transactions section, we have seen an increasing trend in all the analyzed parameters in the post-merge period, which includes the increase in the number of users and as a result, the increase in the number of transactions and the increase in the volume of transactions.