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.
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)
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.
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.
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)
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.
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
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