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

order by 2 desc