Crazy Goose Flock is one of the strongest growing NFT communities on Algorand. Let’s look at the holders of the CGF! (data available at: https://flipsidecrypto.xyz/)

***Analyzed according to the data until 8 June 2022.

Crazy Goose Flock NFTs’ holders.

Figure 1. The distribution of NFT Holders. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

Figure 1. The distribution of NFT Holders. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

The distribution is fairly balanced as the top 1 wallet (THUD3QWPVYGK4POBC53RQGJ2G5E37TFWFLMJVYHCTIIWA2HCBR37RXNTZE) only holds 134 NFT and we have around 1300 wallets that own at least one NFT.

Table 1. The top 10 wallets with the most ALGO that also own some NFTs. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

Table 1. The top 10 wallets with the most ALGO that also own some NFTs. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

When we look at the wallets that have more than 10,000 ALGOs, we find that 28 of them have some NFTs. They all have 195 NFTs between them.

When were those wallets created?

Figure 2. The daily number of created wallets (that currently own at least one CGF NFT) (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

Figure 2. The daily number of created wallets (that currently own at least one CGF NFT) (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

According to the graph above, the majority of wallets were created recently.

The $CRUMB airdrop.

CGF NFT holders will receive 6 $CRUMB each NFT twice per week (https://twitter.com/CrazyGooseFlock/status/1531039099372584962?s=20&t=ZM0LBiWXBRfykqaAi16YEA).

Figure 3. The $CRUMB airdrop. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

Figure 3. The $CRUMB airdrop. (More in formation: https://datastudio.google.com/reporting/4dac786d-20a8-4dd9-adb4-96f0002a8f91)

The top ten wallets that received the most $CRUMB from the airdrop are shown above, as well as some other statistics related to the airdrop.

Appendix

Holders

WITH holders AS
  (SELECT tb1.address,
          tb1.nft,
          tb2.date
   FROM
     (SELECT tb1.*,
             tb2.created_at
      FROM
        (SELECT ADDRESS,
                sum(amount) AS nft
         FROM flipside_prod_db.algorand.account_asset
         WHERE asset_name like 'CGF %'
           AND amount>0
         GROUP BY 1) AS tb1 join
        (SELECT address, balance AS algo, created_at
         FROM flipside_prod_db.algorand.account) AS tb2 ON tb1.address = tb2.address) AS tb1
   JOIN
     (SELECT block_timestamp::date AS date,
             block_id
      FROM flipside_prod_db.algorand.transactions) AS tb2 ON tb1.created_at = tb2.block_id)
SELECT *
FROM holders
GROUP BY 1,
         2,
         3

Whales

SELECT tb1.*,
       tb2.algo
FROM
  (SELECT ADDRESS,
          sum(amount) AS nft
   FROM flipside_prod_db.algorand.account_asset
   WHERE asset_name like 'CGF %'
     AND amount>0
   GROUP BY 1) AS tb1 join
  (SELECT address, balance AS algo
   FROM flipside_prod_db.algorand.account
   WHERE balance>10000 ) AS tb2 ON tb1.address = tb2.address

Wallet creations by date