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

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

when FROM_ASSET='ETH.ETH'then 'ETH on ETH'

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

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

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