select origin_to_address,

case when origin_to_address = '0xfb06a737f549eb2512eb6082a808fc7f16c0819d' then 'GNS Staking'

when origin_to_address = '0x1111111254fb6c44bac0bed2854e76f90643097d' then 'AggregationRouterV4'

when origin_to_address = '0x176586dec2b70df5b72a6efe158a87f210551798' then 'GFarm Trading Vault'

when origin_to_address = '0xd285f881886505b9ef6684e1aaa7949a56b0c7da' then 'GFarm Token Migrating'

when origin_to_address = '0xdef171fe48cf0115b1d80b88dc8eab59176fee57' then 'Paraswap: Augustus Swapper'

when origin_to_address = '0x31997b848beeb66cf3afd609cb16a1957de88cc3' then '0x31997b848beeb66cf3afd609cb16a1957de88cc3'

when origin_to_address = '0xd7052ec0fe1fe25b20b7d65f6f3d490fce58804f' then 'GNSTradingVault'

when origin_to_address = '0x2ed7e9fcd3c0568dc6167f0b8aee06a02cd9ebd8' then '0x2ed7e9fcd3c0568dc6167f0b8aee06a02cd9ebd8'

when origin_to_address = '0x3470756e5b490a974bc25feeeeb24c11102f5268' then 'GNSNFTRewards'

when origin_to_address = '0x151757c2e830c467b28fe6c09c3174b6c76aa0c5' then 'GNSPoolV5'

when origin_to_address = '0x1641b50b738fa0ed229415a2cec2a2ea056ae2ef' then '0x1641b50b738fa0ed229415a2cec2a2ea056ae2ef'

when origin_to_address = '0x15e1e50c1bf0947e342895bfa3d66d4e4161b88f' then '0x15e1e50c1bf0947e342895bfa3d66d4e4161b88f'

else initcap(address_name) end as destination_label,

sum (event_inputs:value/1e18) as GNS_Volume,

count (distinct tx_hash) as GNS_Transactions

from polygon.core.fact_event_logs t1 left outer join polygon.core.dim_labels t2 on t1.origin_to_address = t2.address

where contract_address = '0xe5417af564e4bfda1c483642db72007871397896'

and event_name = 'Transfer'

and tx_status= 'SUCCESS'

group by 1,2

order by 4 DESC

limit 10