Methodology

from ethereum.core.fact_hourly_token_prices
from ethereum.beacon_chain.fact_deposits

slot_timestamp::date as date,
total_new_validator,
cumulative_validator,
count (deposit_amount) as total_deposit,
sum (deposit_amount) as total_deposit_volume,
avg (deposit_amount) as avg_deposit_volume,
count(*) as transaction_number,
sum(deposit_amount) as eth_volume, avg(deposit_amount) as average_eth_volume,
sum(deposit_amount*eth_price) as usd_volume,avg(deposit_amount*eth_price) as average_usd_volume,

Total Transaction

• The total number of transaction was about 37.8K.
• The highest number of daily transaction was 1865 on September 23rd.
• In the second place, The highest number of daily transaction was 1846 on October 26th.
• The lowest number of daily transaction was 143 on September 15th.

Volume Category

• The highest Deposit amount was 32 Ethereum and consisted of 38.6%.
• In the second place, The highest Deposit amount was 28 Ethereum and consisted of 33.7%.
• The highest number of transaction was 32.6K Ethereum and consisted of 87.2%.
• The most Ethereum that used was 1.47B with 32 Ethereum and consisted of 93.8%.

Total Ethereum

• The total Ethereum volume was about 1.1M.
• The total average of Ethereum was about 29.8M.
• The most Ethereum volume was 55.6K on September 26th.
• The least Ethereum volume was 4216 on September 15th.
• The most average of Ethereum volume was 31.78 on November 2nd.
• The least average of Ethereum volume was 23.7 on September 18th.

Total USD Volume

• The total USD volume was about 1.58B.
• The total average of USD was about 42K.
• The most USD volume was 74.8M on October 26th.
• The least USD volume was 5.9M on October 9th.
• The most average of USD volume was 51.17K on November 6th.
• The least average of USD volume was 32.62K on September 30th.

Total Validator

• The total number of validator was about 35.3K,
• The highest number of validator was about 1803 on September 23rd.
• In the second place , The highest number of validator was about 1545 on October 26th.
• The lowest number of validator 151 on October 9th.
• The total number of validator increased significantly on September 23rd, September 27th and October 26th.

Total Deposit

• The highest number of daily deposit was 1885 on September 23rd.

• In the second place, The highest number of daily deposit was 1846 on October 26th.

• The lowest number of daily deposit was 156 on October 9th.

• The most daily deposit volume was 55.6K on September 23rd.

• The least daily deposit volume was 4528 on October 9th.

• The most Average of daily deposit volume was 31.78 on November 2nd.

• The least Average of daily deposit volume was 23.7 on September 18th.

  \

Slashed VS Not Slashed Blocks

• The total number of slashed block was 23.
• The total number of not Slashed block was about 399.6K.
• The total number of slashed block was so low so we can ignore them.
• The highest number of not slashed block was 7175 on October 2nd.
• The highest number of slashed block was 16 on September 23rd.

Conclusion

• The total number of transaction was about 37.8K.
• The total Ethereum volume was about 1.1M.
• The total USD volume was about 1.58B.
• The total number of validator was about 35.3K.
• The total number of slashed block was 23 and The total number of not Slashed block was about 399.6K.

Twitter : hadi3_bgh

Discord : hadiseb#1688

ETHEREUM Merge

The Merge was executed on September 15, 2022. This completed Ethereum's transition to proof-of-stake consensus, officially deprecating proof-of-work and reducing energy consumption by ~99.95%.

The Merge was the joining of the original execution layer of Ethereum 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.

What is slashing on Ethereum?

Slashing describes the process whereby other network participants forcibly eject an offending validator from the Beacon Chain while continuously draining their balance. In the most extreme cases, a slashed validator may lose their entire stake in the network.