Overview:

Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.

Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds. -nHow many unique holders are there for Gen1 and Gen2?

How many Gen2 holders hold an Oct Prime Gen1? Show Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time. Note any other insights you find about the Octo Prime sales or holders!

Approach:

Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.

In this essay, the wallets that hold Octo Primes have been investigated.

The methodology of this essay contains:

• Holding stats

     from flipside_prod_db.algorand.account_asset
     where ASSET_NAME ilike '%Octorand%' for GEN1
                       and 
     where ASSET_NAME ilike '%Octo Prime Gen2%' for GEN2
  

• Distribution of Octo Primes

      when no_GEN1=1 then 'a. 1 GEN1'
      when no_GEN1 between 2 and 3 then 'b. 2-3 GEN1'
      when no_GEN1 between 3 and 10 then 'c. 3-10 GEN1'
      when no_GEN1 between 10 and 20 then 'd. 10-20 GEN1'
      when no_GEN1>=20 then 'e. over 20 GEN1'
  

• Sales Activity

      from flipside_prod_db.algorand.transfers
  

Results:

The number of unique holders for GEN1 and GEN2 demonstrate in this bar chart.

The distribution of GEN2 reveals that 28.6% of wallets hold 1 GEN2. Also it can be seen that, 20% of holders hold more than 20 GEN2.

Due to the definition of buckets in the approach section, it can be seen that most of the wallets hold 1 GEN1 about 76% of holders.

Now we want to answer the question about common holding features.

According to this chart, 60.7% of GEN2 holders not holding GEN1 and about 39% of them hold both GEN2 and GEN1.

The sales activity of Octo Primes demonstrate the dominance of GEN1 in marketplace in term of volume of sale.

In count of sales, both GEN1 and GEN2 have consistent movement and are close together.