select date_trunc('week',BLOCK_TIMESTAMP) as week

,case

when TX_STATUS='SUCCESS' then 'SUCCESS' else 'FAIL' end as success_rate

,count(distinct TX_HASH) as swaps

from bsc.core.ez_decoded_event_logs

where ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'

and EVENT_NAME='LiFiGenericSwapCompleted'

and DECODED_LOG:integrator='binanceWallet'

group by 1,2