select date_trunc(week, block_timestamp::date) as date,
split(pool_name, '-')[0] as poolname,
avg (coalesce (rune_amount_usd,0) + coalesce (asset_amount_usd,0)) as Balance
from thorchain.defi.fact_pool_block_balances
where block_timestamp >= '2024-01-01'
and block_timestamp < date_trunc(week,current_date)
group by 1,2 order by 1 desc