rezarwzDaily chart of the result of entry and exit of Ethereum on UniSwap V3 in last quarter
    Updated 2022-09-25
    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'
    Run a query to Download Data