select block_timestamp::date as fecha,

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,2

order by 3 desc

),

BURNS AS (

select block_timestamp::date as fecha,

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,2

order by 3 desc

select m.fecha,

case

when CHARINDEX('-', m.mint_asset) > 0 then left( m.mint_asset, CHARINDEX('-', m.mint_asset)-1)

else m.mint_asset

end as pool_names,

m.mints,

split_part (m.mint_asset, '/',0) as network,

m.to_volume_RUNE,

m.mint_fees,

--b.burn_asset,

b.burns,

b.from_volume_RUNE,