BLOCK_TIMESTAMP ::date as date,

count(TX_HASH),

Case

WHEN SYMBOL_out ='stETH' then 'stETH'

WHEN SYMBOL_out ='aETH' then 'aETH'

WHEN SYMBOL_out ='rETH' then 'rETH'

end as type

from ethereum.core.ez_dex_swaps

where SYMBOL_out ='stETH'

or SYMBOL_out ='aETH'

or SYMBOL_out ='rETH'

group by 1,3