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

GROUP by 1

order by count1 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 count2 DESC

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

order by count DESC

LIMIT 5