Results

Methodology

1. First we found the asset_id's from the instruction given to us
2. Using algorand.account table and algorand.block table we found the wallet details like , when was wallet created at? and how much ALGO they own?
3. We found the addresses that own Wildlife Warrriors NFTs using algorand.account_asset table, we joined this table with assets which consists of asset_ids's of Wildlife Warriors NFTs and account_details to find the details like , amount of ALGO they hold, creation time of wallets.
4. For the second part of the question we used case statements to make a meaningful group by's like 'created at 2022 before june' or 'wallets with <= 100 algo'

1. 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?

We can see majoritiy ( 52.2%) of the wallets that own at least one Wildlife Warriors NFTs created at June.

Wallets created at before 2022 is in the second place with 32.7% and wallets created at 2022 is in the last place among holders.

Conclusion

Majority of the wallets were created for the drop, only 32% of the wallets were created before 2022 which we could identify this wallets as established ones.

The other wallets created at 2022 before June are in the last place of holders .

2. Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances

Wallets own less than or equal to 100 ALGO own the majority of the Wildlife Warriors NFTs with owning 46.7% of the supply.

Wallets with 101-1000 ALGO and wallets with > 1000 ALGO own nearly in the same amounts

Conclusion

Wallets that own Less than 100 ALGO holds most of the Wildlife Warriors NFTs.

We could assume that this wallets are also created at June because majority of the Wildlife Warriors holder wallets were created at June

We can see established wallets hold most of the ALGO which was in the second place among holders , but if we look at the new wallets created at June this wallets own majority of the supply but have less ALGO than other holders. So it could be the proof of 'this wallets are just created for the drop'

A single wallet holds the 8.26% of the Wildlife Warriors. This wallet and other top 3 are in the list of > 1000 ALGO balance list.

So this whales own 11% of the Wildlife Warriors NFTs

Attention: I used two different queries for this dashboard.