when origin_label = 'binance 10' then 'binance'

when origin_label = 'binance 11' then 'binance'

else origin_label

end as Label,

sum(amount) as volume

from ethereum.udm_events

where lower(contract_address) = '0xd533a949740bb3306d119cc777fa900ba034cd52'

and amount is not null and origin_function_name is not null and origin_function_name = 'transfer' and block_timestamp > '2021-01-01' and origin_label is not null

group by 1,2,3

order by 4 desc)

select label, sum(volume) as Volume

from trade

group by 1

order by volume desc

limit 10