select sum(event_inputs:token_amount)/pow(10,18) as steth_removeamount,

sum(event_inputs:token_amounts[0])/pow(10,18) as steth_addamount,

date_trunc('day', block_timestamp::date) as TIME,

case when event_name = 'AddLiquidity' then 'Add'

when event_name = 'RemoveLiquidityOne' then 'Remove'

end as action

from ethereum.events_emitted

where contract_address = '0xdc24316b9ae028f1497c275eb9192a3ea0f67022'

and event_name in ('RemoveLiquidityOne', 'AddLiquidity')

and block_timestamp > CURRENT_DATE - 60

group by TIME, action