Algorand Bounties - The Octorand Universe
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.
- Octorand is a decentralised application (dApp) built on top of the Algorand blockchain.
- Octorand makes use of many aspects of the Algorand blockchain such as Algorand Standard Assets (ASA), Stateful Smart Contracts, Atomic Transfers, etc.
Octo Primes
-
Octo Primes are microscopic creatures, the only form of life existing in the world of Octorand. Each Octo Prime is represented by a unique Algorand Standard Asset (ASA).
- Each Octo Prime is also backed up by an Algorand Stateful Smart Contract which contains the logic of manipulating Octo Prime features.
-
There are two versions of Octo Primes. The Original Gen1 version and the newly released Gen2 version. Octo Primes are a highly sought after asset in the Algorand NFT space.
- There are 1000 Gen1 Octo Primes in existence. Each Gen1 Octo Prime has 8 traits with varying degrees of rareness.
- Each trait has 26 possible values coded by the letters of the alphabet.
- The initial traits of Gen1 Octo Primes were determined by following a simple hashing algorithm. - - algorithm made sure that only the first 16 letters of the alphabet (A to P) were used as initial trait values.
- Prime owners can still reach the remaining traits (Q to Z) by using transformations.
- This immediately makes the trait values from Q to Z more rare.
- There are 8000 Gen2 Octo Primes in existence. Each Gen2 Octo Prime has 16 traits with varying degrees of rareness.
- Each trait has 26 possible values coded by the letters of the alphabet.
- Each Gen2 Octo Prime is associated with a Gen1 parent Octo Prime. The initial traits of Gen2 Octo Primes were affected by their parent traits.
- Gen2 Octo Primes are relatively cheap and are less expensive to conduct transformations on.
- OCTO is the currency of Octorand which, again, is represented by an Algorand Standard Asset (ASA). It is capped at 1000000 tokens.
- Each Octo Prime holds a reserve of some OCTO.
- They emit OCTO from this reserve at a very slow speed.
- The owner of each Octo Prime can collect these OCTO rewards.
- OCTO can be used to transform the traits of Octo Primes.
- OCTO spent for transformations is burnt. This makes the OCTO token a deflationary token.
Description of work
- In this Bounties we want to:
- Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds.
- Show How many unique holders are there for Gen1 and Gen2?
- Show How many Gen2 holders hold an Oct Prime Gen1?
- Show Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time.
1 ---> Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds
- In this section we want to calculate the number of Octo Primes Gen1 and Octo Primes Gen2 for each wallet holds
- For first step we Octorand token info from
algorand.account_asset
table - Count all token for each wallet (group by wallet)
- For first step we Octorand token info from
According to the diagrams above, it can be seen that:
- The Wallet address VVCR4Q2GYOQO3ENWQDQEFFGTNDJRA56QIYHUQ3RCZT36I6WXBAUU2FS7QE Holds the most Octo Primes Gen 2 (998)
- Each wallet Most support for Octo Primes Gen2
2 ---> Show How many unique holders are there for Octo Primes Gen1 and Octo Primes Gen2?
- In this section we want to calculate the number of unique holders are there for Octo Primes Gen1 and Octo Primes Gen2
- we first, we get Octorand token info from
algorand.account_asset
table - Then get number of unique holders for each Octo Primes Gen1 and Octo Primes Gen2 separately
- Finally, we union the two
- we first, we get Octorand token info from
According to the above results and charts, it can be seen that:
- Users are more likely to want to holds the Octo Primes Gen1
7991
wallets hold Octo Primes Gen1- 3899` wallets hold Octo Primes Gen2
- In this section we want to calculate the number of *Octo Primes Gen2 holders hold an Oct Prime Gen1
- we first get octo_primes_gen1 and octo_primes_gen2 token asset info from
algorand.account_asset
table individually - Then join the octo_primes_gen1 and octo_primes_gen2 using wallet_address
- Finally, calculate number of holders for Octo Primes Gen 2 individually and calculate number of holders for both Octo Primes Gen 1 and Octo Primes Gen 2 in SAME TIME that holded
- we first get octo_primes_gen1 and octo_primes_gen2 token asset info from
- In this section we want to calculate Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time
- For first step, we get Octorand token info from
algorand.account_asset
table - For secon step, get octo_transactions_list from
algorand.transactions
for Octorand token by join the Octorand token infoasset_id
andalgorand.transactions]
asset_id
- Finlay, calculate
amount_of_algo_volume
andnumber_of_sales
bysum(tx_message:txn:amt/1e6)
andcount(distinct tx_group_id)
- For first step, we get Octorand token info from
According to the results and diagrams above, it can be seen that:
- The daily sales and total number of sales and sales
volume of ALGO
for Octo Primes Gen 1 is much more than Octo Primes Gen 2 - There will be no sales for the Octo Primes Gen 2 until `[February 25, 2022
- From
[February 4 to February 11, 2022]
, we see the highest number of sales and the volume of ALGO, most of which is for Octo Primes Gen 1 - From
[April 2022]
, we see the lowest number of sales and the volume of ALGO