HadisehLiquidity Pools - Wallet Composition 2
    Updated 2022-10-26
    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
    Run a query to Download Data