select

date,

address,

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

balance_type

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

select

date,

address,

balance

from token_location

where balance > 1e5

and balance_type = 'liquid'

order by date asc