count(DISTINCT tx_hash) as swaps,

sum(

CASE when not AMOUNT_IN_USD is NULL then AMOUNT_IN_USD

when not AMOUNT_OUT_USD is NULL then AMOUNT_OUT_USD

ELSE 0

END

) as swap_volume

FROM ethereum.defi.ez_dex_swaps

WHERE ORIGIN_FROM_ADDRESS ILIKE '{{ swapper }}'