Description of work

> In this bounty, we want to examine application calls in Algorand. For this, we will compare the application calls in the second half of 2021 with the first half of 2022. For this, we check the following:

• Compare application calls changed in the first 6 months of 2022 and the last 6 months of 2021
• Average number of transaction calls per block
• Average number of transaction calls per day
• Number of wallets making application calls

Note

• We use the algorand schema and application_call_transaction table
• To address this question, we consider the date from block_timestamp::date >= '2021-07-01' and block_timestamp::date < '2022-01-01'

1 → overview

> Let's take a general look at the application calls transactions in the last 6 months of 2021 and first 6 months of 2022.

In this section, we examine the total number of transactions for calls transactions from 2021-07-01 to 2022-06-31.

Conclusion of the part 1

> According to the results obtained from the first part, the total number of application call transactions from 2021-07-01 to 2022-06-31 is equal to 52728433, of which 14776657 are related to the last 6 months of 2021 (28.02% of total transactions) and 37951776 are related to the first 6 months of 2022 (71.98% of total transactions)

So we conclude that the number of application call transactions in the first 6 months of 2022 is almost 2.5 times that of the last 6 months of 2021.

2 → Number of transaction calls per day

> In this section, we examine the number of application call transactions per day

For this, we count the number of transactions and group by day

3 → Total average number of transaction per day

• Total average number of transaction from 2021-07-1 to 2022-06-31

• Total average number of transaction per day in last 6 months 2021

• Total average number of transaction per day in first 6 months 2022

Conclusion of the parts 2 and 3

> According to the results obtained from part 2 and 3, the number of application call transactions in the first 6 months of 2022 is more than the last 6 months of 2021.

The overall average of the first 6 months of 2022 is almost 2.5 times that of the last 6 months of 2021

4 → Total average number of transaction per block

• Total average number of transaction per block in last 6 months 2021

• Total average number of transaction per block in first 6 months 2022

Conclusion of the parts 4

> According to the results obtained from part 4, the average number of application call transactions per block in the first 6 months of 2022 is more than the last 6 months of 2021.

5 → Number of wallets making application calls

> In this section, we examine the number of unique wallets that had the application call transaction

• The total number of unique wallets that have performed the application call transaction
• The total number of unique wallets that have performed the application call transaction in last 6 months 2021
• The total number of unique wallets that have performed the application call transaction in first 6 months 2022
• The total number of unique wallets per day
• Total average transaction per unique wallets

Conclusion of the parts 5

> According to the results of part 5, the total number of unique wallets that have performed the application call transaction is 9,334,027 unique wallets, of which 7,433,887, that is, about 79% of the wallets are related to the first 6 months of 2022, and 1,960,775 unique wallets That is, about 21% of the wallets are related to the last 6 months of 2021

• The average transaction for each unique wallet is 6 overall, and for the last 6 months of 2021 it is 5 and for the first 6 months of 2022 it is 8.
• So, in the first 6 months of 2022, users have made more transactions than at the end of 2021.

Overall conclusion

According to the results obtained from the analysis of the number of transactions for application call in the last 6 months of 2021 and the first 6 months of 2022, more transactions have been done in the first 6 months of 2022 (about 2.5 times), and the number of transactions per block in 2022 is more than It is 2021 (about 1.8 times) and the number of unique wallets in 2022 is more than in 2021 (about 3.7 times)

So the total transaction activity for application call in the first 6 months of 2022 was much more than the last 6 months of 2021