pimi1356-HdnUm3USDH holders
    Updated 2022-10-09
    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