select

sum(FROM_AMOUNT_USD)/2 as volume

,avg(FROM_AMOUNT_USD)/2 as avg

,count(distinct FROM_ADDRESS) as swappers

,count(distinct TX_ID) as swaps

from thorchain.defi.fact_swaps

where AFFILIATE_ADDRESS='lifi'