:spiral_notepad: In the following 10 charts, the following comparative parameters are checked on a daily basis

1- Transactions

2- The number of unique wallets

3- Volume

4- Dollar volume

5- The growth of the number of transactions

6- The growth of unique wallets

7- Volume growth

8- Growth of dollar volume

9- Average volume

10 - Average dollar volume

11- The middle of the volume

12- Average dollar volume

:spiral_notepad: In the following 10 graphs, the following comparative parameters are checked in percentage form

1- Transactions

2- The number of unique wallets

3- Volume

4- Dollar volume

5- The growth of the number of transactions

6- The growth of unique wallets

7- Volume growth

8- Growth of dollar volume

9- Average volume

10 - Average dollar volume

11- The middle of the volume

12- Average dollar volume

📋 The following table summarizes the activity of users in BendDAO

📋 What is BendDAO?

BendDAO is the first NFT liquidity protocol supporting instant NFT-backed loans, Collateral Listing, and NFT Down Payment. The seamless experience of down payment, borrowing, and listing creates a perfect closed loop for users, a one-stop NFT liquidity solution.

📋 Methodology

• The ethereum.core.fact_event_logs table was used to find transactions

• Deposits Filters :

   where origin_function_signature = '0x58c22be7'
      and origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88' 
      and block_timestamp>=CURRENT_DATE - 30
      and event_name = 'Transfer' 
      and contract_name = 'WETH9'
  

• Withdraws Filters :

   where origin_function_signature = '0x36118b52'
        and origin_to_address = '0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88' 
        and block_timestamp>=CURRENT_DATE - 30
        and event_name = 'Transfer' 
        and contract_name = 'WETH9'
  

• To extract the dollar price of Ethereum:

  select 
      hour::date as avg_day
      ,avg (price) as eth_price
    from ethereum.core.fact_hourly_token_prices 
    	where symbol ='WETH' 
      group by 1
  

Conclusion

In this dashboard, we reviewed BendDAO Metrics in the last month, based on which →

🟢 The amount of deposit was less than the amount of withdraw and therefore the total amount has become negative

🟢 The highest transaction was on August 21

🟢 The largest withdrawal volume was on August 20

🟢 The largest volume of deposits was on August 25

🟢 Since August 21, we have seen an increase in withdraw compared to deposit

🟢 The highest average withdraw volume was on August 6

🟢 The highest average deposit was on August 27

🟢 The dollar volume of withdraw was about 51% and the dollar volume of deposit was about 49%

written by

Discord ID: Sal☰h#1747

email : saleh.mz@gmail.com

**twitter : **