trunc(block_timestamp,'day') as date,

pool_name,

avg(asset_amount_usd) as amount_usd

from thorchain.pool_block_balances

where pool_name like '%TERRA%'

--block_timestamp=CURRENT_DATE-1

group by 1,2

order by 1 asc, 3 desc