'EUROC in' direction,

pool_name,

count(distinct case when token_in = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then tx_hash end) total_tx,

count(distinct case when token_in = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then sender end) total_swappers,

sum(case when token_in = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then amount_in end) swapped_volume

from avalanche.core.ez_dex_swaps

where token_in = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

group by pool_name

union all

'EUROC out' direction,

pool_name,

count(distinct case when token_out = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then tx_hash end),

count(distinct case when token_out = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then sender end),

sum(case when token_out = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

then amount_out end)

from avalanche.core.ez_dex_swaps

where token_out = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd'

group by pool_name