headitmanagertop 20 wallets
Updated 2022-03-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with temp as (select sum(inner_instruction:instructions[0]:parsed:info:amount/1e6) as amount
,POSTTOKENBALANCES[1]:owner as wallet
from solana.events
inner join solana.transactions
on solana.transactions.tx_id=solana.events.tx_id
where program_id ='LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'
and (pre_mint ='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1' or post_mint='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1')
and date(solana.transactions.block_timestamp) >= '2022-02-01'
and date(solana.transactions.block_timestamp) <= '2022-02-28'
and inner_instruction:instructions[0]:parsed:info:destination!=''
group by wallet
order by amount DESC
limit 20
)
select * from temp
Run a query to Download Data