Untitled Board

The Merge was the joining of the original execution layer of Ethereum (the Mainnet that has existed since Genesis ) with its new proof-of-stake consensus layer, the Beacon Chain. It eliminated the need for energy-intensive mining and instead enabled the network to be secured using staked ETH. It was a truly exciting step in realizing the Ethereum vision—more scalability, security, and sustainability.
The term 'Eth2' has been deprecated. After merging 'Eth1' and 'Eth2' into a single chain, there is no longer any need to distinguish between two Ethereum networks; there is just Ethereum.
To limit confusion, the community has updated these terms:
'Eth1' is now the 'execution layer', which handles transactions and execution.
'Eth2' is now the 'consensus layer', which handles proof-of-stake consensus.
These terminology updates only change naming conventions; this does not alter Ethereum's goals or roadmap.
On Sept. 15, a few minutes before 3 a.m. Eastern time, Ethereum switched from using energy-intensive technology to a more sustainable system in a major update called "the merge."
\n

from ethereum.uniswapv3.ez_lp_actions , uniswap_date , ethereum.aave.ez_withdraws
Uniswap
select trunc(block_timestamp,'day') as day ,
LIQUIDITY_PROVIDER as user ,
tx_hash,
AMOUNT0_ADJUSTED as amount
from ethereum.uniswapv3.ez_lp_actions
where TOKEN0_SYMBOL = 'WETH' and ACTION = 'DECREASE_LIQUIDITY'
Aave
trunc(block_timestamp,'day') as day,
count(DISTINCT DEPOSITOR_ADDRESS) as total_users,
count(DISTINCT tx_hash) as total_tx,
sum(WITHDRAWN_TOKENS)*-1 as total_amount
MakerDao
trunc(block_timestamp,'day') as day,
count(DISTINCT WITHDRAWER) as total_users,
count(DISTINCT tx_hash) as total_tx,
sum(AMOUNT_WITHDRAWN)*-1 as total_amount

Number of users
Number of transactions
Amount
Number of transactions
Number of users
Amount

- The highest number of users was on September 14th. On this day, 616 users belonged to Uniswap, 42 users on Maker and 41 users on Aave.
- The highest number of transactions was on September 14th. On this day, 1003 transactions belonged to Uniswap, 51 transactions on Maker and 374 transactions on Aave.
- The highest number of users was on September 14th. On this day, 616 users belonged to Uniswap, 42 users on Maker and 41 users on Aave.
- The highest number of ETH per user removed was on September 14th. On AAve, this number is -6069. On Maker, it is -344.017 and on Uniswap is -724.21.
- The highest average amount is on September 13th. On Aave is almost 660. On Maker is 328.6 and on Uniswap is 415.2.
- Uniswap had the most transactions of these three platforms with 11.49k, Aave is on the second number with 2846, and Maker is the last one with 327.
- The highest number of users belongs to Uniswap with 3821, Aave had 236 users, and Maker had 231 users.
- The highest amount of ETH had been removed belongs to Uniswap with -4.17million.
- The highest average amount belongs to AAve, with 445.9.


\
Maker | Aave | Uniswap |
---|---|---|
Number of users: 231 | Number of users: 236 | Number of users: 3821 |
Number of transactions: 327 | Number of transactions: 2846 | Number of transactions: 11494 |
Total amount: -65390.566152632 | Total amount: -1273246.82051705 | Total amount: -4170014.68529944 |
Eth per user: -283.076043951 | Eth per user: -5395.113646259 | Eth per user: -1091.341189558 |
Average amount: 199.971150314 | Average amount: 445.97086533 | Average amount: 340.270476157 |
Min amount: 0 | Min amount: 445.97086533 | Min amount: 5.15637934e-10 |
Max amount: 5300.479006018 | Max amount: 36737.49743828 | Max amount: 17934.950719789 |
Median amount: 30.09 | Median amount: 11.0488771 | Median amount: 0.0008845615723 |