BLOCK_TIMESTAMP ::date as date,

sum(AMOUNT_IN),

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

and date >='2022-01-01'

group by 1,3