Description of work:

• In this Bounties we want to get:

• Find number of active wallets are buying/ selling/ transferring NFTs monthly
• Find percent of Algo wallets hold an NFT
• Find number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively
• Find most popular NFT projects, and get most transaction volume this month

1 ---> Find number of active wallets are buying/ selling/ transferring NFTs monthly

• For do this:
  • We first get NFTs asset. Definition of NFT asset: in the [algorand.asset] table if an asset [total_supply = 1] and [decimals = 0] is an NFT
  • In second step we get active wallet. Definition of active wallet: in the [algorand.account] table if an address [account_closed = false] is an active wallet
  • For get buying NFT active wallet use the [algorand.transfers] and count(receiver) address
  • For get selling NFT active wallet use the [algorand.transfers] and count(sender) address
  • For get transferring NFT active wallet use the [algorand.transactions] and count(sender) address

According to the above diagrams, it can be seen that:

• The number of transactions for NFT has been increasing since Aug 2021
• Most transactions for NFT are in May 2022

2 ---> Find percent of Algo wallets hold an NFT

• For do this:
  • We first get NFTs asset. Definition of NFT asset: in the [algorand.asset] table if an asset [total_supply = 1] and [decimals = 0] is an NFT
  • In second step we get active wallet. Definition of active wallet: in the [algorand.account] table if an address [account_closed = false] is an active wallet
  • For get NFT holders we use the [algorand.account_asset] table and have at least one NFT and ---> [asset_last_removed is null and amount = 1 and asset_closed = false ]

According to the above results:

• The total number of active wallets in Algorand is 13.73M, of which 113.7k hold an NFT, which is approximately 0.82%.

3 ---> Find number of total wallets that have minted NFTs and put them up for sale, month over month and cumulatively

• For do this:
  • We first get all minted NFTs and minter in [algorand.asset] table in month and cumulatively
  • After that we check minter wallet address in [algorand.transactions] table by [sender = minter.creator_address] To know if the minted NFT is put for sale or not

According to the above chart, it can be seen that:

• The number of minted NFTs is increasing over time
• The highest number of minted NFTs is related to Jan 2022 after that Apr 2022

According to the above chart, it can be seen that:

• The number of NFTs minter is increasing over time
• The highest number of NFTs minter is related to Jan 16, 2022 after that Apr 7, 2022

According to the above chart, it can be seen that:

• The number of wallets that have mined the NFT and put it up for sale is growing
• The highest number of sales is related to Mar 23, 2021 after that Dec 2022 and Jan 2022

Based on the above result, it is clear that the number of unique wallets that NFT has minted and put it up for sale is 8.48k

4 ---> Find most popular NFT projects, and get most transaction volume this month

• To do this,
  • We examine and compare two platforms on Algorand that are more and have already been discussed in flipsidecrypto.com These two platforms:
    • 1- Rand Gallery
    • 2- AB2 Gallery

4.1 ---> Number of sale per day in last month on Rand Gallery and AB2 Gallery

• For do this:
  • We first get AB2 Gallery transactions from [algorand.asset_transfer_transaction] for AB2 Gallery by [try_base64_decode_string(transactions.tx_message:txn:note::string) like any ('%ab2.gallery%')] and Rand Gallery transactions from [algorand.payment_transaction] by [receiver = 'RANDGVRRYGVKI3WSDG6OGTZQ7MHDLIN5RYKJBABL46K5RQVHUFV3NY5DUE'] then calculate all number of sales and amount of sale for both.

According to the charts above, it can be seen that:

• Rand Gallery has the highest number of sales in last months
• The highest number of sales on Rand Gallery in the last month is related to May 17th, 26th and 27th

According to the charts above, it can be seen that:

• Rand Gallery has the highest amount of sales in last months
• The highest amount of sales on Rand Gallery in the last month is related to May 7th, 8th and 20th

According to the results, it is clear that the Rand Gallery platform is more popular among users for buying and selling NFT in Algorand