Try Quests to earn cryptoTop Kashi Pairs III
This analysis is a review on the top 5 Kashi pairs by the number of loans they have generated, the total available for lending (in USD) and the total collateral deposited (in USD).
BentoBox is a dual purpose performance asset vault from SushiSwap. On the other hand, Kashi is the first decentralized application (dApps) launched on top of BentoBox, which will allow users to take DeFi loans efficiently. Kashi's objective is to offer a specialized lending platform, which allows users, traders and investors to isolate risk, in order to increase the asset options with which they can trade.
To get the top 5 pairs by number of loans generated, we need to use the 'flipside_prod_db.ethereum_core.fact_event_logs' table. Then, we will filter by event_name = 'LogBorrow' and select those tx_hash from the 'flipside_prod_db.ethereum_core.fact_event_logs' table that have the bentobox contract address (as Kashi is built on top of Bento). To make the queries shorter to run, we filtered the date since the beginning of 2022. Finally, we made a ranking of the top 5 pairs by number of loans generated for each month.
The reason why there are more than 5 pairs in total is because some months had different top 5 pairs. We can observe that the number one pair by number of loans is the MIM/sSPELL pair, followed by MIM/cvxTriCrypto and MIM/yvstETH. 2022 has been a bearish year so far in crypto, and we can see it clearly by the amount of loans generated, which are decreasing every month.
The methodology to get the top 5 Pairs by total available for lending (in USD) is very similar to the previous section, but the event_name is or 'LogAddAsset' or 'LogRemoveAsset' in the first table. We also get the avaialble amount for lending by suming the amount in usd in case event_name is 'LogAddAsset' and substracting the amount in usd in case the event_name is LogRemoveAsset'. Finally, we make a ranking of the top 5 pairs by the total amount available for lending for each month.
We can see that as it happened with the number of loans generated, the avaliable amount for lending follows the same downtrend in 2022. The total amount of lending available in January for the top 5 pairs summed was around 1.5M USD, while in May it doesn't reach 0.1M. We can notice that the first pair is xSUSHI/USDC, followed by WBTC/USDT.
To get the top 5 pairs by total collateral deposited (in USD) we do the same as with the total amount available for lending, but changing the 'LogAddAsset' and 'LogRemoveAsset' event_name for 'LogAddCollateral' and 'LogRemoveCollateral'.
To conclude, we must say that this chart is the only one that is not going completely downward as 2022 has gone by. It is true that the total collateral deposited in January was way more than in the following months, but the amount raised from February to April. The MIM/FTT pair is leading massively in collateral deposited, but if we filter it out in the chart we can see that the others have similar amounts from Februrary to May.
