Overview

• NAME: Al Goanna

• GENUS: Varanus

• VARIETIES: 489

• TRAITS: 80+

• ORIGIN: Australia

• HOBBIES: Scuba Diving, Hula Dancing, Clown Impersonation, Interstellar Space Travel

• FAV MOVIES: Scar Face, Joker, Star Wars, Crocodile Dundee

• Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection.

• A green NFT collection of Algorand loving reptiles that’s good for the planet. Over 50,000 trees planted!

• The Al Goanna collection is limited to 489 unique 1/1 editions from the collection.

• There will be a weekly drop across a 12 week period with a deflationary supply that see’s an initial release of 50 per drop and reduces down to 26 items in the final drop.

• A total of 464 NFTs will be released onto the public market with 5% of the total supply retained by the team for giveaways, marketing and personal use.

Description of work:

• Show the number of Al Goanna’s each wallet holds.
• Show the amount of fees Al Goanna sales have generated for the DAO over time.
• Show Al Goanna sales and ALGO volume over time.
• Show the distribution of ALGO balances of Al Goanna holders

Al Goannas

1 ---> Show the number of Al Goanna’s each wallet holds

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

• The total number of tokens stored is 497
• Most wallets hold just a one token
• Wallet 6CZWV3M4OVDNNGFEOWCSFRJUQLKL6KR2QJEPYDP66GZC4C6KB7HMSSXAV4 holds the largest number of tokens

2 ---> Show the amount of fees Al Goanna sales have generated for the DAO over time

3 ---> Show Al Goanna sales and ALGO volume over time

In this section we want to calculate Al Goanna sales and ALGO volume over time

• For first step, we get Al Goanna token info from algorand.account_asset table
• For second step, get Goanna_transactions_list from algorand.transactions for Goanna token by join the Goanna token info asset_id and [algorand.transactions] asset_id
• Finlay, calculate amount_of_algo_volume and number_of_sales by sum(tx_message:txn:amt/1e6) and count(distinct tx_group_id)

4 ---> Show the distribution of ALGO balances of Al Goanna holders

For do this:

• We first get all Goanna holder wallet address
• Calculate the amount of ALGO for buy and sell by each Goanna holder
• Finaly we calculate algo balance by sum(buy_algo.amount_of_buy - sell_algo.amount_of_sell)