select

date,

address,

balance * pow(10,-decimal) as balance,

balance_type

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

select

date,

balance_type,

sum(balance) as balance

from token_location

group by 1,2

order by date asc