mariyaWhat did the airdrop recipients do?
Updated 2022-03-25
999
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 tt as(
with t1 as(with a1 as(select
distinct(POSTTOKENBALANCES[0]:owner) as wallet,
POSTTOKENBALANCES[0]:uiTokenAmount:amount/1e9 as recieved
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000
group by 1,2 order by 2 DESC),
a2 as(select
distinct(POSTTOKENBALANCES[2]:owner) as wallet,
POSTTOKENBALANCES[2]:uiTokenAmount:amount/1e9 as recieved
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000
group by 1,2 order by 2 DESC),
a3 as(select
distinct(POSTTOKENBALANCES[3]:owner) as wallet,
POSTTOKENBALANCES[3]:uiTokenAmount:amount/1e9 as recieved
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and recieved<=100000
group by 1,2 order by 2 DESC),
a4 as(select
distinct(POSTTOKENBALANCES[4]:owner) as wallet,
POSTTOKENBALANCES[4]:uiTokenAmount:amount/1e9 as recieved
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'