with removed_eth as(
SELECT
date,
sum(volume) as daily_deposited
from
(
SELECT
block_timestamp::date as date,
case
WHEN TOKEN0_SYMBOL='WETH' then 'weth'
WHEN TOKEN0_SYMBOL='ETH' then 'eth'
WHEN TOKEN1_SYMBOL='WETH' then 'weth'
WHEN TOKEN1_SYMBOL='ETH' then 'eth'
end as token_name,
case
WHEN TOKEN0_SYMBOL='WETH' then AMOUNT0_ADJUSTED
WHEN TOKEN0_SYMBOL='ETH' then AMOUNT0_ADJUSTED
WHEN TOKEN1_SYMBOL='WETH' then AMOUNT1_ADJUSTED
WHEN TOKEN1_SYMBOL='ETH' then AMOUNT1_ADJUSTED
end as volume
FROM ethereum.uniswapv3.ez_lp_actions
where token_name is not null and date>=CURRENT_DATE-90 and action='DECREASE_LIQUIDITY'
)
GROUP BY 1),
deposited_eth as(
SELECT
date,
sum(volume) as daily_removed
from
(
SELECT
block_timestamp::date as date,
case
WHEN TOKEN0_SYMBOL='WETH' then 'weth'
WHEN TOKEN0_SYMBOL='ETH' then 'eth'
WHEN TOKEN1_SYMBOL='WETH' then 'weth'