ethereum.core.dim_dex_liquidity_pools.pool_name as pool,

avg(flipside_prod_db.ethereum.erc20_balances.amount_usd)

from ethereum.core.dim_dex_liquidity_pools

left outer join flipside_prod_db.ethereum.erc20_balances

on ethereum.core.dim_dex_liquidity_pools.pool_address = flipside_prod_db.ethereum.erc20_balances.user_address

where balance_date > current_date - 4

group by 1

having avg(flipside_prod_db.ethereum.erc20_balances.amount_usd) > 100000