,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

,sum(volume)over(order by week) as total_volume

from thorchain.defi.fact_swaps

where AFFILIATE_ADDRESS='lifi'

group by 1