when origin_to_address = '0x1111111254fb6c44bac0bed2854e76f90643097d' then '1inch'

when origin_to_address = '0xe3ffc583dc176575eea7fd9df2a7c65f7e23f4c3' then 'LB Router'

when origin_to_address = '0x1a1ec25dc08e98e5e93f1104b5e5cdd298707d31' then 'Metamask'

else coalesce(initcap(project_name),origin_to_address) end as User1,

count (distinct tx_hash) as trxs,

count (distinct origin_from_address) as wallets,

sum (event_inputs:value/1e6) as Volume

from avalanche.core.fact_event_logs t1 full outer join avalanche.core.dim_labels t2 on t1.origin_to_address = t2.address

where tx_status = 'SUCCESS'

and event_name = 'Transfer'

and contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

and block_timestamp >= '2022-07-01'

and event_inputs:value/1e6 < 1e9

group by 1

order by 2 DESC

limit 10