SELECT token0_address,sum(amount0in+amount1in ) as sum1,count(log_id) as count1 from mdao_harmony.swaps

GROUP by 1

order by sum1 DESC

),

data2 as (

SELECT token1_address,sum(amount0out+amount1out ) as sum,count(log_id) as count2 from mdao_harmony.swaps

GROUP by 1

order by sum DESC

SELECT token0_address,sum1+sum as sum,count1+count2 from data1 join data2 on data1.token0_address=data2.token1_address

order by sum DESC

LIMIT 5