SELECT DISTINCT b.pool_name, avg(b.rune_amount * p.rune_usd) avg_total_rune_locked, date_trunc('day', b.block_timestamp) as day
FROM thorchain.pool_block_balances b
JOIN thorchain.prices p on
b.block_timestamp = p.block_timestamp
GROUP BY 1, 3
Having avg_total_rune_locked > 0