BLOCK_TIMESTAMP::date date

, case

when TOKEN_IN = '0xd01ef7c0a5d8c432fc2d1a85c66cf2327362e5c6' then 'aETHb'

when TOKEN_IN = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' then 'aETHc'

when TOKEN_IN = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'stETH'

when TOKEN_IN = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'

end token

, sum(ifnull(AMOUNT_IN_USD,0)) AMOUNT_IN_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