BLOCK_TIMESTAMP::date date

, case

when TOKEN_IN = '0xae78736cd615f374d3085123a210448e74fc6393' then 'swap from'

when TOKEN_OUT = '0xae78736cd615f374d3085123a210448e74fc6393' then 'swap to'

end grp

, sum(ifnull(AMOUNT_OUT_USD,0)) AMOUNT_USD

, count(TX_HASH) swap

from ethereum.core.ez_dex_swaps

where 1=1

and (

-- TOKEN_IN = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6'

-- or

-- TOKEN_IN = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb'

-- or

-- TOKEN_IN = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

-- or

TOKEN_IN = '0xae78736cd615f374d3085123a210448e74fc6393'

)

or (

-- TOKEN_OUT = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6'

-- or

-- TOKEN_OUT = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb'

-- or

-- TOKEN_OUT = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

-- or

TOKEN_OUT = '0xae78736cd615f374d3085123a210448e74fc6393'

)

group by 1,2