Updated 2022-11-15
    SELECT BLOCK_NUMBER, LEG, SUM(FEES_PAID) as BLOCK_FEES_PAID, array_agg(distinct TICK) as TICKS
    FROM
    (
    SELECT BLOCK_NUMBER, TX_HASH, TICK,
    CASE
    WHEN AMOUNT0_ADJUSTED < 0 THEN AMOUNT1_ADJUSTED
    ELSE AMOUNT0_ADJUSTED
    END as INPUT_AMOUNT,
    CASE
    WHEN AMOUNT0_ADJUSTED < 0 THEN 'QUOTE'
    ELSE 'BASE'
    END as LEG,
    SPLIT(POOL_NAME,' ')[1]/1000000 as FEE_RATE,
    INPUT_AMOUNT * FEE_RATE as FEES_PAID
    FROM ethereum.uniswapv3.ez_swaps
    WHERE POOL_ADDRESS = '0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'
    )
    GROUP BY BLOCK_NUMBER, LEG
    ORDER BY BLOCK_NUMBER DESC
    Run a query to Download Data