pimi1356-HdnUm3USDH holders
Updated 2022-10-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with outflow as (
select TX_FROM as sellers, sum(AMOUNT) as outt
from solana.core.fact_transfers
where MINT='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
group by 1
),
inflow as (
select TX_TO as buyers, sum(AMOUNT) as intt
from solana.core.fact_transfers
where MINT='USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
group by 1
)
select (b.intt-a.outt) as balance, a.sellers as wallet
from outflow a join inflow b on a.sellers=b.buyers
order by 1 DESC
limit 10
Run a query to Download Data