Who's Got The Flow?

Introduction

Flow Blockchain

Flow Blockchain is an innovative platform that enables businesses to harness the power of smart contracts and distributed ledgers. Flow’s decentralized platform enables users to make and execute contracts with each other without the need for a third party or centralized intermediary. the platform also enables users to transfer value in a secure, immutable, and transparent manner.

FLOW Token

The native token of this blockchain is also called FLOW, and in the Flow ecosystem, they are used as payment for transaction fees and validation, a medium of exchange, and collateral for data storage services. NFTs and tokens issued on this network are collateralized with FLOW, which is also used to participate in Flow's decentralized governance system.

Image source

Methodology

The purpose of this dashboard is to find Flow token holders, evaluate the effects of their activities on the price of this token, and also track their interactions with the Flow network. In general, holders of a token are divided into several categories: Ordinary users, Platforms including Centralized Exchanges(CEXs), Decentralized Exchanges(DEXs), Defi platforms, and Whales.

The data relating to Flow Blockchain is obtained from flipside.

First, let's define how to determine the token flow holders. Using table flow.core.ez_token_transfers, we can measure the inflow and outflow for a wallet in the Flow blockchain, therefore, using this table and the Flow token address which is equal to A.1654653399040a61.FlowToken, the amount of inflow and outflow to each wallet and as a result, the amount of The net balance for each wallet is determined. Then we define the holding distribution of the wallets, where we divide them into 7 groups, which are specified below.

Tier 1: Less than 10 FLOW
Tier 2: 10-100 FLOW
Tier 3: 100-1K FLOW
Tier 4: 1K-10K FLOW
Tier 5: 10K-50K FLOW
Tier 6: 50K-100K FLOW
Tier 7: More than 100K

Also, by using table crosschain.core.address_labels, we can get the labels of the holders' wallets, and by joining this table and the address table of the holders that we created, the label of each wallet is obtained. Of course, these labels are mostly for the wallets of CEXs, DEXs, and Defi platforms, and the address of other users usually does not have a label. Examining the net inflow and outflow of these wallets (top 20 wallets in terms of the Volume of FLOW held) can also help to study the effect of the behavior of the holders on the price of the flow token.

As mentioned, the wallets that have specific labels are usually related to exchanges and Defi platforms, so by filtering these addresses, we can see the effect of inflow and outflow from the wallets of ordinary users (whales, of course, those who are in the top 20 wallets in terms of the volume of FLOW held.) on FLOW price.

In the end, we will investigate the interaction of the top 1000 FLOW holders.

You can change the time period for the Holders Impact and Interactions sections from the upper part of the dashboard.

Analysis

Key Insights

Since the beginning, 6.92m wallets have transferred the Flow token on the Flow blockchain, of which only 31.6k wallets have more than 0.1 Flow balance.
As a result, only 0.457% of the active wallets on the Flow blockchain are considered to hold Flow tokens.
In terms of the number of wallets, Tier 1 has the highest number, that is, 19.93k wallets have less than 10 FLOW balances.
63% of users keep less than 10 FLOW.
A large number of Wallets have less than 0.1 FLOW in their wallet, which we filtered them.
The important point is the placement of tire 7 in fifth place; 523 wallets store more than 100,000 FLOW.

Key Insights

In the upper left table, the address and balance of all token flow holders are given.
The donut diagram on the upper right shows an important point;

50.2% of the total number of Flow tokens are held by 9 wallets and 49.8% by other wallets.
The chart on the left also shows the top 20 wallets whose labels are available. according to the chart, most of them are related to CEXs: Kraken, Coinlist, and Okex ranked first to third, respectively.

Key Insights

The balance of CEXs and DEXs can be a sign of an increase or decrease in the price of a token.
According to the following graph, which is related to the balance of the wallets of CEXs, DEXs, and Defi platforms over the past 90 days, it can be said that after each price reduction, the balance of these wallets has increased. For example, on September 20, 2022, 38m FLOW was added to the balance of wallets, while the price of FLOW decreased from $2.11 to $1.65 from the 12th to the 20th.

Key Insights

The graph on the left shows the FLOW balances of whales for which a label was not available.
The balance of these wallets usually increases at low prices, and when the price of the token rises, their balance decreases.
By following their behavior, you can make a good prediction of market conditions.
As you can see, on November 16, when the price of the Flow token decreased from $1.87 to $1.23, the balance of these wallets increased by 11.77m FLOW.

In the next part, we will investigate their behavior.

Key Insights

In terms of the number of transactions, TOP 1000 FLOW holders were mostly connected with Kraken and Okex exchanges, so 33.9% and 29.7% of the transactions go to these two exchanges, respectively.
Since November 5, with the decrease in the price of the FLOW token, the number of outgoing transactions from the holders' wallets has increased, and most of them have entered Okex, Kraken, and Coinbase.
In general, the interaction of holders with the Coinbase exchange increased in November.

Key Insights

In terms of Volume, TOP 1000 FLOW holders were mostly connected with the Coinlist, so 51.2% of the Volume goes to this address.
Since November 3, the Volume of FLOW outgoing from the holders' wallets has increased, and most of them have entered Coinlist, Okex, and Kraken.

Holders Overall Stats

Holders Impacts

Holders Interactions

Any Question?

Thank you for being with me so far in this analysis. If you have any questions, you can ask through the following ways. I will be pleased to answer the questions.

Discord: mr_nobody73#9620

Twitter: Mr_Nobody73

**Twitter link for this dashboard: **

Conclusion

About 6.92m wallets have transferred FLOW tokens, of which only 31.6k wallets currently have more than 0.1 FLOW balance.
63% of the Holders keep less than 10 FLOW and 15.1% keep between 10 and 100 FLOW. In general, it can be said that about 80% of wallets hold less than 100 FLOW.
About half the number of FLOW tokens are held by only 9 wallets.
Exchanges and Defi platforms are the biggest holders of $FLOW.
The balance of FLOW holders has increased after the price of FLOW decreased.
The most important wallets that FLOW holders have been associated with have been CEXs.