flipside

    Most Gas Fees Paid by LPs
    CryptoLionMost Gas Fees Paid by LPs
    Updated 2022-11-27
    SELECT
    liquidity_provider,
    sum(fee_usd) as fees_paid
    FROM uniswapv3.lp_actions
    INNER JOIN ethereum.transactions on uniswapv3.lp_actions.tx_id = ethereum.transactions.tx_id
    GROUP BY liquidity_provider
    HAVING fees_paid > 10000
    ORDER BY fees_paid DESC
    Run a query to Download Data