Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain.

Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels

\n

Method:

First, with the help of flipside_prod_db.crosschain.address_labels and specifying PROJECT_NAME, wallets related to Celsius were specified. Then the activity of these addresses on sushi (swaps, lending, LP'ing, farming) was done with the help of crosscahin databases.

By checking the activity of Celsius addresses in lending and borrowing of Sushi, it was found that these addresses were not active in these sectors.

For this reason, only the activity of these wallets was examined on the sushi swap platform.

By checking the dollar volume of activity of Celsius wallets on Sushi, it can be seen that these wallets had more activity in 3 time periods than on other days.

19 to 21 October 2020, 1 to 10 May 2021, and also 4 to 15 November.

By looking at the chart of Bitcoin and Ethereum, it can be seen that this increase in activity was affected by the market conditions. For example, November 2021 was the end of the upward trend; Or after the activity of these wallets in May 2021, the market has started a downward trend. Also, October 2020 can be considered as the beginning of the upward trend of the past.

By examining the activity of Celsius wallets in different pairs, it can be seen that the LDO-WETH pair with $18.2 Million had the highest number of purchases and sales among these wallets.

After that, CVX-WETH is in second place with almost $7.7 million and WBTC-WETH is in third place with $5.67 million.

The difference between the amount in and out in the chart above is the spread on the Sushi Pleftarm, as can be seen, for example, on the LDO-WETH pair, this value is about $400k.

The chart above shows the dollar value of the Celsius wallets swap on different days on different pairs. For example, it can be seen that in November 2021 the most swaps for Celsius wallets were for LDO-WETH and CVX-WETH pairs. For instance, on Nov 5 $1.94 Million swaps has done on CVX-WETH pairs which is the greatest amount for these wallets on different days.

In the above two graphs, the currencies that have made the most sales and also the most purchases by Celsius wallets are shown. As it is shown, the most sales of these wallets are related to LDO, against which they received WETH. As mentioned above, this pair has been among the most swap pairs among these users.