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:
-
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).
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