date(block_timestamp) as date,

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

median(rune_amount) as rune_amount,

median(rune_amount_usd) as rune_amount_usd,

median(asset_amount) as asset_amount,

median(asset_amount_usd) as asset_amount_usd,

median(synth_amount) as synth_amount,

median(synth_amount_usd) as synth_amount_usd,

median(synth_amount/asset_amount)*100 as synth_utilization

from thorchain.pool_block_balances

where asset_amount > 0

and synth_amount > 0

group by 1,2

order by date desc,synth_amount_usd desc

limit 1000