Description of Work

In this bounty, we want to examine the transactions of the list of App_id of Folks Finance, AlgoFi, Tinyman and AlgoDex protocols. For this, we examine the following:

• What percent of transactions their app calls and associated transactions (transactions in the same tx_group_id) make up on the Algorand blockchain.
  • To address this section, we calculate the transactions related to each protocol using the application_call_transaction table:
    • count(distinct tx_id) → For transactions
    • count(distinct tx_group_id) → For associated transactions (transactions in the same tx_group_id)
• How have the number of transactions changed over time for each Protocol?
  • To address this section, we calculate the transactions related to each protocol using the application_call_transaction table per day:

    • count(distinct tx_id) → For transactions

    • count(distinct tx_group_id) → For associated transactions (transactions in the same tx_group_id)

    • group by block_timestamp::date → Daily transaction

• How much in fees have been spent on transactions relating to each protocol?
  • To address this section, we calculate the transactions fees related to each protocol using the application_call_transaction table:
    • sum(fee) → For each protocol
• What type of transactions are each protocol producing?
  • To address this section, we obtain the transactions related to each protocol using the application_call_transaction table (tx_id), then join the obtained result with the transactions table and obtain the tx_type_name for each transaction and each protocol.
• Has the price of ALGO been an influence on the number of transactions produced by each protocol?

  • To address this section, we get the price of ALGO using the prices_swap table and compare it with the transactions made for each protocol over time.

    \

Note

• We use the algorand schema and ==application_call_transaction== table

• App ID lists:

  • Folks finance App IDs:
    • ==776179559, 776176449, 752770929, 751285119, 747239433, 747237154, 743685742, 743679535, 696044550, 694464549, 694405065, 686876641, 686875498, 686862190, 686860954, 686501760, 686500844, 686500029, 686498781==
  • Tinyman App IDs:
    • ==649588853, 350338509, 552635992==
  • AlgoFi App IDs:
    • ==705663269, 705657303, 674527132, 661247364, 661207804, 661204747, 661199805, 661193019, 661192413, 659678644, 659677335, 658337046, 658336870, 647785804, 647785158, 641500474, 641499935, 639747739, 639747119, 611869320, 553866305, 482625868, 465814222, 465814065, 674526408, 637795072, 637793356, 635866213, 635864509, 635863793, 635860537, 635813909, 635812850, 611867642, 611804624, 611801333, 605753404, 553869413, 482608867, 465818260, 465814318, 465814278, 465814149, 465814103==
  • Algo dex App IDs
    • ==354073718, 354073834==

  \n

1 → What percent of transactions their app calls make up on the Algorand blockchain

Conclusion of the part 1

According to the obtained results, the total number of transactions is 54078719, of which:

• 42213 are related to folks finance App IDs application call transactions, which is about 0.08%.
• 14831296 are related to tinyman App IDs application call transactions, which is about 27.43%.
• 11302481 are related to algoFi App IDs application call transactions, which is about 20.9%.
• 164134 are related to algo dex App IDs application call transactions, which is about 0.3%.

Tinyman has the highest number of App IDs application call transactions with 27.3% and folks finance has the lowest number of App IDs application call transactions with 0.08%

2 → What percent of associated transaction their app calls make up on the Algorand blockchain

Conclusion of the part 2

According to the obtained results, the total number of associated transactions is 23318342, of which:

• 29276 are related to folks finance App IDs application call transactions, which is about 0.13%.

• 14581255 are related to tinyman App IDs application call transactions, which is about 62.53%.

• 944795 are related to algoFi App IDs application call transactions, which is about 4.05%.

• 164123 are related to algo dex App IDs application call transactions, which is about 0.7%.

• Tinyman has the highest number of App IDs application call associated transactions with 62.53% and folks finance has the lowest number of App IDs application call associated transactions with 0.13%

• It is interesting that Algo Dex from 164134 to 164123 of the transactions it has done is associated transactions (transactions in the same tx_group_id)

3 → How have the number of transactions changed over time for each Protocol?

Conclusion of the part 3

• The highest number of transactions for application call is related to May 11, 2022 and May 12, 2022 which happened during this period of LUNA crash and market collapse.

  After these, the highest number of transactions for application call is related to Jan 2, 2022 and Jan 21, 2022.

• The lowest number of transactions is from Jan 10, 2022 to Jan 18, 2022.

• As you can see, the largest number of transactions is related to tinyman App IDs application call and algoFi App IDs application call, after Feb 22, 2022, the number of transactions for algoFi App IDs application call is more than other protocols, but before that, the most transactions It is related to tinyman App IDs application call which is decreasing over time

• In general, the number of transactions for application call is decreasing from May 12, 2022 onwards

4 → How have the number of associated transaction changed over time for each Protocol?

Conclusion of the part 4

• The highest number of associated transactions for application call is related to Jan 2, 2022 and Jan 20, 2022
• The lowest number of associated transactions is from Jan 10, 2022 to Jan 18, 2022.
• As you can see, the largest number of transactions is related to tinyman App IDs application call
• In general, the number of associated transactions for application call is decreasing from Jan 25, 2022 onwards

5 → How much in fees have been spent on transactions relating to each protocol?

Conclusion of the part 5

• The highest fee spent is related to Tinyman App IDs application call transactions with 14.869k ALGO, followed by AlgoFi App IDs application call transactions with 14.759k ALGO.
• The highest fee spent is related to Jun 13, 2022, most of this fee spent on this day is related to AlgoFi App IDs application call transactions with 671 ALGO and after that May 11, 2022, which is again the highest amount of fee spent related to AlgoFi App IDs are application call transactions with 533 ALGO

6 → What type of transactions are each protocol producing?

Conclusion of the part 6

• All transactions of Tinyman App IDs are related to transaction of application call transaction type
• All transactions of Algo dex App IDs are related to transaction of application call transaction type
• AlgoFi App IDs generated all types of transactions
  • application call
  • asset transfer
  • payment
  • key registration
• Folks finance App IDs did not generate the only key registration transaction

7 → Has the price of ALGO been an influence on the number of transactions produced by each protocol?

Conclusion of the part 7

• In Folks finance App IDs, there is no Correlation between ALGO price and the number of transactions
• In Tinyman App IDs, AlgoFi App IDs and Algo dex App IDs, it can be seen that as the price of ALGO increases, the number of transactions increases and vice versa, but not necessarily always.

Final Conclusion

> Based on the results and analysis, it was found that the highest amount of transactions for application call is related to Tinyman App IDs and the lowest amount is related to Folks finance App IDs, also the highest amount of fee spent is related to application call transactions for Tinyman App IDs and AlgoFi is App IDs, also Tinyman App IDs and Algo dex App IDs generate only application call type transactions and AlgoFi App IDs generate all types of transactions, also no correlation was observed between ALGO price and application call transactions for Folks finance App IDs, but There is a correlation between Tinyman App IDs, AlgoFi App IDs, and Algo dex App IDs with ALGO price.