shadilSynth Utilization
    Updated 2022-04-12
    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