select

pool_address,

pool_name,

token0,

token1

from ethereum.core.dim_dex_liquidity_pools

where platform = 'uniswap-v3' or platform = 'uniswap-v2'

select

symbol,

sum(amount_usd) as volume

from ethereum.erc20_balances, uniswap_pools

where user_address = pool_address

and contract_address in (token0, token1)

and balance_date = current_date

and amount_usd < 500000000

and amount_usd is not null

and symbol in ('USDC', 'WETH', 'DAI', 'USDT', 'WBTC', 'sETH2', 'agEUR', 'FRAX', 'USDM', 'SWYF')

group by symbol

having volume > 100000

order by volume desc

limit 10