nits Top 10 Liquidity Providers Fees in the Past year
    Updated 2022-01-10
    with top_10_liquidity_pairs as (select pool_name as pn, sum(amt_net) as liquidity_net from (select *, case when direction = 'IN' then amount_usd else amount_usd *(-1) end as amt_net from ethereum.dex_swaps
    where platform = 'sushiswap' and amount_usd is not NULL and pool_name != 'ARCX-WETH LP' and pool_name != 'WETH-CUT LP' and pool_name != 'OHM-WETH LP')
    group by pool_name
    order by liquidity_net desc
    limit 10)
    select * from
    (select pool_name, sum(amount_usd)/pow(10,3)*0.25/100 as fees_in_K from
    (select * from ethereum.dex_swaps
    where pool_name in (select pn from top_10_liquidity_pairs) and timestampdiff(SQL_TSI_DAY,block_timestamp, CURRENT_TIMESTAMP)<366 )
    GROUP by pool_name
    )
    order by fees_in_K desc


    Run a query to Download Data