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' and pool_name not in ('ETH.WBTC-0X2260FAC5E5542A773AA44FBCFEDF7C193BC2C599'))
select pool_name, sum(vol_usd) as total_vol_usd, avg(vol_usd) as average_lp, 1000 as "$1000"
from raw
group by 1