Try Quests to earn cryptoFailed Transactions
Method
- The ethereum.core.fact_transactions table have been used to find the failed and succeed transactions by their status (SUCCESS or FAIL) and calculate the count of transactions based on action by following tips:
When ORIGIN_FUNCTION_SIGNATURE in (SELECT ORIGIN_FUNCTION_SIGNATURE FROM ethereum.core.ez_dex_swaps WHERE PLATFORM = 'sushiswap') then ‘Swaping’
When ORIGIN_FUNCTION_SIGNATURE in (SELECT ORIGIN_FUNCTION_SIGNATURE FROM ethereum.sushi.ez_lending) then ‘Lending’
When ORIGIN_FUNCTION_SIGNATURE in (SELECT ORIGIN_FUNCTION_SIGNATURE FROM ethereum.sushi.ez_borrowing) then ‘Borrowing’
When ORIGIN_FUNCTION_SIGNATURE in ('0xe8e33700','0xf305d719') then ‘Add Liquidity’
When ORIGIN_FUNCTION_SIGNATURE in ('0x2195995c','0xded9382a') then ‘Remove Liquidity’
Also, the dot graph by color assigned has been used for each individual dot over the past two months. The values of the related measurements are shown in the dot graphs, with the hours of the day and days of the week indicated by their positions along the x- and y-axes, respectively.
In the dot plots, when the dot’s color become darker the rate went up and vice verca.
✍🏻 Conclusion
The failed rate transactions on Sushiswap-Ethereum for some actions are considerably low and for some other is dramatically high.
As excepted swapping with 97.2% of succeeded transactions is have had the highest rate in 2022, while Remove & Add Liquidity had lowest succeed rate with 0.056 & 0.066%, respectively.
In the other hand the failed rate transactions for Borrowing transactions was in the highest in compare other actions, so that the percentage for Remove Liquidity with 45.7% over 2022was three times more than Add Liquidity and Add Liquidity.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
Hey there 👋!
Firstly, I appreciate you sticking with it until the conclusion.
I’m Hamed, Ph.D. In Civil Engineering and interested in data science.
I've made many similar dashboards and visualizations since I started at Flipside in January.
Please have a look at my various contact information and let me know what you think.
:telescope: Findings:
The graphs in the right side shows the daily sTPM of all assessed transactions types compared to each other since 2022 in weekly.
- Swapping is the all-time highest success transaction speed with a 97% sTPM range and Remove Liquidity with 0.06% have had the lowest succeed transactions per minute rate..
- The Line chart graphs shows the failed rate transactions since 2022, as can be seen at the early of 2022 add liquidity in Jan 10th, peaked at 33.4%. but after that Failed Borrowing transactions reached at first place in FTR and with an rising cumulative growth and 45.7% of failed transactions rate in total..
:telescope: Findings:
- According to the first two plots, the failed rate of swap transactions increased by more than 5% per day on some days, peaking at 9.5% on July 18th, 2021, and recently reaching 7.4% on August 20th, 2022.
- The shade of each dot on the graphs above represents the value of corresponding measures while the position on the x- and y- axis are the hour of day and day of the week respectively.
- From both dot graphs, the transactions have the most positive signal (high sTPM and low TFR) on Monday evening of each week, while Wednesday morning shows the opposite signal.
- Over the past 60 days 491 number of swaps transactions were succeed, while 3.21% of all swaps transactions had failed.
:telescope: Findings:
- According to the first two plots, the failed rate of Lending transactions in 2021 was more than succeed transactions per minute, but in Jan 2022 sTPM passed FTR, so that the succeed transactions per minute over the 60 past days was in 6.88 in average and in the other hand FTR was about 2.5% in average the same period time.
- From both dot graphs, the transactions have the most positive signal (high sTPM and low TFR) on Tuesday morning and evening of each week, while Saturday shows the opposite signal.
:telescope: Findings:
- According to the first two plots, the failed rate of Borrowing transactions in 2021 was equal or mainly less than succeed transactions per minute, but in Jan 2022 FTR passed sTPM, so that the succeed transactions per minute over the 60 past days was in 7.41 in average and in the other hand FTR was about 18% in average the same period time.
- From both dot graphs, the transactions have the most positive signal (high sTPM and low TFR) on Friday morning and evening of each week, while Monday shows the opposite signal.
:telescope: Findings:
- According to the first two plots, except Some days on July 2021, the failed rate of Add Liquidity transactions in overall was in the above of succeed transactions per minute, so that the succeed transactions per minute over the 60 past days was in 0.36 in average and in the other hand FTR was about 2.77% in average the same period time.
- From both dot graphs, the transactions have the most positive signal (high sTPM and low TFR) on Sunday morning and evening of each week, while Friday shows the opposite signal.
:telescope: Findings:
- As can be seen in the first two plots, as same as results for add liquidity in the previous section, except Some days on July 2021, the failed rate of Remove Liquidity transactions in overall was in the above of succeed transactions per minute, so that the succeed transactions per minute over the 60 past days was in 0.35 in average and in the other hand FTR was about 4.11% in average the same period time.
- From both dot graphs, the transactions have the most positive signal (high sTPM and low TFR) on Tuesday morning and evening of each week, while Friday shows the opposite signal.