Top Kashi Pairs III

    Q81. Find the top 5 kashi pairs based on: A- The number of loans they have generated, B- The total available for lending (in USD), C- Total collateral deposited (in USD)

    Introduction

    The Sushiswap platform now supports the creation of loans and borrowing pools. Kashi pools function in a manner comparable to lending platforms such as Compound and Aave in that they enable traders to borrow assets for the purpose of creating leveraged long and short bets.

    This dashboard provides a listing of the top 5 KAshi pairs that categorizes them according to the number of loans they have generated. The total available for lending (in USD),  and the total amount of collateral deposited (in USD). The Kashi Medium Risk Wrapped Ether/USD Coin-Chainlink is given as an example of a Kashi pair, and a dashboard analyzes the number of lenders as well as the aloan that each pair generates.

    Method

    I addressed the issues of current bounty by following filters in queries:

    1. count(DISTINCT CASE WHEN event_name = 'LogAddCollateral' then tx_hash end) as The number of loans they have generated

    sum(CASE WHEN event_name = 'LogAddCollateral' THEN event_inputs:share WHEN event_name = 'LogRemoveCollateral' THEN -1*event_inputs:share end)/pow(10,8) as available for lending (in USD).

    1. sum(CASE WHEN event_name = 'LogAddCollateral' THEN event_inputs:share end)/pow(10,8) as Total collateral deposited (in USD)
    • Now, Let's look at the obtained results on following ghraghs

    Analysis

    Observation

    • The pair of SUSHI/DAI with 28.7% of shares number of loan generation is the top pair by number of loan generations metric that followed by SUSHI/USDC with 27.8% shares.

    Observation

    • The pair of AMP/USDC with 50.2% of shares number of loan generation is the top pair by total available for lending(in USD) metric that followed by SUSHI/USDC with 15.3% shares.
    Discord: 0xHaM☰d#8391
    Loading...
    Loading...
    Loading...

    Observation

    • And finally the pair of AMP/USDC with 61.2% of shares number of total collateral deposited is the top pair by total collateral deposited(in USD) metric that followed by DAI/RAI with 15.9% shares.
    db_img