select date_trunc('week',BLOCK_TIMESTAMP) as week

,BLOCKCHAIN

,sum(FROM_AMOUNT_USD)/2 as volume

from thorchain.defi.fact_swaps

where AFFILIATE_ADDRESS='lifi'

group by 1,2