with txs as (with a as (select *, case when FROM_ASSET in

('AVAX.USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX/USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX~USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E'

,'BSC.USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D','BSC/USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D','BSC~USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D',

'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48','ETH/USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' ,'ETH~USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48')

then 'USDC'

when FROM_ASSET in

('AVAX.USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7','AVAX/USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7','AVAX~USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7'

,'BSC.USDT-0X55D398326F99059FF775485246999027B3197955','BSC/USDT-0X55D398326F99059FF775485246999027B3197955','BSC~USDT-0X55D398326F99059FF775485246999027B3197955',

'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7','ETH/USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' ,'ETH~USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7')

then 'USDT'

when FROM_ASSET in ('BNB.BUSD-BD1','BNB/BUSD-BD1') then 'BUSD'

when FROM_ASSET in

('ETH.GUSD-0X056FD409E1D7A124BD7017459DFEA2F387B6D5CD','ETH/GUSD-0X056FD409E1D7A124BD7017459DFEA2F387B6D5CD','ETH~GUSD-0X056FD409E1D7A124BD7017459DFEA2F387B6D5CD')

then 'GUSD'

when FROM_ASSET in

('ETH.LUSD-0X5F98805A4E8BE255A32880FDEC7F6728C6568BA0','ETH/LUSD-0X5F98805A4E8BE255A32880FDEC7F6728C6568BA0','ETH~LUSD-0X5F98805A4E8BE255A32880FDEC7F6728C6568BA0')

then 'LUSD'

when FROM_ASSET in

('ETH.USDP-0X8E870D67F660D95D5BE530380D0EC0BD388289E1','ETH/USDP-0X8E870D67F660D95D5BE530380D0EC0BD388289E1','ETH~USDP-0X8E870D67F660D95D5BE530380D0EC0BD388289E1')

then 'USDP'

else null End as FROM_Token

from thorchain.defi.fact_swaps

where FROM_ASSET like '%USD%')

, b as (select *, case when TO_ASSET in

('AVAX.USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX/USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E','AVAX~USDC-0XB97EF9EF8734C71904D8002F8B6BC66DD9C48A6E'

,'BSC.USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D','BSC/USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D','BSC~USDC-0X8AC76A51CC950D9822D68B83FE1AD97B32CD580D',

'ETH.USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48','ETH/USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48' ,'ETH~USDC-0XA0B86991C6218B36C1D19D4A2E9EB0CE3606EB48')

then 'USDC'

when TO_ASSET in

('AVAX.USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7','AVAX/USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7','AVAX~USDT-0X9702230A8EA53601F5CD2DC00FDBC13D4DF4A8C7'

,'BSC.USDT-0X55D398326F99059FF775485246999027B3197955','BSC/USDT-0X55D398326F99059FF775485246999027B3197955','BSC~USDT-0X55D398326F99059FF775485246999027B3197955',

'ETH.USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7','ETH/USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7' ,'ETH~USDT-0XDAC17F958D2EE523A2206206994597C13D831EC7')

then 'USDT'

when TO_ASSET in ('BNB.BUSD-BD1','BNB/BUSD-BD1') then 'BUSD'