select recorded_at::date as days,

symbol,

address,

avg (price) as USDPrice

from osmosis.core.dim_prices a join osmosis.core.dim_labels b on project_name = symbol

group by 1,2,3),

balances as (

-- date_trunc(week,date) as day,

symbol,

currency,

case when symbol='INJ' then avg (balance/pow(10,18))

else sum (balance/pow(10,decimal)) end as avg_balance ,

case when symbol='INJ' then avg (balance*usdprice/pow(10,18))

else sum (balance*usdprice/pow(10,decimal)) end as avg_usd_balance

from osmosis.core.fact_daily_balances a join prices b on a.currency = b.address and a.date = b.days

group by 1,2

having avg_usd_balance > 0)

select *

from balances