SELECT BLOCK_TIMESTAMP,

LIQUIDITY_PROVIDER,

AMOUNT1_ADJUSTED AS number

FROM ethereum.uniswapv3.ez_lp_actions

WHERE ACTION = 'DECREASE_LIQUIDITY' AND (TOKEN1_SYMBOL = 'WETH' OR TOKEN1_SYMBOL = 'ETH')

UNION

SELECT BLOCK_TIMESTAMP,

LIQUIDITY_PROVIDER,

AMOUNT0_ADJUSTED AS number

FROM ethereum.uniswapv3.ez_lp_actions

WHERE ACTION = 'DECREASE_LIQUIDITY' AND (TOKEN0_SYMBOL = 'WETH' OR TOKEN0_SYMBOL='ETH')

)

SELECT date_trunc('month', BLOCK_TIMESTAMP) AS month,

sum(number) AS number

FROM uniswapEthRemoved

GROUP by 1

ORDER by 1 ASC