block_timestamp, tx_hash, to_address as user_address, amount,

from base.core.ez_token_transfers

where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'

and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

and origin_function_signature = '0x69659658'

),

stakes as (

select

block_timestamp, tx_hash, origin_from_address as user_address, amount, 'stake' as label

from base.core.ez_token_transfers

where origin_function_signature = '0x6e553f65'

and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

and origin_to_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'

union all

select

block_timestamp,tx_hash, origin_from_address as user_address, -amount as amount, 'unstake' as label

from base.core.ez_token_transfers

where origin_function_signature = '0x9343d9e1'

and from_address = '0x548d3b444da39686d1a6f1544781d154e7cd1ef7'

and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'

order by 1 asc

),

final as (

select

c.user_address,

SUM(c.amount) as claim_amount,

SUM(s.amount) as stake_amount