Benqi Finance is a DeFi platform on the Avalanche blockchain. It offers various financial services and ways to earn money. Using Avalanche's fast and cheap transactions, Benqi Finance provides a smooth experience. One of its main features is lending and borrowing, where users can earn interest on their crypto or borrow against their assets. This allows people to make money from their idle assets. Benqi Finance also has yield farming, where users can earn rewards by providing liquidity. It focuses on security and user control to ensure the safety of assets and transactions. Overall, Benqi Finance is a leading DeFi platform on Avalanche, helping users maximize their crypto assets in a secure and easy way.

• In this dashboard, we explore BenQi's finance protocol and its different services. We also perform an in-depth analysis to segment users based on their behaviors and characteristics. This analysis helps us gain insights into the different types of users who are actively participating in the BenQi finance protocol.

https://twitter.com/CaesarJulius0/status/1676969379353989122?s=20

The first table is focused on aggregating transaction and user data on a daily basis. In the provided code snippets, two different queries are used to analyze data from the "avalanche.core.ez_decoded_event_logs" table and the "avalanche.core.dim_labels" table for the purpose of analyzing transaction and event data related to the "benqi finance" project on the Avalanche network in the year 2023.

The second table aims to retrieve and analyze data related to transactions and amounts for the "Mint," "Borrow," "RepayBorrow," and "Redeem" events within the "benqi finance" project on the Avalanche blockchain. The method used for calculating the amount is:

CASE WHEN e.event_name = 'Mint' THEN e.decoded_log:mintAmount WHEN e.event_name = 'Borrow' THEN e.decoded_log:borrowAmount WHEN e.event_name = 'RepayBorrow' THEN e.decoded_log:repayAmount WHEN e.event_name = 'Redeem' THEN e.decoded_log:redeemAmount

The project name is found by using the condition:

WHERE project_name = 'benqi finance'

The third table analyzes staking and unstaking events in Avalanche. The method used for finding related transactions is:

COUNT(DISTINCT CASE WHEN event_name = 'Submitted' THEN tx_hash END) AS staking_tx, COUNT(DISTINCT CASE WHEN event_name = 'Withdraw' THEN tx_hash END) AS unstaking_tx,

The Avax contract is found by using the condition:

contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'

Finally, we will see the analysis of the native token of this platform, which includes the holders, the swap volume, its price correlation with Ether, and the status of its transactions. The source tables used are:

avalanche.core.fact_hourly_token_prices, avalanche.core.ez_token_transfers, avalanche.core.ez_dex_swaps

The symbol used for filtering is:

Symbol like 'qi '

Benqi Finance on Avalanche showcases impressive growth, user adoption, and transactional activities. The platform has successfully attracted and retained users, with consistent new user acquisition. While liquidity and token performance have experienced fluctuations, they indicate an active ecosystem. To sustain growth and address challenges, Benqi Finance could focus on enhancing liquidity dynamics, analyzing unstaking trends, and strategizing to revitalize interest in the native token "QI." With its positive trajectory and active community, Benqi Finance on Avalanche holds promising prospects for continued success and development in the decentralized finance landscape.