flipside

    3.Fees, Fees, & More Fees
    MPL3.Fees, Fees, & More Fees
    Updated 2022-11-03

    SELECT
    SUM(AMOUNT0_ADJUSTED)
    ,SUM(AMOUNT1_ADJUSTED)
    FROM ethereum.uniswapv3.ez_position_collected_fees
    WHERE block_timestamp > current_date - 30

    -- Write a query using the SUM function against the amount0_adjusted_usd and amount2_adjusted_usd columns to show the fees collected for your pool of choice over the past 30 days
    -- hint: you can restrict your query to the past 30 days using the current_date: WHERE block_timestamp > current_date - 30
    -- hint: when you’re using an aggregation like SUM, any column that’s not being summed must be in your GROUP BY statement (e.g., pool_name, pool_address, etc. if you choose to select those columns.)

    Run a query to Download Data