date_trunc('{{ period }}', block_timestamp) as date,

split(pool_name, '-')[0] as pool_name,

avg (iff(rune_amount_usd > 0, rune_amount_usd, asset_amount_usd)) as balance_usd

thorchain.defi.fact_pool_block_balances

where

block_timestamp between '{{ start_date }}' and '{{ end_date }}'

group by 1, 2

order by 1, 2