❓ Who's Got The Flow?

Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders.

✍🏻 Methodology

In this dashboard, i use 2 table:
- flow.core.fact_events → used for checking the token transfer activity.
- flow.core.dim_contract_labels → used for connecting the token contract address.

some filters for ==token==:

event_contract = 'A.1654653399040a61.FlowToken'
some filters for ==deposit== token:

event_type = 'TokensDeposited'
some filters for ==withdrawn== token:

event_type = 'TokensWithdrawn'

==Whale== = Top 10 user with mostest hold volume (Flow).

📝 Introduction

🟡 What is Flow?

At the end of 2017, the famous game CryptoKitties slowed down the Ethereum network. To solve this problem, Dapper Labs thought of creating a blockchain that works with the proof-of-stake method to be a developed alternative and a platform for future NFT experiences. The blockchain game Cryptokitties was also one of the earliest NFT projects, which faced a lot of crowding, which caused the Ethereum network to slow down. As if the Ethereum blockchain could not respond to such demands! Basically, Flow was created to manage various smart NFTs of computer games or artists' works.

📃 Purposes of dashboard

In this dashboard holding Flow is analyzed :

Total weekly / monthly holders count.
Total weekly / monthly holding volume (Flow).
Total weekly / monthly average holding volume (Flow).
Whale cumulative balance change.
User categorize by volume of hold (Flow).
Top 10 Flow holder.

🟡 Part(1).Total weekly / monthly holders count.

🟡 Part(2).Total weekly / monthly holding volume (Flow).

🟡 Part(3).Total weekly / monthly average holding volume (Flow).

🟡 Part(4).Whale cumulative balance change.

🟡 Part(5).User categorize by volume of hold (Flow).

🟡 Part(6).Top 10 Flow holder.

👀 Observation ( part(1) , part(2) , part(3), part(4))

The count of holders was in ==Apr==, ==Jun== and ==Jul== 2022 was more than other months.
The maximum count of holders was in one week is related to ==third week== of Jun 2022. (==2.799 M== in Jun and ==886.58 K== at third week of Jun).
Total count of holders was ==5.76 M== .
The volume (Flow) of holds was in ==Aug==, ==Sep== and ==Nov== 2022 was more than other months.
The maximum volume (Flow) of holds was in one week is related to ==third week== of Sep 2022. (==3.204 B== in Sep and ==1.53 B== at third week of Sep).
Total volume (Flow) of holds was ==1.51 B== .
The average volume (Flow) of holds was in ==Aug==, ==Oct== and ==Jan== 2022 was more than other months.
The maximum average volume (Flow) of holds was in one week is related to ==third week== of Sep 2022. (==4.991 K== in Sep and ==1.105 B== at third week of Sep).
Total average volume (Flow) of holds was ==263== .
Total minimum volume (Flow) of holds was ==2.17 * 10 ^ -19== .
Total maximum volume (Flow) of holds was ==2.258 B== .

👀 Observation ( part(5) )

results shows that most of the users have hold Flow less than 1 Flow (==99.5%==).

Less than 1 Flow = ==5.636 M
More than 10 K Flow = ==14.58 K
Holding 1 - 10 Flow = ==7.5 K

👀 Observation ( part(7) )

Top 10 user for holding volume (Flow):

🥇 0x8f77d48caf93fd93 46.74 M

:2nd_place_medal: 0x57629229aca26459 27.82 M

:3rd_place_medal: 0x89c1608db1c451ee 16.17 M

📃Contact Data

Discord : Abolfazl#2441

Email : Abolfazl.yeganeh77@gmail.com

Twitter : profile

Twite of this analyze : Link

thanks for Flipsidecrypto team

flipside