Open Analytics Bounty: ETH (November 13)

    Open analytics bounties are all about deep dive dashboards into one specific topic.

    Introduction

    What is Hashflow?

    Hashflow is a decentralized exchange designed for interoperability, zero slippage, and MEV-protected trades. It allows you to trade any asset on any chain in seconds simply by connecting your wallet. All trades are commission-free, and all price quotes are executed at their displayed price, giving you the most value for your buck on every trade.

    What makes Hashflow unique?

    Most DEXs rely on automated market makers (AMMs) to enable the buying and selling of assets, and although important, they’re far from perfect. AMMs are capital inefficient, routinely prone to risks like sandwich attacks and impermanent loss, and cannot price non-spot assets.

    By using a request-for-quote (RFQ) model to allow professional market makers to manage liquidity pools, Hashflow solves these issues. In turn, traders and liquidity providers (LPs) gain access to enhanced efficiency, security, and products previously impossible in DeFi.

    What this means for Market Makers

    Instead of a constant-product pricing function commonly used by AMMs, Hashflow allows market makers to source liquidity and price assets using off-chain pricing functions, backed by cryptographic signatures.

    By moving pricing off-chain, market makers can use more sophisticated pricing strategies that factor in off-chain data like historic asset prices, volatility, and other real-world information that allows them to effectively price assets.

    Methodology

    I just use one table in this dashboard:

    Checking HFT token swap activity is done using the ethereum.core.ez dex swaps function.

    These are some of the filters used in this dashbord for HFT token:

    '0xb3999F658C0391d94A37f7FF328F3feC942BcADC') TOKEN IN = lower(")

    Metrics:

    1. overal airdrop stats
    2. users amount by transactions
    3. HFT price comparission
    4. airdrop holders and sellers
    5. users by $USD balance
    6. airdrop transfered addresses

    ==Metric 1 :== overal airdrop stats

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

    Observation

    As Nov. 18, 10:00, 17.5K addresses or users have claimed about 55.7M, or 74.3%, of the 75M tokens made available for airdrop.

    13K people claimed 65% of the total airdrop amount on the first day.

    The largest hourly claimed amount was 20.9M tokens, which were claimed on November 7 at 13:00. With around 5814 users on this day, we also had the most hourly claimants ever. The proportion of airdrop claimed amount reached 28% in the same first hour, and in the following hour, at 14:00, this percentage reached 51%. Therefore, we might infer that the majority of the Airdrop was utilized in the early hours.

    Hourly claimed quantities significantly fell after the airdrop's first day, which was November 7.

    ==Metric 2== :users amount by transactions

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

    Observation

    Approximately 3.48% of users who claimed airdrops thus far received more than 20K tokens, compared to 75.9% of users who received less than 1K tokens.

    Users who got fewer than 1000 tokens were the subjects of the majority of claim transactions in the first hour, but as time went on, their proportion decreased and gave way to higher categories.

    ==Metric 3== :HFT price comparission

    Loading...
    Loading...

    Observation

    Despite being launched and traded on Binance, the HFT token's price fell from 1.27 USD at the start of the claim to its current price of 0.65 USD as a result of market circumstances and selling pressure from claimants. nearly 50% lessening

    Of course, this price decline is not just due to HFT, as we also observe a substantial decline in the prices of ETH and BTC at the same time as this coin.

    ==Metric 4== :airdrop holders and sellers

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

    Observation

    Only 2860 of the persons who claimed the airdrop have kept it, or 16.36% of those who got it.

    According to the hourly data of AirDrop vendors, the majority of users who claimed AirDrop moved or exchanged their AirDrop within an hour of claiming it.

    ==Metric 5 :== users by $USD balance

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

    ==Metric 6 :==airdrop transfered addresses

    Observation

    The shrimp group includes 48.6% of the people who got the airdrop, meaning that their wallet balance is less than $100 USD. There are 104 whale wallets, or wallets having a balance of more than $1 million.

    Shrimps from claimed transcations had a higher percentage than other categories in the early going, but as time went on, this share fell.

    Loading...
    Loading...

    Observation

    Much more than other destinations, 80.6% of the airdrop's total value, or 35.9 million tokens, were transferred to Binance after being claimed. The Mexc exchange comes in second with around 2.53 million tokens. The gap between top and second position is substantial, while this was expected after the token's Binance launch.

    Conclusion

    As Nov. 18, 10:00, 17.5K addresses or users have claimed about 55.7M, or 74.3%, of the 75M tokens made available for airdrop.

    13K people claimed 65% of the total airdrop amount on the first day.

    The largest hourly claimed amount was 20.9M tokens, which were claimed on November 7 at 13:00. With around 5814 users on this day, we also had the most hourly claimants ever. The proportion of airdrop claimed amount reached 28% in the same first hour, and in the following hour, at 14:00, this percentage reached 51%. Therefore, we might infer that the majority of the Airdrop was utilized in the early hours.

    Hourly claimed quantities significantly fell after the airdrop's first day, which was November 7.


    Approximately 3.48% of users who claimed airdrops thus far received more than 20K tokens, compared to 75.9% of users who received less than 1K tokens.

    Users who got fewer than 1000 tokens were the subjects of the majority of claim transactions in the first hour, but as time went on, their proportion decreased and gave way to higher categories.


    Despite being launched and traded on Binance, the HFT token's price fell from 1.27 USD at the start of the claim to its current price of 0.65 USD as a result of market circumstances and selling pressure from claimants. nearly 50% lessening

    Of course, this price decline is not just due to HFT, as we also observe a substantial decline in the prices of ETH and BTC at the same time as this coin.


    Only 2860 of the persons who claimed the airdrop have kept it, or 16.36% of those who got it.

    According to the hourly data of AirDrop vendors, the majority of users who claimed AirDrop moved or exchanged their AirDrop within an hour of claiming it.


    The shrimp group includes 48.6% of the people who got the airdrop, meaning that their wallet balance is less than $100 USD. There are 104 whale wallets, or wallets having a balance of more than $1 million.

    Shrimps from claimed transcations had a higher percentage than other categories in the early going, but as time went on, this share fell.


    Much more than other destinations, 80.6% of the airdrop's total value, or 35.9 million tokens, were transferred to Binance after being claimed. The Mexc exchange comes in second with around 2.53 million tokens. The gap between top and second position is substantial, while this was expected after the token's Binance launch.

    attention

    when Balance < 100 then 'shrimp' when Balance between 100 and 1000 then 'crab' when Balance between 1000 and 10000 then 'octopus' when Balance between 10000 and 100000 then 'fish' when Balance between 100000 and 1000000 then 'dolphin' when Balance > 1000000 then 'whale'

    db_img
    db_img