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

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    :writing_hand: Observations

    • 5.7M wallets, which is more than 99.5% of the wallets, have less than 1 Flows.
    • Only 130 wallets have more than 10,000 Flow balance and we can say that these are Flow whales.
    • 15.5k wallets have between 10 and 20 Flows.
    • The average balance wallets that have Flow is about 43 Flows.
    • The maximum balance of Flow in wallet is about 627M Flows.

    ✍️ Observations

    Because the number of wallets below 1 is very high, in this section the wallets that have more than 1 Flow are analyzed.

    • The maximum number of wallets has a balance between 10 and 20 Flow, about 15.5k wallets with 72%.

    • 10% of wallets have between 100 and 1000 Flow.

    • Less than 1% of wallets have more than 10,000 Flow.

      \

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Top 10 Wallets

    ✍️ Observations

    • The largest balance of the Flow wallet belongs to Address 0x8624b52f9ddcd04a with 627M Flows and 76.4%.
    • 0x8f77d48caf93fd93 wallet with balance of 91M Flows and 0x57629229aca26459 wallet with balance of 28.8M Flows are in the next ranks.

    Top 10 Flow holders in ETH chain

    The Behavior of Whales

    Conclusion

    • 5.7M wallets, which is more than 99.5% of the wallets, have less than 1 Flows.
    • Only 130 wallets have more than 10,000 Flow balance and we can say that these are Flow whales.
    • The average balance wallets that have Flow is about 43 Flows.
    • The maximum balance of Flow in wallet is about 627M Flows.
    • The maximum number of wallets has a balance between 10 and 20 Flow, about 15.5k wallets with 72% (Wallets with a balance of more than 1 Flow).
    • 10% of wallets have between 100 and 1000 Flow (Wallets with a balance of more than 1 Flow).
    • Less than 1% of wallets have more than 10,000 Flow (Wallets with a balance of more than 1 Flow).
    • The largest balance of the Flow wallet belongs to Address 0x8624b52f9ddcd04a with 627M Flows and 76.4%.
    • 0x8f77d48caf93fd93 wallet with balance of 91M Flows and 0x57629229aca26459 wallet with balance of 28.8M Flows are in the next ranks.
    • Wallet 0x7316b2515940a8573e34f45900e82763ad34a34a, named uniswap: pool, has the highest number of Flows in Ethereum chain with balance 669k flows and about 24%.
    • From the second half of September, whales have started to collect Flow, and after that the transactions were fixed, and again in the second half of November, they increased the balance flow.

    overall stat

    db_img

    Introduction

    What is Flow?

    Flow is a blockchain platform that originally was designed for gaming purposes, but has expanded since its launch in 2020. The flow blockchain enables fast, low-cost transactions and supports smart contracts. It powers blockchain applications including NBA Top Shot, a non-fungible token (NFT) offering.

    Metric

    The metrics analyzed in this dashboard:

    • Total Flow holders
    • Total/average/maximum Flow balance in wallets
    • Distribution number of wallets by flow balance
    • Top 10 wallets by flow balance
    • Top 10 Flow holders in ETH chain
    • Inflow/outflow top 10 Flow wallets in the last 90 days
    • cumulative transactions in the last 90 days

    Method

    I first found the amount of flow per wallet in the following method:

    • Deposit=> I got the amount of flow deposited sum (event_data:amount) to event_data:to from flow.core.fact_events table and with

      event_contract = 'A.1654653399040a61.FlowToken' and

      event_type = 'TokensDeposited' and tx_succeeded = 'TRUE' filter.

    • Withdraw=> I got the amount of flow withdrawal sum (event_data:amount) to event_data:from from flow.core.fact_events table and with

      event_contract = 'A.1654653399040a61.FlowToken' and

      event_type = 'TokensWithdrawn' and tx_succeeded = 'TRUE' filter.

    • Then I obtained the balance value of each wallet by the sum difference of the deposit value with withdrawal value sum (deposit_amount - withdraw_amount) as balance

    • Finally, by joining with the flow.core.dim_contract_labelstable, I got the balance of each address.

    ✍️ Observations

    In this part, I analyzed the behavior of whales in the last 90 days.

    You can see the changes in the balance of the top 10 wallets of Flow along with the cumulative transactions.

    From the second half of September, whales have started to collect Flow, and after that the transactions were fixed, and again in the second half of November, they increased the balance flow.

    It seems that the whales have started their activities to collect Flow.

    Distribution

    Wallet 0x7316b2515940a8573e34f45900e82763ad34a34a, named uniswap: pool, has the highest number of Flows in Ethereum chain with balance 669k flows and about 24%.

    THANK YOU FOR READING!

    Twittermohsen.dastpeyman

    Discord_id: mohsen#4796