headitmanagerGMT Airdrop - What have recipients done with the airdrop
Updated 2022-03-19
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
›
⌄
with wallets0 as (select POSTTOKENBALANCES[0]:owner as owner ,POSTTOKENBALANCES[0]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
, wallets1 as (select POSTTOKENBALANCES[1]:owner as owner ,POSTTOKENBALANCES[1]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[1]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[1]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
, wallets2 as (select POSTTOKENBALANCES[2]:owner as owner ,POSTTOKENBALANCES[2]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[2]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[2]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
, wallets3 as (select POSTTOKENBALANCES[3]:owner as owner ,POSTTOKENBALANCES[3]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[3]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[3]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
, wallets4 as (select POSTTOKENBALANCES[4]:owner as owner ,POSTTOKENBALANCES[4]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[4]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[4]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
, wallets5 as (select POSTTOKENBALANCES[5]:owner as owner ,POSTTOKENBALANCES[5]:uiTokenAmount:uiAmount as amount from solana.transfers where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[5]:mint ='7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'
and POSTTOKENBALANCES[5]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
)
Run a query to Download Data