Heminuniswap liquidity activety amount
    Updated 2022-11-24
    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
    Run a query to Download Data