Methodology

• Find all NFDomain NFTS

  select * from flipside_prod_db.algorand.asset
  where asset_name ilike '%.algo'

• Find all sale transactions with these NFTs
• Find all Algo Payment transactions for amount spend.

Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains?

• Given below is the daily sales of NFDomains.
• The highest was 3145 Sales on June 5, 2022, after that the number of sales have just dwindled to just ~100 sales per day.
• The revenue generated follows the same route as well, highest was ~450K on June 4-5, after that is has been <50K per day.

Look at how many wallets have bought an NFDomain by day.

• The number of buyers spiked to 3.1K buyers on June5, however after that it has been just downhill.
• Currently it is down to less than 100 wallets per day.

Show the distribution of the number of NFDomains purchased by wallet

• Given below is the distribution of Top 10 Wallets holding NFTs as well as each wallet and how many NFTs they hold + the Algo balance they have.
• HXNQYGE5N7PEAWXD2U24DPJHHFPTGQH3HHC5HYQE3TC7HSARDFNJXIT5ZA is the top buyer with 500 NFTs.

Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet.

• The highest amount spent was by AGKBFLMBPX2BAKABKOAMFAB5XZV3X6LTGQDHQ7QBCQ6W7LDWS7BHTMIA3Y for a total of 6.95K ALGOS
• Also given below are the Top 10 spenders, along with all the other spenders.

Other interesting insights

• Looking at the number of NFTs held vs the Algo balance.
• There is an inverse co-relation between the number of NFTs held and the ALGO balance of the wallets.
• The Top Holder has a balance of 72K ALGOS, where as the lower end of holders have balance > 300K ALGOs.

What are the top 10 biggest NFDomain sales?

• The highest amount sale was was by SS3JTAI3TRSJALQI26C5FN2USQCBY2R6G3ES3AB5OJV5HUF2ETMA for a total of 6.95K ALGOS
• Also given below are the Top 10 sales, along with all the other sales.