Introduction

I was researching the behavior of Ethereum's network from the perspective of the various wallet account balance sub-groups. In essence, I separated the various account groups into their own distinct categories. A somewhat unsophisticated method of approaching the problem would be to see how whales maintain their equilibrium over the course of time. Regarding ETH specifically. In a moment, we shall examine the significance of this finding.

Method

In this dashboard I used ***flipside_prod_db.ethereum.erc20_balances ***table to find the wallet addresses that had held most $ETH to the last date, at the first I had chosen top 100 wallet and track their activity on transactions, and assets that them transferred and swapped. then I broaden my statistic community to 5000 top wallets to track their behaving on trading of NFTs and collections that they sold and bought.

I separate all addresses that have held more than 1m in $USD on their wallets and amongst them extract top 100 and top 5000 at the end.

Analysis

==Vis 1 & table 1== shows an overall view Wales on Ethereum network and top 100 wallet addresses balance in ETH and $USD, respectively.

• As of Vis 1, total number of wales on Ethereum that I defined them by balance more than 1m in $USD amount on their wallets are 35.8k number, active whales on May and June are 1344 number and all whales on ETH are 8447 number to date.

Conclusion

• As of results of current dashboard, can observed that, the event of LUNA crashed on May 11th, have had a significant effect on whales behaving on May & June.
• They sold most ETH to other assets such as stablecoins and BTC. and sold most NFTs rather than bought that.

About:

• Author: HaM☰d

  \

• Discord: 0xHaM☰d#8391

  \

• Twitter: @arjmandi_hamed

  \

• Email: h_arjmandi2012@yahoo.com

Identify active wallets with a high balance of ETH (whales).

\n

Visualize the ETH transaction history of these whales in May and June 2022.

In this dashboard I’ll track ETHs whales behaving on ETH network and show activity on transactions count, volume and NFTs market.

Image source

The refresh rate on queries is on Daily

Vis 2 & 3:

On Vis 1 the took placed transactions count by top 100 whales and cumulative growth in daily are shown.

As of this on May 13th the most tx was took placed with more than 22 number by 100 whales. and 301 count of tx to date in total.

And as of Vis 3 daily volume, on May 20th, was in the highest peack with more than 815m in $USD by 100 whales and nearly 4.3B to date in total.

Vis 4, the amount of transactions volume based on tx count are shown.

It can observed that most of volume transacted under 10 count of transactions.

• The 0x07…15c0 & 0x9b…2d59 are top two wallets by their balance that have held at least more than times rather than others.

Vis 6 => 9:

In these two figures balance of top 100 whales based on $USD and ETH on each wallets and top 10 assets that they held are shown, respectively.

• The top 3 assets that they transferred are WBTC, WETH, and DAI, with 40, 23, and 22% based of volume in $USD.
• The top 3 assets that they transferred are DAI, USDT, and FTM, with 26, 11, and 10% based Transactions count.

Whales behaving on NFTs

In this section, I tracked the top 5000 whales behaving on the NFT market and found their activity on sale and buying transactions count and NFT collections.

• All of top 5000 whales held at least one NOUNS on their wallets.
• 75% of them minted Uniswap’s NFT, and on May 12th the most volume was took placed.
• Based on transactions count, more than 87% of selling transactions were on selling the otherside’s NFTs, and in the other hand more than 40% of buying transactions tool placed for that too.
• On May 1 & 2th, the most buying and selling transactions was took placed, respectively.
• Based on amount of transactions volume, more than 72% of selling transactions were on selling the otherside’s NFTs, and in the other hand more than 50% of buying transactions tool placed for that too, and boredapeyachtclub was in the second place with 33 & 42% for selling and buying respectively.

Whales activities on swaps from/to ETH

In the following graphs the count of transactions and amount of transactions volume and shares of these are shown in Visualizes from 17 to 20, respectively.

• As of these we can observed that on May 11 & 12th and on June 13 & 14th, most of transactions count was tool placed for swapped ETH to other assets.
• More than 61% of transactions count took placed for swapped ETH to other assets rather than 38% for swapped from other assets to ETH.
• Based on amount of transactions volume these dates the most volume of ETH swapped to other assets too, with 60% against to 40%, respectively.