select

block_timestamp,

tx_id,

inner_instruction:instructions[0]:parsed:info:authority::string as user,

inner_instruction:instructions[0]:parsed:info:amount/pow(10,9) as amount

from solana.events

-- where tx_id = '5m3cXquqMncfCgEArC5AHnoZMYUckPzJcJ3FFDhiEuDjBNRB9odCmVDygBk22C7AivGMF4yM157NaPbpR3ekkebH'

where instruction:programId::string = 'LocktDzaV1W2Bm9DeZeiyz4J9zs4fRqNiYqQyracRXw'

and pretokenbalances[0]:mint::string = 'Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1'

and amount is not null

and block_timestamp < current_date - interval '7 days'

select

user,

sum(amount) as amount_locked

from locks

group by 1

order by amount_locked desc

limit 20