flipside

    uniswap liquidity activety transaction numbers
    Heminuniswap liquidity activety transaction numbers
    Updated 2022-11-24
    SELECT BLOCK_TIMESTAMP::date as days,
    ACTION,
    CASE
    WHEN ACTION LIKE 'DECREASE_LIQUIDITY' THEN COUNT(tx_hash)
    WHEN ACTION LIKE 'INCREASE_LIQUIDITY' THEN COUNT(tx_hash)
    END as act
    from ethereum.uniswapv3.ez_lp_actions
    GROUP by days, ACTION
    Run a query to Download Data