Sushiswap - Outflows
Inspite of its dark origins, SUSHISWAP with its plethora of innovative products under a single roof as re-established itself as a true competitor to Uniswap. However, that doesn't prevent users from exiting the Sushiswap ecosystem. In this dashboard we will check the Users who have stopped using Sushiswap over the last 30 days, and protocols they have interacted with in this given time.
Preparing USER data
First of all using the similar methodology to Sushi inflows:
- We can track all the interactions with Sushi ecosystem using the above methodology.
- Then we just have to extract the timestamp of each interaction and the user who is making the interaction.
- Now a second table of users who have interacted over the last 30 days can be created as a subset of the previous table of all users.
- Now cross-referencing those tables we can obtain those users who have not interacted over the past 30 days (like A-B)
- Once you get the subset of users who haven't interacted over the past few days, you can check their interactions from the
ethereum.udm_events
table and deduce the protocols they have interacted after tho
Performing this, we can create a subset of users who have stopped interacting with the ecosystem in terms of depositing funds to the ecosystem. They are :
So now lets check out the contracts they are interacting with.
Hold up, Sushiswap is here ??
Well Yes, we only included deposit transactions into Sushiswap, i.e using the protocol as an Yield Generating Protocol. Swaps still happen. So we see that most swaps occur via Uniswap and is the most popular protocol. Ignoring sushiswap, we see that Opensea is the next highest, so APEing into NFTs I guess. We can also see other lending protocols make up most of the remainder volume.
So how is the Apeing into NFTs going on for these users.
MutantApes is the project with most USD volume. This is because this is the most recent big NFT project. However, we see good volume into ArtBlocks and SuperRare curated collection - so they like Art ?