BLOCK_TIMESTAMP ::date as date,

count(TX_HASH),

Case

WHEN SYMBOL_IN ='stETH' then 'stETH'

WHEN SYMBOL_IN ='aETH' then 'aETH'

WHEN SYMBOL_IN ='rETH' then 'rETH'

end as type

from ethereum.core.ez_dex_swaps

where SYMBOL_IN ='stETH'

or SYMBOL_IN ='aETH'

or SYMBOL_IN ='rETH'

group by 1,3