from osmosis.core.fact_daily_balances

where CURRENCY = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and date = CURRENT_DATE - 1)

select project_name ,

count(DISTINCT a.address) as total_users

from osmosis.core.fact_daily_balances a join osmosis.core.dim_labels b on a.currency = b.address

where date = CURRENT_DATE - 1

and a.address in (select address from holders)

and currency != 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

group by project_name

order by total_users desc

limit 10