theericstoneTop Uniswap Moneymakers
    Updated 2022-02-06
    with winners as (
    select liquidity_provider as address,
    sum(amount0_usd) as amount0_earned,
    sum(amount1_usd) as amount1_earned,
    coalesce(amount0_earned,0) + coalesce(amount1_earned,0) as amount_earned
    from
    uniswapv3.position_collected_fees
    where block_timestamp > current_date - 14
    group by 1
    order by 4 desc
    ),

    rankwins as (
    select winners.*,
    rank() over (order by amount_earned desc) as rank
    from winners
    )

    select * from rankwins where rank < 101 order by 4 desc;

    Run a query to Download Data