select
block_timestamp::date as date,
pool_name,
sum(rune_amount_usd + asset_amount_usd) as usd_amount,
sum(1) as count,
avg(rune_amount_usd + asset_amount_usd) as average
from flipside_prod_db.thorchain.liquidity_actions
where lp_action='add_liquidity'
and rune_amount = 0 and asset_amount > 0
and block_timestamp::date >='2022-01-01'
group by 1,2