Question:

Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs:

-Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance?

Approach:

The methodology of this essay contains following parts:

• Wildlife Warriors

    from algorand.asset 
    where asset_name like 'Warrior Croc%' 
    and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or 
    creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
  

• Wallets based on creation date

    BLOCK_TIMESTAMP::date as day_creatat_at
    from flipside_prod_db.algorand.account x
    join flipside_prod_db.algorand.block y on x.CREATED_AT=y.BLOCK_ID
  

• ALGO distribution

    BALANCE between 0 and 100 then '0-100 ALGOs'
    BALANCE between 100 and 500 then '100-500 ALGOs'
    BALANCE between 500 and 1500 then '500-1500 ALGOs'
    BALANCE>=1500 then 'above 1500 ALGOs'
  

• NFT distribution

    number_own=1 then '1 NFT'
    number_own between 2 and 5 then '2-5 NFT'
    number_own between 5 and 10 then '5-10 NFT'
    number_own>=10 then 'above 10 NFT'
  

Results:

Key findings:

The key findings of this essay have been summarized as:

1. By the use of creation time of NFT owners wallets, 508 unique wallets created on June 14 and the main reason of that is NFT drop of Wildlife warrior.
2. Among wildlife warrior owners, 74.7% of owners has up to 100 ALGO
3. In the wildlife warrior owners, 76.6% of them has 1 NFT and the number of 1 NFT owners is 1318 wallets
4. Only 1.74% of wildlife warrior owners has over 10 NFTs and its about 30 wallets
5. The dependency of balance and NFT count of owners reveals in the scatter plot. According to this plot, among top 100 owners the balance of ALGO for them is in the range of 20k ALGOs.
6. Among top 100 owners, one wallets with 22 NFTs has over 100k ALGO.