with stakes as(select

ORIGIN_FROM_ADDRESS,

sum(amount) as amount ,SYMBOL, 'stake'as action

from

ethereum.core.ez_token_transfers

where

TO_ADDRESS = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

and CONTRACT_ADDRESS in ('0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0','0x455e53cbb86018ac2b8092fdcd39d8444affc3f6')

group by

1 ,3

select

ORIGIN_FROM_ADDRESS,

sum(amount) * -1 as amount ,SYMBOL, 'unstake'as action

from

ethereum.core.ez_token_transfers

where

FROM_ADDRESS = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

and CONTRACT_ADDRESS in ('0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0','0x455e53cbb86018ac2b8092fdcd39d8444affc3f6')

group by

1 ,3)

select ORIGIN_FROM_ADDRESS,ADDRESS_NAME,LABEL_TYPE, sum(amount)

from stakes e left join ethereum.core.dim_labels l on e.ORIGIN_FROM_ADDRESS=l.ADDRESS

where

group by 1,2,3