Before the collapse, the most activity is Transfer users was for 60% of the transactions, and after that, the most transactions were Approve, with a total of 85,000 users doing Approve, which is 35% of the transactions.

After the collapse, the activity of the users is exactly the same as before, which is the most popular activity is transfer, although the difference is that after the collapse, the number of users has increased, and naturally their activity has also increased, and after the transfer, the most popular activity is Approve.

The most popular assets that users used for swaps in centralized exchanges before the collapse was ETH, with a total of 104,000 swaps with it, and after that, the most popular token is USDC, which is in the users' collection. 36,000 swaps were done with it, and USDT is in the third place, with a total of 21,000 swaps by users, which means that stablecoins are popular among users.

It seems that the collapse did not affect the popularity of tokens among users, and after the collapse, we can see that the most popular asset among users is ETH, with a total of 76,000 swaps, followed by the USDC token. which they did a total of 27 thousand swaps with, and then there is USDT, with which users made a total of 16 thousand swaps, and in the meantime, a very important point is that the number of swap assets After the collapse, it has decreased, which means that the enthusiasm of users to do it has decreased.

The most common activity of users after transferring their assets is transferring them again, that is, after removing their assets from the exchange, users move them again, which accounts for 64% of the activities, followed by holding assets. that 21% of users did not move their assets after withdrawing them and kept them there. Swap is in the third place, that is, users swapped their assets after withdrawing them from the exchange, which is almost About 10% of the transactions are for it, and the least activity of users is to buy NFT, that is, nearly 5% of the transactions after the withdrawal of assets are for buying NFT.

After the collapse, the conditions completely changed because before the collapse, 64% of the transactions were for re-transfers, but after the collapse, this amount decreased by 20%, that is, 47% of the transactions are for re-transfers, and on the other hand, holding assets from 21 The percentage increased to 44%, which means that after the collapse, users preferred to hold their assets, which is an important sign, and after the collapse, users only thought of withdrawing their assets from the exchange and placing those assets in Hold somewhere safe.

Thanks for reading

• All data used are from: Flipside Crypto

  \

• My Twitter: Sepehrmhz8

Special Thanks for: hessaminanloo

Conclusion

This very bad event that happened to FTX centralized exchange had a very bad effect on users' thoughts and this very bad event caused users to become pessimistic about all centralized exchanges and we saw that after the collapse the number of withdrawals of users' assets from exchanges increased a lot. and this is a very bad thing for centralized exchanges because the trust of users towards them has decreased a lot and for this reason they have to work hard to regain the trust of users.

Project : Ethereum

Bounty Name : Open Analytics Bounty: ETH (November 20)

Question: In the last few days, we saw that a very bad thing happened to FTX centralized exchange, and this incident caused many users' discomfort. Now, let's see if after this incident, users have withdrawn Hud assets from centralized exchanges or not

Date of analysis : 2022-11-26

What is The Story ?

In the past few days, after a report from CoinDesk about the strange financial balance sheet of Alameda was published, we have seen some important events and some have sounded the alarm that Alameda and even FTX exchange can shock the market with its bankruptcy. Now I am going to briefly review these events:

• CoinDesk report publication: Alameda's financial statement shows that the company's assets are 14.6 billion dollars, the highest amount of which is 3.66 billion dollars of FTT token (the native token of the FTX exchange) which is unlocked. But the main point is that the source of the company's 8 billion dollar loan has not been determined, and it is also not known how much of it is without support.
• Sam Bankman-Friend response: After many criticisms following the publication of this report, finally, SBF, the CEO of FTX, was forced to respond and claimed that this company has more than 10 billion dollars of capital not mentioned in this report. But it still did not specify how much of Alameda's loans were made through FTX.
• Sale of FTT by Binance: Binance CEO Changpeng Zhao also confirmed the rumors about the sale of FTT token by this exchange, and said that this action was aimed at reducing the risk of the assets of this exchange. In response, SBF trivialized this decision and said that FTX is ready to buy all Binance’s FTT tokens. CZ stated that he will sell the remaining FTT token holding. He added that this move is a part of his exit plan from FTX.
• Liquidity problem: Following the spread of this news, withdrawals from the FTX exchange have intensified, and Alameda has been forced to transfer assets from his accounts in other exchanges to the FTX exchange in order to provide the necessary liquidity.
• Huge capital outflow: To understand the dimensions, it is enough to mention that the FTX exchange's Ethereum balance has decreased by 300 thousand in the past 48 hours! source

Methods

Tables I used: I use flipside_prod_db.crosschain.address_labels and filter transactions with label_type = 'cex' and label_subtype = 'hot_wallet' because i just want transactions of CEX and i also filter these transactions with blockchain = 'ethereum' because i just want transfers of ethereum network. I use ethereum.core.ez_token_transfers for other tokens on ethereum and i use ethereum.core.ez_eth_transfers for ETH token transfers. In these tables i count(DISTINCT(tx_hash)) for number of transfers and i count(DISTINCT(user)) for number of Users.

Metrics

• Number of Transfers CEXs to Ethereum
• Number of Users that Transfers from CEXs to Ethereum
• Total Number of Transfers
• Total Number of Users
• Total Number of Transfers per Days of Week
• Number of Transfers from CEXs to Ethereum per CEX
• Number of Users from CEXs to Ethereum per CEX
• Useres Activities after Transfers from CEXs to Ethereum
• Share of Activities after Transfers from CEXs to Ethereum
• Top 10 Token Swapped By CEXs Users based on swaps
• Top 10 Token Swapped By CEXs Users based on Users
• Top 10 Token Swapped By CEXs Users based on swaps
• Top 10 Token Swapped By CEXs Users based on Users
• Number of Users per Action
• Share Number of Users per Action
• Number of Transfers Ethereum to CEXs
• Number of Users Ethereum to CEXs

Transfers from CEXs to Ethereum overtime

After the very unfortunate incident that happened to FTX, we can see that the number of transfers to Ethereum from exchanges has increased, and of course the reason is very clear, because after this very unfortunate incident that happened to FTX, users compared to the exchanges. Centralized became very pessimistic and as a result they prefer to withdraw their assets from them and that is why we see an increase in the number of transfers from exchanges to Ethereum.

The day before this very unfortunate incident, the number of transfers was 35 thousand, but we can see that after this incident, the number of transfers reached 43 thousand on November 6, and after that, the number of transfers increased until November 13, when the number of transfers was the highest. and on November 13, which was the highest number of transfers from exchanges to Ethereum, a total of 159,000 transfers were made on this day, which was 4 times more than the transfers in the previous days of the collapse.

Transfers from CEXs to Ethereum Total Stats

As you saw, after the collapse, users felt very dangerous and preferred to withdraw their assets from the exchanges. Now let's see how many users in total and how many transferred their assets.

Before the collapse, a total of 674 thousand transfers were made by users from exchanges to Ethereum, and this number of transfers was made by 413 thousand users, while the number of transfers after the collapse was 1.29 million transfers, which means 30% growth compared to before the collapse, and this means that this event has caused the number of transfers to increase by 30%, and in total, after the collapse, 975 thousand users removed their assets from exchanges, and this means the number of users who preferred to withdraw their assets from exchanges has grown by nearly 40% compared to before the collapse, and the most important conclusion that can be drawn is that this collapse, which happened to the FTX exchange, had a very bad effect on all the exchanges. and this has caused users to become pessimistic about all centralized exchanges and prefer to withdraw their assets from these exchanges.

Popular Exchanges

As you probably know, Binance is the largest centralized cryptocurrency market exchange, and this exchange has many users, and for this reason, it is the largest asset outflow for this exchange, so that in total, more than 45% of the total assets are withdrawn for this exchange. This is despite the fact that only 5% of the total amount of assets withdrawn from the FTX exchange that this unfortunate incident happened to, although the point is that the users of this exchange after the collapse They are not allowed to withdraw their assets and therefore the number of withdrawals from this centralized exchange is not impressive

Popular Activities Before Collapse

Popular Activities After Collapse

Popular Assets Before Collapse

Popular Assets After Collapse

Users Actions Before Collapse

Users Activity After Collapse

Transfers from Ethereum to CEXs

After the collapse, we can see that the number of transfers of assets from Ethereum to centralized exchanges increased. In my opinion, one of the most important reasons for this is that the demand for withdrawing assets from exchanges by users increased greatly, and for this reason, exchanges were forced to to transfer their assets from the Ethereum network so that they can give them users' assets.

The number of bridges from Ethereum to exchanges on the day before the collapse was 21,000 transfers, which after the collapse reached 44,000 transfers on November 8, and the highest number of transfers was on November 9, when a total of 60,000 users made 74,000 transfers from Ethereum to centralized exchanges.