Sushi-92.Stable Coins Lent on Kashi
-- Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. -- Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. -- The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'
Methodology
- Find all Kashi Pool addresses
select '0x668edab8a38a962d30602d6fa7ca489484ee3224' as address, 'WBTC/USDC' as pool union
select '0x5f92e4300024c447a103c161614e6918e794c764' as address, 'WETH/DAI' as pool union
select '0x27b501098dba1537ce2b34b201bf43eb890671c4' as address, 'xSUSHI/WETH' as pool union
select '0x0adbfc6db10efd02786e3f590127079e74e4c128' as address, 'WETH/USDT' as pool union
select '0x17fb5f39c55903de60e63543067031ce2b2659ee' as address, 'xSUSHI/USDT' as pool union
select '0x77f3a4fa35bac0ea6cfac69037ac4d3a757240a1' as address, 'xSUSHI/DAI' as pool union
select '0xf678b4a096bb49309b81b2a1c8a966ef5f9756ba' as address, 'WBTC/USDT' as pool union
select '0x659b4642ff3d0719f71eae903ce9f46b20767642' as address, 'USDC/SUSHI' as pool union
select '0x561770b93d0530390eb70e17acbbd6e5d2f52a31' as address, 'LINK/DAI' as pool union
select '0x7bee2161afa1aee4466e77bed826a41d5a28db46' as address, 'USDC/NMR' as pool union
select '0x6eafe077df3ad19ade1ce1abdf8bdf2133704f89' as address, 'xSUSHI/USDC' as pool union
select '0x67adc7432ce278486cc84fbc705bf70b5ab33a95' as address, 'xSUSHI/UST' as pool union
select '0x418bc3ff0ba33ad64931160a91c92fa26b35acb0' as address, 'WBTC/DAI' as pool union
select '0xb7b45754167d65347c93f3b28797887b4b6cd2f3' as address, 'WETH/USDC' as pool union
select '0xff7d29c7277d8a8850c473f0b71d7e5c4af45a50' as address, 'WETH/USDT' as pool union
select '0xb7b45754167d65347c93f3b28797887b4b6cd2f3' as address, 'WETH/USDC' as pool union
select '0xe83cbc07d4df1f3ba8fd451f9e56b012402e64ca' as address, 'MATIC/USDC' as pool union
select '0xa898974410f7e7689bb626b41bc2292c6a0f5694' as address, 'BADGER/USDC' as pool union
select '0xdf55bd0a205ec067ab1cacfaeef708cf1d93ecfd' as address, 'RUNE/USDT' as pool union
select '0x4f68e70e3a5308d759961643afcadfc6f74b30f4' as address, 'LINK/USDC' as pool
- Find all transactions with contract_name like 'KashiPair%', these are the transactions on the Kashi Lending platform.
- Find transactions for deposit and withdraw collateral by looking into event_name ilike event_name in ('LogDeposit','LogWithdraw%')
- We are only looking at data since 01 Jan, 2022.
Find the top 5 Kashi pairs on Ethereum based on TVL
- Here are the Top 5 Kashi pair by TVL.
- xSUSHI/USDC pool has the highest TVL with 2.5M $USD since 01 Jan 2022.
- xSUSHI/DAI pool has the second highest TVL with 1.97M $USD since 01 Jan 2022.
- WETH/DAI pool has the third highest TVL with 1.25M $USD since 01 Jan 2022.
Loading...
Loading...
Loading...