\

/ ETH Merge: Selling Event /

✍️ Description of Work

• Number of Transactions who Transfer ETH

• Number of Miners who Transfer ETH

• Volume of Transfer ETH

• ETH price

• swapper- Number of Miners

• Number of Swaps

• ETH swaps in and out before and after merge

• Top miner

• Selling ETH Transactions in DEXs

• Selling ETH Volume in DEXs

• total Swap Volume To Top tokens From ETH three different times

• Swap Volume To Top tokens From ETH

• The amount of the miner's wallet that has been transferred to it

🧠 Methodology

Number of Transactions ,Miners,volume Transfer ETH:

from ethereum.core.ez_eth_transfers
where origin_from_address in ( select miner from miner) and date >= CURRENT_DATE - 30

ETH price:

FROM ethereum.core.fact_hourly_token_prices
WHERE HOUR::DATE >= '2022-09-01'

swap in and swap out:

 from ethereum.core.ez_dex_swaps where (symbol_in='WETH' or symbol_out='WETH') and block_timestamp between '2022-09-10' and '2022-09-20' 
and amount_in_usd<1e9 and amount_out_usd<1e9

Top miner:

from ethereum.core.fact_blocks
where block_timestamp >= '2022-06-11'

Volume in DEXs and Transactions in DEXs:

FROM ethereum.core.ez_dex_swaps
  WHERE SYMBOL_IN = 'WETH'

minner transfer

ROM ethereum.core.ez_eth_transfers a join ethereum.core.dim_labels b on a.ORIGIN_TO_ADDRESS = b.address
  WHERE BLOCK_TIMESTAMP::date >= '2022-09-01'

What Is Crypto Mining?

The simple way to think of cryptocurrency mining is that it’s a way to create new digital “coins.” But the simplicity ends there. To dig those coins up, you’ll need to solve complicated puzzles, validate cryptocurrency transactions on a blockchain network and add them to a distributed ledger.

Because digital platforms can be easily manipulated, additional security measures are put into place. For example, only verified miners can update transactions on Bitcoin’s ledger, which helps prevent double-spending.

\n Miners arethe folks who solve computational puzzles to add new blocks to the blockchain. Those who don't have a lot of computing power often join mining pools to earn a solid source of income. You can mine independently, but you'll have a much smaller chance of solving a block on the chain.

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.

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.

- ETH swaps in and out before and after merge -

✍🏻 Conclusion

1. According the Number of Transactions who Transfer ETH we see after merge the number of transition sharply decrease .The high Number of Transactions who Transfer ETH in sep15 the number is 137.35k

2. According Number of Miners who Transfer ETH we see after merge the number of transition sharply decrease .The high Number of Miners who Transfer ETH in sep15 the number is 140

3. According Volume of Transfer ETH we see after merge the number of transition sharply decrease .The high Number of Miners who Transfer ETH in sep1 the number is 233.0799M

4. According to the ETH price chart, we can see that the price has dropped after the merge. In fact, since September 11, the price has fallen. In fact, when Marge happened, this news was already considered dead because the previous growth of Merge proves that this news was fueled by the growth of Eth.

5. The amount of the miner's wallet that has been transferred to it

   • Befor merge
     • Dex Amount:20.466k
     • Cex Amount:10.905k
     • layer3 Amount:8263
     • Defi Amount:5265
     • operate Amount:4227
     • nft Amount:1586
     • dapp Amount:61.32
   • After Merge
     • Dex Amount:16.64977
     • Cex Amount:3134
     • Defi Amount:2753
     • nft Amount:2431
     • dapp Amount:1578
     • operate Amount:1431
     • layer3 Amount:578
     • flotsam amount:0.12

6. Swap Volume To Top tokens From ETH three different times

   • After: 7184232.601
   • Before :3716920.004
   • Merge day :2607418.11

7. Top miner