block_timestamp::date as date,

count(distinct tx_hash) as tx_count,

count(distinct sender) as swapper_count,

sum(case when token_out = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' then amount_out else 0 end) as buy_amount,

sum(case when token_in = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' then amount_in else 0 end) as sell_amount,

sum(amount_in_usd) as volume,

buy_amount - sell_amount as net_buy

from ethereum.core.ez_dex_swaps

where token_out = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc' or token_in = '0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc'

group by 1

order by 1