piperSolana - GMT Airdrop - Distrubution
Updated 2022-03-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
/*
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'
Run a query to Download Data