when rune_amount = 0 then 'rune_only'

when asset_amount = 0 then 'asset_only'

else 'symmetric' end as typez

from thorchain.liquidity_actions

where lp_action = 'add_liquidity'),

symm as (select date_trunc('day', block_timestamp) as dt, pool_name, typez, count(distinct tx_id) as tx_count, sum(rune_amount_usd+asset_amount_usd) as lp_vol_usd

from raw

group by 1,2,3)

select pool_name, typez, sum(lp_vol_usd) as vol_usd, sum(tx_count) as tx_count

from symm

where dt >=CURRENT_DATE - 30

group by 1,2