date_trunc('day', block_timestamp) as block_day, sum(amount) as volume,

origin_function_name, symbol,

case when symbol = 'stETH curve token' then 'stETH'

else symbol end as symbols

from

ethereum.udm_Events

where origin_function_name in ('remove_liquidity','remove_liquidity_one_coin','remove_liquidity_imbalance')

and block_timestamp >= CURRENT_DATE - 30

and symbol != 'steCRV'

and amount is not null

and tx_id in

(select

tx_id

from

ethereum.events_emitted

where (tx_to_address = lower('0xDC24316b9AE028F1497c275EB9192a3Ea0f67022')

or tx_from_address = lower('0xDC24316b9AE028F1497c275EB9192a3Ea0f67022'))) -- sETH - ETH Pool

group by 1,3,4,5)

select block_day, symbols, origin_function_name, sum(volume) as vol

from liq

group by 1,2,3