Sushi Activity on Ethereum
Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings? Hint: use the tables in Sushi schema: ethereum.sushi.
Goal:
Discussion about the effect of the recent spike in market volatility on the overall activity of sushi on Ethereum.
Questions:
- The number of swaps and swaps volume of sushiswap on Ethereum.
- The number of lending and lending volume of sushiswap on Ethereum.
solutions:
In the first step, I should find recent spikes. The below chat shows the daily average BTC and ETH price since the beginning of 2022.
1. Swaps:
In this part, I compare the volume of the swap and the number of swaps since the beginning of 2022.
To calculate the volume and count of swaps on sushiswap, I used ethereum.sushi.ez_swaps table and consider the following conditions:
- platform = 'sushiswap'
- amount_in_usd is not null
- event_name = 'Swap'
As you can see the number of swaps on this platform during spikes is more than before and after that. We are seeing more swap volumes between May 9 and 16, Also June 11th and 22nd than before. After this date, the swap volume is close to the value it had before.
Anyway, The volume is decreasing.
In the two below charts, we will examine the volume and number of daily swaps to get a better view of the activity in sushiswap.
As you can see the volume of swaps on this platform during spikes is more than before and after that. We are seeing more swap volumes between May 8 and 13, Also June 10th and 18th than before. After this date, the swap volume is close to the value it had before.
Anyway, The volume is decreasing.
Bitcoin has lost more than half of its value from an all-time high of $68,982 reached in November. The digital token had suffered eight straight weeks of losses and dropped since May 7th after the Terra collapse and reached below $30,000.
The second dropped happened on June 7th after growing global inflation rates and rate hikes by the U.S Federal Reserve and reached $18,000.
According to the above chart, I consider two periods as recent spikes.
- First spike: May 5th to May 12th
- Second spike: June 7th to May 18th
2. Lending
In this part, I compare the volume of the lending and the number of lending since the beginning of 2022.
To calculate the volume and count of lending on sushiswap, I used ethereum.sushi.ez_lending
table and consider the following conditions:
- lending_pool like '%km%'
- amount_usd is not null
In the two below charts, we will examine the volume and number of daily lending to get a better view of the activity on sushiswap.
As you can see, I can't say the daily volume of lending has a special pattern during spike than before and after that. But the volume of lending is decreasing totally.
According to the above chart, during the first spike, the number of lending is decreased than before of that. the volume of lending is decreasing totally.
The above chart shows the daily deposit and withdraw in lending activity. during the spikes, the daily withdraw amount is more than the deposit amount.