❓ 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.

Instant NFT-backed Loan

BendDAO is the first decentralized peer-to-pool based NFT liquidity protocol. NFT holders are able to borrow ETH through the lending pool using NFTs as collateral instantly, while depositors provide ETH liquidity to earn interest. The leveraged NFT trading is built on instant NFT-backed loans. → More

BendDAO Links

• Website, Docs, GitHub, Dework, Twitter

✍️ Description of Work

In this dashboard, we want to examine and analyze deposits and withdrawals for BendDAO . For this, we check the following:

• Deposits and Withdrawals Volume (ETH) in Past Month and compare to the Rest of the Year
• Deposits and Withdrawals Transactions in Past Month and compare to the Rest of the Year
• Deposits and Withdrawals Users in Past Month and compare to the Rest of the Year

🧠 Methodology

To deal with this section, we use the ethereum.core schema and the fact_event_logs table.

Query 1 → Find_Deposit:

contract_address = '0x70b97a0da65c15dfb0ffa02aee6fa36e507c2762' and topics[0] = '0x443ff2d25883a4800d36062db52ca3dd7ced05bd8627c8a6a37f8699715b5431'

In this condition, we use the contract address of BendDAO: LendPool. In this condition, we use the contract address BendDAO: LendPool, where users Deposit through BendDAO: LendPool

• topics[0] = '0x443ff2d25883a4800d36062db52ca3dd7ced05bd8627c8a6a37f8699715b5431' -> Get Deposit Transactions

Query 2 → Find_Withdraw:

contract_address = '0x70b97a0da65c15dfb0ffa02aee6fa36e507c2762'	and topics[0] = '0x3ed4ee04a905a278b050a856bbe7ddaaf327a30514373e65aa6103beeae488c3'

In this condition, we use the contract address of BendDAO: LendPool. In this condition, we use the contract address BendDAO: LendPool, where users Withdraw through BendDAO: LendPool

• topics[0] = '0x3ed4ee04a905a278b050a856bbe7ddaaf327a30514373e65aa6103beeae488c3' -> Get Withdraw Transactions

1 → Deposits and Withdrawals Volume (ETH) in Past Month and compare to the Rest of the Year

✅ Observations

Based on the obtained results, it is determined that:

• The total amount of Deposits since the beginning is 315K ETH, of which 65.8K ETH is related to the last month (Last 30 days), which is about 20.88%.
• The total amount of Withdrawals since the beginning is 288K ETH, of which 77.5K ETH is related to the last month (Last 30 days), which is about 26.9%.
• The volume of withdrawals has been higher than deposits in the past month (Last 30 days)
• The Top withdrawals and deposits in terms of volume (ETH) were made by 6 unique addresses
• In the past month (Last 30 days), the largest volume of withdrawals was on September 6 and August 20, and the largest volume of deposits was on August 25.

2 → Deposits and Withdrawals Transactions in Past Month and compare to the Rest of the Year

✅ Observations

Based on the obtained results, it is determined that:

• The total Number of Transaction for Deposits since the beginning is 1683, of which 455 is related to the last month (Last 30 days), which is about 27.03%.
• The total Number of Transaction for Withdrawals since the beginning is 1591, of which 481 is related to the last month (Last 30 days), which is about 30.23%.
• The Number of Transaction for withdrawals has been higher than deposits in the past month (Last 30 days)
• In the past month (Last 30 days), the largest Number of Transaction for withdrawals and deposits was on August 21.

3 → Deposits and Withdrawals Users in Past Month and compare to the Rest of the Year

✅ Observations

Based on the obtained results, it is determined that:

• The total Number of Unique User for Deposits since the beginning is 784, of which 285 is related to the last month (Last 30 days), which is about 36.35%.
• The total Number of Unique User for Withdrawals since the beginning is 674, of which 284 is related to the last month (Last 30 days), which is about 42.13%.
• In the past month (Last 30 days), the largest Number of Unique User for withdrawals and deposits was on August 21.
• Out of 285 depositors in the last month, 216 of them are New users, which is about 76.49%.
• Out of 284 user for withdrawal in the last month, 181 of them are new users, which is about 63.73%.

✔️ Final Conclusion

According to the results obtained from the review of withdrawals and deposits in BendDAO in the last month, it was determined:

• The total Volume of Deposits (Last 30 days) is ==65.8K ETH
• The total Volume of Withdrawals (Last 30 days) is ==77.5K ETH
• The total Number of Transactions for Deposits (Last 30 days) is ==455
• The total Number of Transactions for Withdrawals (Last 30 days) is ==481
• The total Number of Unique Users for Deposits (Last 30 days) is ==285
• The total Number of Unique Users for Withdrawals (Last 30 days) is ==284