Introduction

there was a pool on Thorswap for WETH and THOR liquidity that users can provide liquidity and earn profit.

then Sushi announced a new pool that users could withdraw from old pool and deposit into new one to earn extra yeld. full details are here.

in this dashboard we will take a look at these two pools and extract some data from user actions.

Methodology

we have found old and new contract address for ETH/THOR pool and then track some transaction events like Deposit and Withdraw for both pool.

in all queries ez_token_transfers table is used.

for deposit into old contract this is it’s criteria:

• ORIGIN_TO_ADDRESS='0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24'
• ORIGIN_FUNCTION_SIGNATURE='0x8dbdbe6d'

for withdraw from old contract:

• ORIGIN_TO_ADDRESS='0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24'
• ORIGIN_FUNCTION_SIGNATURE='0xd1abb907'

for deposit into new contract:

• ORIGIN_TO_ADDRESS='0xef0881ec094552b2e128cf945ef17a6752b4ec5d'
• ORIGIN_FUNCTION_SIGNATURE='0x8dbdbe6d'

contract address for all of them is the same but the amounts are sent to two different instances.

no time filter has been used in this dashboard.

This chart shows amount of ETH/THOR LP deposit per day into old contract.

amounts are by SLP which stands for Sushi LP which represents ETH/THOR liquidity amount.

as we see users have deposited into this pool from November 2021 continues till July 2022.

the highest amount has been deposited on Nov 2021.

on Nov 7th 2021 about 11K SLP deposited into old pool and it was the highest amount deposited per day.

after Jan 2022, depodit into old pool decreased.

Analyze

first we will provide some basic data from deposit into old pool. after charts from daily data, we will show cumulated data.

and also we willl provide some charts and data about withdraw from old contract. and then we will compare cumulated data with deposit part.

and finally we will check to know how many users with what amount have migrated from old one to new contract.

Also this chart shows number of unique users who had deposit into old pool per day.

like previous chart, on Nov 7th 2021 about 59 unique users had deposi into old pool which is the highest number of users per day.

last deposit as said was on Jul 29th 2022 which 1 user had deposited.

here is total data for deposit into old pool.

so total unique users that have deposit into old pool are 125 users.

these users have deposit about 25.1K SLP which as said is Sushiswap LP token.

now that we have total statistics for deposit we can find withdrawals and compare them to find our answers.

This chart shows withdrawals amount from old pool per day.

again amount is base by SLP which is LP for that pool.

on May 6th 2022 about 5.8K LP token have been withdrawn which is highest amount per day that have been withdrawn.

last withdraw happened on July 27th 2022.

Also this chart shows number of unique users who had withdrawn from old pool per day.

on Dec 10th 2021 about 9 users have withdrawn their LP tokens which is highest number of unique users per day.

they had not withdrawn the highest amount because highest amount withdrawn on May 6th.

here is final statistics for withdrawn from old pool till now.

so till now about 93 users have withdrawn from old pool.

they have withdrawn about 24.5K LP tokens till now.

this result table shows users with their LP tokens that have withdrawn from old pool and then deposit it into new pool.

as we see there is only a user that have withdrawn from old pool and then deposit into new pool.

this user has deposited about 12.78 LP tokens.

Result

about 125 unique users have deposited into old pool they have deposited about 25.1K LP tokens.

about 93 unique users have withdrawn about 24.5 LP tokens from old pool till now.

we found that 32 unique users have left about 0.6K LP tokens in the old pool which means they haven’t withdrawn their LP tokens yet.

there is only 1 user that have withdrawn from old pool and then deposited into new pool.

Appendix

WETH/THOR old pool address: 0xae1fc3947ee83aeb3b7fec237bcc1d194c88bc24

WETH/THOR new pool address: 0x3d3f13f2529ec3c84b2940155effbf9b39a8f3ec

Sushiswap MasterChef v2: 0xef0881ec094552b2e128cf945ef17a6752b4ec5d

how many are left in old pool?

from previous data we found that about 125 unique users have deposited about 25.1K LP tokens into old pool.

also we found that about 93 unique users have withdrawn about 24.5K from old pool.

so if we compare these data we found that about 32 unique users still have their LP tokens in the old pool.

these 32 unique users have about 0.6K LP tokens left in the old pool.

so by comparing these data we found that 32 unique users have left about 0.6K LP tokens in the old pool.

from this compare we only know that how many are left in there. but to know how many of those who had withdrawn have actually deposited into new pool we should refer to next result.

we can not say that users who had withdrawn from old pool have deposit into new pool. we will find out this part at the next section.