Try Quests to earn cryptoTransactions by Protocol (Algorand bounty)
Introduction
In this dashboard, I’m going to answer the following questions about Folks Finance, AlgoFi, Tinyman, and AlgoDex:
- 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?
- How much in fees have been spent on transactions relating to each protocol?
- What type of transactions are each protocol producing?
Approach
- Used tables:
flipside_prod_db.algorand.application_call_transactionandflipside_prod_db.algorand.transactions - The date range of analysis: The first half of 2022
['2022-01-01' , '2022-06-30'] - App IDs: all ID lists that are mentioned in bounty.
- The number of app calls transactions:
count(distinct tx_group_id) - Total number of transactions:
count(distinct tx_id)
percentage of transactions their app calls and percentage of total transactions on the Algorand blockchain.
| Protocol | all transactions (%) | app calls transactions(%) |
|---|---|---|
| Tinyman | 56.6 | 61.5 |
| AlgoFi | 19.1 | 6.11 |
| Folks Finance | 0.13 | 0.168 |
| Algodex | 1.03 | 1.16 |
| Others | 23.2 | 31 |
According to this normalized chart, the types of transactions produced by each protocol is:
- AlgoFi: application call, asset transfer, key registration, payment, asset configuration.
- Folks Finance: application call, asset transfer, payment, asset configuration.
- TInyman: application call, asset transfer, payment, asset configuration.
- Algodex: application call, asset transfer, payment.
These protocols have not had asset_freeze type transactions during the analysis date.
The above line chart shows daily number of transactions relating to each protocol.
during the first half of 2022., Folks finance had the lowest number of transactions.
from Jan 6 to the end of Jan 18, the number of transactions in Tinyman has been decreased too much and even on some days it is less than AlgoFi. but on other days, it is more than other protocols.
- As we can see in the red pie chart, Tinyman protocol has the max number of transactions and Folks Finance has the minimum number of transactions.
- by looking at the blue pie chart, we realize that users by conducting more than half Appcalls of Tinyman, indicate that this protocol is more popular than others.
-
182.7K in fees have been spent on transactions relating to AlgoFi protocol, which means users spent around (73.3%) of fees for AlgoFi.
-
31.3K in fees have been spent on transactions relating to Tinyman protocol, which means users spent around (12.6%) of fees for Tinyman.
-
669 in fees have been spent on transactions relating to Algodex protocol, which means users spent around (0.228%) of fees for Algodex .
-
184.472 in fees have been spent on transactions relating to Folks Finance protocol, which means users spent around (0.074%) of fees for Folks Finance.
-
13.9% of fees have been spent on transactions relating to other protocols.