project_name as "Project",

count(distinct a.address) as "Number of Addresses",

avg (balance/ pow(10,6)) as "Balance (Average)",

max (balance/ pow(10,6)) as "Balance (Max)",

min (balance/ pow(10,6)) as "Balance (Min)"

from osmosis.core.fact_daily_balances a

inner join osmosis.core.dim_labels b

where a.currency = b.address

and balance_type = 'liquid'

and not currency like 'gamm/%'

and date >= '2022-01-01'

group by 1

order by 2 desc

limit 15