select BLOCK_TIMESTAMP::date as day

,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'

and BLOCK_TIMESTAMP::date>=current_date-60

and BLOCKCHAIN='BSC'

group by 1