iboo-jbj2MVTop 10 recipients of GMT
Updated 2022-03-25
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 class_zero as(select
distinct(POSTTOKENBALANCES[0]:owner) as wallet,
POSTTOKENBALANCES[0]:uiTokenAmount:amount/1e9 as received_amount
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and received_amount<=100000
group by 1,2 order by 2 DESC),
class_one as(select
distinct(POSTTOKENBALANCES[2]:owner) as wallet,
POSTTOKENBALANCES[2]:uiTokenAmount:amount/1e9 as received_amount
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and received_amount<=100000
group by 1,2 order by 2 DESC),
class_two as(select
distinct(POSTTOKENBALANCES[2]:owner) as wallet,
POSTTOKENBALANCES[2]:uiTokenAmount:amount/1e9 as received_amount
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and received_amount<=100000
group by 1,2 order by 2 DESC),
class_three as(select
distinct(POSTTOKENBALANCES[3]:owner) as wallet,
POSTTOKENBALANCES[3]:uiTokenAmount:amount/1e9 as received_amount
from solana.transfers
where block_timestamp::date >= '2022-03-15'
and source = 'HhXAKYmRzBNi7BjkDs2fbwJ49mnpWUtzyXEf8PAMArs4'
and authority = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'
and POSTTOKENBALANCES[0]:owner !='STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK' and received_amount<=100000