select currency ,
sum (balance/pow(10,decimal)) as total_volume
from osmosis.core.fact_daily_balances
where currency in (select currency from osmosis.core.fact_liquidity_provider_actions where currency ilike '%pool%')
and currency ilike '%pool%'
and balance_type = 'locked liquidity'
group by currency
order by total_volume
limit 10