Introduction

Celsius is a place to get a loan. To work with this platform, you must enter your assets into this platform, and then you can access your assets through a mobile or web application that belongs to this platform. People who invest in this platform and lend their assets make a good profit, and this platform has a relatively good transparency.

Method

1. for collecting the wallet address of Celsius, I used crosschain.address_labels table with

   ADDRESS_NAME ='Celsius wallet' AS condition

2. the swap data on sushi for these addresses gotten from flipside_prod_db.crosschain.ez_swaps table, and we calculate the total stats like Total TX count or Total volume and also daily volume

3. for Celsius wallets, there was only the activity data for swapping on sushiswap

Questions

1. what Celsius platform has done on sushi (swaps, lending, LP'ing, farming)?

Information:

1. the highest swapping volume was on November 2021 and May 2021
2. 2021 was an active year for Celsius

Information:

1. the highest swapping volume belongs to LDO_WETH pool and after that CVX_WETH pool come

Conclusion

1. Celsius was very active on sushiswap on 2021 unlike 2022
2. the like to swap on LDO_WETH pool in sushiswap
3. there was no activity for lending or borowwing.

Swap stats