Second Part: Information About DEXs And CEXs

Observations:==

In the above charts, we have shown the share of Swapped ETH Volume, Unique ETH Swappers and Swap ETH tx count and ETH Transfer Volume and ETH Transfer Txn and ETH Transfer Users in Dexs and Cexs. As you can see, miners had a small share in all the charts.

Observations:==

In the two charts on the left, we have shown the volume and number of daily ETH purchase transactions in DEXs. As you can see, the number of transactions has been increasing in a few days after Merge, but the volume of purchase transactions has not changed much.

Introduction

WHAT IS ETHEREUM MINING?

Mining is the process of creating a block of transactions to be added to the Ethereum blockchain.

The word mining originates in the context of the gold analogy for crypto currencies. Gold or precious metals are scarce, so are digital tokens, and the only way to increase the total volume is through mining. This is appropriate to the extent that in Ethereum too, the only mode of issuance post launch is via mining. Unlike these examples however, mining is also the way to secure the network by creating, verifying, publishing and propagating blocks in the blockchain.

Mining ether = Securing the Network

Ethereum, like Bitcoin, currently uses a proof-of-work (PoW) consensus mechanism. Mining is the lifeblood of proof-of-work. Ethereum miners - computers running software - using their time and computation power to process transactions and produce blocks.

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.

Overview

In this dashboard, we have answered this question by checking the following information:

• First Part: Price Information

  \

• Second Part: Information About DEXs And CEXs

  \

• Third Part: Information About Miners' Wallets

Methodology

In the current dashboard, I tried to check Ethereum users for the last 60 days

I used the ethereum.core.ez_dex_swaps and ethereum.core.ez_eth_transfers tables to find swap transactions in dexs and ETH transferred to cexs in September before and after the merge event.

Also, all evaluated criteria were separated with BLOCK_NUMBER = 15537351 as the integration block number, and in some charts September 15th is used as the integration date.

First Part: Price Information

Observations:==

In the above 3 charts, we have shown the comparison of the daily price of ETH with BTC and the daily price of ETH before and after Merge and ETH price volatility before and after merge.

As you can see, the price of ETH has been highly correlated with the price of BTC, especially in September. And as you can see in the chart in the middle of ETH price before and after Merge, it has not changed much.

In the Price Volatility chart, as you can see, there is not much difference between before and after Merge But it was negative a few days after Merge.

Observations:==

The two charts above show the number and volume of transactions to different destinations before and after Merge. As you can see, the largest number of transactions was for Cex, followed by dapps, and the largest volume of transactions was for Dex, followed by Defi.

                                       Number Txn : CEXs = 87 k     >>>>  Dapp = 7 k

                                       Volume Txn : DEXs = 93 k      >>>>  Defi = 48 k

Conclusion

First part: According to this part, we understand that the price of ETH has a high correlation with the price of BTC, which shows that most of the crypto market has decreased and it is not only ETH that has decreased in price.

Second part: According to this part, we understand that buying and selling and transferring ETH by miners has a small share of the total activity of users, which shows that miners have not had a big impact on the price of ETH. Also, the activity of all users in DEXs, CEXs after and before Merge has not changed much.

The third part: According to this part, we understand that the daily ETH transfer by miners has decreased drastically after the Merge date.

About me:

• Author: Hojjat
• Discord: hojjat7878#8809
• Twitter: @hojjat8d
• Email: hojjat78delshad@gmail.com

THANK YOU FOR READING!

Appendix

The solution of this question and the queries are completely used from the filipside database

The construction of the dashboard was also used from the site app.flipsidecrypto.com/velocity, which belongs to flipside

Some of the codes of this dashboard are copied from the following dashboard:

Third Part: Information About Miners' Wallets

Observations:==

In the two charts on the left, we have shown the volume and number of daily ETH sales transactions in DEXs. As you can see, on September 16, which is the day after Merge, the volume of sales was high and the number of transactions was increasing in a few days after Merge.

Observations:==

In the two charts on the left, we have shown the number of daily transfers of ETH by miners and the percentage of transfers of miners compared to the total transfers of ETH before and after Merge.

As you can see, some ETH transfers by miners have increased after March, but the percentage allocated to miners has decreased, which indicates that ETH transfers by other users have increased.

Observations:==

In the two charts on the left, the top 10 wallet addresses to which miners have transferred the largest amount of ETH and the comparison of the daily transfer volume of ETH between miners and other users are shown. As you can see, after the date of Merge, the daily transfer volume by miners has decreased, but for other users, it has been almost constant.