SELECT

DISTINCT pool_address

FROM ethereum.dex_liquidity_pools

WHERE platform LIKE 'sushiswap'

), tab2 as (

SELECT

symbol,

user_address,

avg(amount_usd) as amt

from ethereum.erc20_balances

WHERE user_address IN (SELECT pool_address FROM tab1)

AND balance_date > CURRENT_DATE - 3

GROUP BY 1,2

SELECT

symbol,

sum(amt)

FROM tab2

WHERE amt IS NOT NULL

AND symbol IS NOT NULL

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10