with raw as (select date(block_timestamp) as dt, pool_name, (rune_amount_usd+asset_amount_usd) as vol_usd
from thorchain.liquidity_actions
where lp_action = 'add_liquidity')
select date_trunc('day', dt) as ddt, pool_name, sum(vol_usd) as total_vol_usd, avg(vol_usd) as average_lp
from raw
group by 1,2