BendDAO Metrics

    -- Q1. Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings

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

    Methodology

    • The base SQL query is based off another query, which is then modified for these results. SQL Credit - query
      • It looks at the following filters for Deposits

        where contract_address = '0x70b97a0da65c15dfb0ffa02aee6fa36e507c2762'
          		and topics[0] = '0x443ff2d25883a4800d36062db52ca3dd7ced05bd8627c8a6a37f8699715b5431'
        
      • It looks at the following filters for Withdraws

        where contract_address = '0x70b97a0da65c15dfb0ffa02aee6fa36e507c2762'
          		and topics[0] = '0x3ed4ee04a905a278b050a856bbe7ddaaf327a30514373e65aa6103beeae488c3'
        
      • \

    • The base SQL gives us the deposit and withdraw transactions, we then calculate the required metrics based off of the transactions.

    Overall Metrics

    • In total there were 505 Deposits and 81.5K $ETH deposited in the past month.
    • In total there were 511 Deposits and 82K $ETH withdrawn in the past month.

    ETH Amount over time

    • On most of the days in the past month we saw > 5K $ETH deposits per day.
    • The withdraws were around 2K $ETH on most days with a fews days with >5K $ETH withdraws.
    • Max deposit was 16.6K ETH on Sep 7 and Max withdrawal was 16K on Sep 6, 2022.

    Number of Wallets

    • On most of the days in the past month we saw 10-20 depositors per day.
    • The withdraws were around 10-20 withdrawers on most days as well.
    • Max number of depositors were 57 wallets on Aug 21 and Max withdrawers were 63 on Aug 21, 2022.

    Number of Transactions

    • On most of the days in the past month we saw 10 deposits per day, with also 30-60 on few days.
    • The withdraws were around 20 on most days.
    • Max number of deposits were 66 on Aug 21 and Max withdrawals were 88 on Aug 21, 2022.

    Cumulative Numbers Transactions vs Amount

    • The number of transactions seems to have direct co-relation with the amount deposited in the past month.
    • However, the number of transactions don’t seem to have a direct co-relation with the amount withdrawn in the past month.

    Conclusion

    • BendDAO seems to be a unique offering that is catching traction with healthy metrics in terms of amount, number of deposits and wallets.