Failed Transactions
Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding or removing liquidity on Sushiswap-Ethereum.
Sushiswap
SushiSwap is a decentralized exchange (DEX) in which users can exchange between different virtual currencies using a connected cryptocurrency wallet, such as MetaMask. The exchange allows swapping between 11,700 currency pairs.
Failed Transactions on Ethereum
Transactions fail when there isn't enough gas to pay for a transaction, or when a smart contract rejects a transaction. You are still charged for failed transactions because miners need to confirm transactions to the chain whether they succeed or fail.
Question
Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding or removing liquidity on Sushiswap-Ethereum.
Method
In order to find actions with highest rate of failed transactions we will use Sushiswap and Ethereum databases of Flipsidecrypto which contains tables such as: ethereum.core.fact_transactions, ethereum.sushi.ez_lending, ethereum.sushi.ez_borrowing, ethereum.sushi.ez_swaps, ethereum.core.dim_dex_liquidity_pools

We have transactions of Sushiswap platform on daily basis and types on above graphs. According to daily graph of total transactions, From Jan 2020 to May 2021 volume started significant growth over 18 months. After this bullrun upward trend broke and volume begun to decline and it's continues until now, Sep 2022.
Another graph we can see is transaction based on types which contains Swaps, Borrowing, Lending and Add/Remove Liquidity. As you can see majority of transactions belongs to Swaps.
Total transaction of all time indicates Swaps on Sushiswap owns 1.3B transaction which has huge difference compared to other three types. Borrowing with only 11.2M and Lending by 8.6M transaction following Swaps. Based on percentage share, Swaps owns 98.5% of total types.
Let's investigate on success/fail transactions alongside with percentage rate of them on daily basis and total. Since the beginning of 2022,
The most notable and remarkable trend belongs to Borrowing rate which has been decreased from 98% in Jan to 84% on Oct.
Total failed rate of transactions on daily basis indicates since the beginning of 2022 failed rate started to growth from 1.6% to 8% on June. From June, upward trend broke and begun to decreased untill now.

Conclusion
- Total transaction of all time indicates Swaps on Sushiswap owns 1.3B transaction which has huge difference compared to other three types. Borrowing with only 11.2M and Lending by 8.6M transaction following Swaps. Based on percentage share, Swaps owns 98.5% of total types.
- The most notable and remarkable trend belongs to ==Borrowing rate== which has been decreased from ==98% in Jan to 84%== on Oct.
- ==Total failed rate of transactions== on daily basis indicates since the beginning of 2022 failed rate started to ==growth== from 1.6% to 8% on June. From June, upward trend broke and begun to decreased untill now.
- Among all types of transaction ==Swaps== action has the highest number of success transaction along with failed one. According to our results, Swaps owns 1.28B success transaction and 31.8M failed transaction.
Let's take a look into success and failed transactions on Sushiswap. Among all types of transaction Swaps action has the highest number of success transaction along with failed one. According to our results, Swaps owns 1.28B success transaction and 31.8M failed transaction.