from thorchain.upgrades

where burn_asset = 'BNB.RUNE-B1A'

group by 1),

eth as (select date_trunc('day', block_timestamp) as dt, sum(rune_amount) as rune_eth

from thorchain.upgrades

where burn_asset = 'ETH.RUNE-0X3155BA85D5F96B2D030A4966AF206230E46849CB'

group by 1)

select a.dt, a.rune_bnb, b.rune_eth, (a.rune_bnb + b.rune_eth) as total, round((a.rune_bnb/total),2) as BEP2_BNB, (1 - BEP2_BNB) as ERC_20_ETH

from bnb a

left outer join eth b on a.dt = b.dt