Transactions by Protocol
Q115. Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
Methodology:
By using flipside_prod_db.algorand.application_call_transaction table and inserting the APP IDs that were available in the bounty text, in this table we called the number of daily transactions of the respective dexes and using the same table we called the daily transaction fee and the total.
using the flipside_prod_db.algorand.prices_swap table from the Algorand database and called the Algo price , in the time frame of transactions, we checked the relationship between the number of transactions and the price of the Algo , and we checked this case by calculating the correlation between the price and the number of transactions.
Highlights of daily transactions
- Regarding the Folks Finance protocol, if we want to consider the general trend of transactions, since the beginning of the project, the transactions have been accompanied by an upward trend and reached the highest amount of daily transactions on May 19, then we will see a spike and a drop on May 30 and then Of those transactions, there is an upward trend.
- Regarding Tiny Man, it should be said that since the beginning of the project, the number of daily transactions has gone through an upward trend until January 2, 2022, and after that we see a sharp drop, which brought the number of transactions from about 216k to below 1000 daily transactions on January 16, after We see a spike and the beginning of a downward trend.
- In the case of Algofai, the upward trend of transactions can be observed from the beginning of the project, which continued until the recent price crash of the market and reached its peak on May 11, and after that, along with the market decline, the transactions also started a downward trend. The noteworthy point is that on May 11, the number of transactions was higher than the highest daily transaction value in the Tiny Man protocol and reached about 244k daily transactions.
- And about Algodex, it can be said that its work started on February 11 with about 7000 daily transactions and so far it has had a downward trend and has reached about 200 daily transactions.
Highlights of spent fees
- Tiny Man and Algofay protocols had the highest amount of fees spent, and in contrast, Folks Finance and Algodex protocols had the lowest fees, which is the normal value related to the number of transactions of these protocols. Algofay and Tiny Man are about 14k Algo have had a fee, and in contrast to the fees of Folks and Algodex, the total has not reached 500 algo.
Highlights of transactions vs Algo price
-
Regarding Folks Finance, it should be said that there is no relationship between the Algo price and the transactions of this protocol, perhaps it can be said that there is an inverse relationship between the transactions and the Algo price, which means that when the price falls, the number of transactions increases and when the price increases, the number of transactions decreases. finds The correlation between the number of daily transactions and the Algo price is ==0.110014==, which shows a very weak correlation.
-
In the case of Tiny Man, the relationship between the Algo price and the number of daily transactions is clearly evident, and we can see that there is a correlation. The correlation between the price and the number of transactions in the Tiny Man protocol is ==0.435914==, which shows an moderate correlation.
-
In the case of Algofai, this correlation is not observed. The correlation between the number of daily transactions and the price of Algo is ==-0.37433==.
-
The correlation between Algo price and Algodex protocol transactions is quite clear, and as we can see, with the price drop, the number of transactions has taken a downward trend. The correlation between price and transactions in Algodex protocol is ==0.496562==.