select
date_trunc('day', date) as day,
sum(balance/pow(10,decimal)) as osmo_volume,
'Staking' as type
from osmosis.core.fact_daily_balances
where currency = 'uosmo' and balance_type = 'staked' and day >= '2022-01-01'
group by 1
union all
select
date_trunc('day', date) as day,
sum(balance/pow(10,decimal)) as osmo_volume,
'Liquidity' as type
from osmosis.core.fact_daily_balances
where currency = 'uosmo' and balance_type = 'liquid' and day >= '2022-01-01'
group by 1