Method

I got the template app list with filter CREATOR_ADDRESS = '3EPGHSNBBN5M2LD6V7A63EHZQQLATVQHDBYJQIZ6BLCBTIXA5XR7ZOZEB4 from the app table.then :

• Providing liquidity: i get TX_GROUP_ID list from application_call_transaction table with filtering try_base64_decode_string(TX_MESSAGE:txn:note::string) = 'Market: mt' .then i join application_call_transaction table to transfers table based on TX_GROUP_ID and i filtering by TX_TYPE = 'axfer'.

• borrowing liquidity : i get TX_GROUP_ID list from application_call_transaction table with filtering try_base64_decode_string(TX_MESSAGE:txn:note::string) = 'Market: b' .then i join application_call_transaction table to transfers table based on TX_GROUP_ID and i filtering by INNER_TX = True.

Supplying and Borrowing on Algofi

The next query , shows number users are supplying and borrowing the same asset on AlgoFi.

According to the results:

• Number providing liquidity : 4897
• Number borrowing liquidity : 5991
• As you can see, number of borrowing liquidity is more than number of providing liquidity.

Average amount of each asset being supplied for recursive borrowers

The next query , shows Average amount of each asset being supplied for recursive borrowers on Algofi.

According to the chart above 4 asset being supplied for recursive borrowers:

• USDC: 4067
• STBL: 2058
• goETH: 0.61
• goBTC: 0.035
• The highest value is related to the USDC currency.

Rewards

The next query , shows Total rewards in 2022. The total amount of rewards from 2022 is 491 USD.

Conclusion

• Suppliers : 4902
• Borrowers: 2672
• The percentage of suppliers is about 50% more than that of borrowers
• 4 asset being supplied for recursive borrowers :USDC,STBL,goETH and goBTC

percent of these users of total suppliers & borrowers

The next query , shows percent of these users of total suppliers & borrowers.