Transactions by Protocol

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.

image source)

Methodology

Introduction

Algorand is rooted in the idea that the system should allow for changes and avoid inflexible policies—enabling both the community and the protocol to evolve. The Algorand platform takes a consensus approach to protocol changes, which facilitates continuous evolution of the protocol and eliminates potential hard forks that could fracture the community. This ability is powered by the Algorand consensus protocol that enables the users to reach consensus on anything. Not just on the next block, but also on a protocol upgrade.

source)

First we find the tx_id of each app_id in [flipside_prod_db.algorand.application_call_transaction].
Then we join this table with transaction table for same tx_id and we count the number of daily protocols transactions.
And sum fee for each protocol.
then from [flipside_prod_db.algorand.prices_swap] table we join time with each protocol tx_id time to find the influence number of transactions to ALGO price.

Results

According to the chart:

Algo dex transaction started on Feb 5 , and after that we seen the transaction increase and then the chart shows decrease number of transactions.
Tinyman transaction started on Sep 30, 2021.
Algofi transactions started on Des 15, 2021 and its increase.
And Folk finance didnt hand specific trend in daily transactions.
Most transaction related to Algofi and Tinyman.
We see a sharp peak for Algofi on May 11, 2022.

ALgofi and Tinyman have the most transaction and fees.
After these we have Algodex and folks.

We have plotted all the app id to the ALGO price. number of Tinyman transaction can influence ALGO price.

Because in both graphs we see an almost constant trend and then the downward trend.

conclusion

The most fees paid by application calls type.
Agofi and Tinyman have the most transactions and fees paid.
The ALGO price influence more by Tinyman.
We see a sharp peak for Algofi on May 11, 2022.

According to the chart:

Most type of transaction used is application call that Algofi and Tinyman used it more than others.
After application call, asset transfer by Algofi is used most.
Asset configuration by Algofi has the less number of count type.
We can see key registration only on Algofi.