headitmanagertop 20 wallets
    Updated 2022-03-08
    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