shadilSynth Utilization
Updated 2022-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT date(block_timestamp) as date,
split(pool_name, '.')[1] as pool_name_tmp,
split(pool_name_tmp, '-')[0] as pool_name_part,
split(pool_name, '.')[0] as network,
concat(pool_name_part, ' - ', network) as pool_name,
sum(asset_amount_usd) as balance_asset,
sum(SYNTH_AMOUNT_usd) as synth_supply,
ROUND((synth_supply/balance_asset) * 100, 1) as synth_utilisation
from thorchain.pool_block_balances
where SYNTH_AMOUNT > 0
and asset_amount_usd > 0
GROUP BY date, pool_name
order by synth_utilisation DESC
Run a query to Download Data