select origin_from_address as User, tx_hash, amount_in as amount, amount_in_USD as amount_usd, '🔴Sell' as "Direction"

from ethereum.defi.ez_dex_swaps

where token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

union all

select origin_from_address as User, tx_hash, amount_out as amount, amount_out_USD as amount_usd, '🟢Buy' as "Direction"

from ethereum.defi.ez_dex_swaps

where token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}')

select user as "👥Swapper", count(distinct tx_hash) as "🔄Swap Count", sum(amount) as "💰Swap Volume ($AXL)", sum(amount_USD) as "💸Swap Volume ($USD)", "Direction"

from overview

where user<>'0x0000000000000000000000000000000000000000'

group by 1,5

order by 1