SELECT BLOCK_TIMESTAMP::date as days,
ACTION,
CASE
WHEN ACTION LIKE 'DECREASE_LIQUIDITY' THEN sum(AMOUNT0_USD+AMOUNT1_USD)
WHEN ACTION LIKE 'INCREASE_LIQUIDITY' THEN sum(AMOUNT0_USD+AMOUNT1_USD)
END as act
from ethereum.uniswapv3.ez_lp_actions
GROUP by days, ACTION