case

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

when TO_ASSET='BSC.BNB'then 'BNB on BSC'

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

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

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

end as token

,sum(FROM_AMOUNT_USD) as volume

from thorchain.defi.fact_swaps

where AFFILIATE_ADDRESS='lifi'

and token is not null

group by 1

order by 2 desc

limit 5