BLOCK_TIMESTAMP::date date

, ifnull(PLATFORM,'Unknown') PLATFORM

, ifnull(SYMBOL_OUT,'Unknown') SYMBOL

, sum(ifnull(AMOUNT_OUT_USD,0)) AMOUNT_USD

, count(distinct ORIGIN_FROM_ADDRESS) swapper

, 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'

)

group by 1,2,3