/* Solana - GMT Airdrop Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game. Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these ""trailblazers"" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens? */ -- GST AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB -- GMT 7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx WITH all_airdrop_recipients AS ( SELECT SUM(value:"uiTokenAmount":"amount"/pow(10,9)) AS amount, value:"owner" AS recipient FROM solana.transfers a, LATERAL FLATTEN(INPUT => posttokenbalances) balances JOIN solana.labels b ON value:"mint" = b.address WHERE a.block_timestamp::date = '2022-03-15' AND a.source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4' AND a.authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' AND a.succeeded = 'TRUE' AND a.event_type = 'transfer' AND value:"mint" = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx' GROUP BY recipient ), whale_or_shrimp AS ( SELECT amount, CASE WHEN amount <= 100 then '<= 100' WHEN amount <= 1000 then '<= 1000' WHEN amount <= 10000 then '<= 10000' WHEN amount <= 100000 then '<= 100000' WHEN amount <= 1000000 then '<= 1000000' WHEN amount <= 10000000 then '<= 10000000' WHEN amount <= 100000000 then '<= 100000000' ELSE '>= 100000000' END AS whale_or_shrimp, recipient FROM all_airdrop_recipients ) SELECT COUNT(recipient) AS number_of_recipients, SUM(amount) AS total_amount, whale_or_shrimp FROM whale_or_shrimp GROUP BY whale_or_shrimp ORDER BY total_amount DESC /* The End! */

Solana - GMT Airdrop (STEPN)