select BLOCKCHAIN

,case

when FROM_ASSET='BSC.BNB' then 'BNB'

when FROM_ASSET='BSC.USDT-0X55D398326F99059FF775485246999027B3197955' then 'USDT'

when FROM_ASSET='BSC.USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D' then 'USDC'

end as from_token

,sum(from_amount_usd) as volume

from thorchain.defi.fact_swaps

where BLOCK_TIMESTAMP::date>=current_date-60

and BLOCKCHAIN='BSC'

and AFFILIATE_ADDRESS='lifi'

and from_asset not in ('THOR.RUNE')

group by 1,2

order by 3 desc

),

tab2 as (

select BLOCKCHAIN

,case

when TO_ASSET='ETH.ETH' then 'ETH on ETH'

when TO_ASSET='ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' then 'USDT on ETH'

when TO_ASSET='ETH.WBTC-0X2260FAC5E5542A773AA44FBCFEDF7C193BC2C599' then 'WBTC on ETH'

when TO_ASSET='ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' then 'USDC on ETH'

when TO_ASSET='AVAX.AVAX' then 'AVAX on AVAX'

end as to_token

,sum(from_amount_usd) as volume

from thorchain.defi.fact_swaps

where BLOCK_TIMESTAMP::date>=current_date-60

and BLOCKCHAIN='BSC'

and AFFILIATE_ADDRESS='lifi'

and to_asset not in ('THOR.RUNE')

group by 1,2

order by 3 desc

limit 5

select concat(from_token,'->',to_token) as route