KaskoazulNet Synth Amounts
    Updated 2022-05-02
    WITH MINTS_CHAIN AS (
    select from_asset as mint_asset,
    count(distinct tx_id) as mints,
    sum(to_amount) as to_volume_RUNE,
    sum(liq_fee_rune) as mint_fees
    from thorchain.swaps
    where from_asset like '%/%'
    group by 1
    --order by 3 desc
    ),

    BURNS_CHAIN AS (
    select to_asset as burn_asset,
    count(distinct tx_id) as burns,
    sum(from_amount) as from_volume_RUNE,
    sum(liq_fee_rune) as burn_fees
    from thorchain.swaps
    where to_asset like '%/%'
    group by 1
    -- order by 3 desc
    )
    select split_part(m.mint_asset,'-',1) as asset_name,
    split_part(asset_name,'/',1) as chain,
    split_part(asset_name,'/',2) as asset,
    case asset
    when 'WBTC' then 'BTC'
    when 'BTCB' then 'BTC'
    else asset
    end as asset_mod,
    m.mints,
    m.to_volume_RUNE,
    m.mint_fees,
    --b.burn_asset,
    b.burns,
    b.from_volume_RUNE,
    Run a query to Download Data