with eth_rune_volume as(

select date_trunc('day',block_timestamp) as date1, Burn_asset, sum(rune_amount) as volume_ethrune, sum(rune_amount_usd) as volume_usd_ethrune

from thorchain.upgrades

where Burn_asset='ETH.RUNE-0X3155BA85D5F96B2D030A4966AF206230E46849CB' and date1>'2021-10-01'

group by date1,burn_asset

),

bnb_rune_volume as

select date_trunc('day',block_timestamp) as date2, Burn_asset, sum(rune_amount) as volume_bnbrune, sum(rune_amount_usd) as volume_usd_bnbrune

from thorchain.upgrades

where Burn_asset='BNB.RUNE-B1A' and date2>'2021-10-01'

group by date2,burn_asset

)

select bnb_rune_volume.date2, volume_ethrune, volume_usd_ethrune, volume_bnbrune, volume_usd_bnbrune

from eth_rune_volume

inner join bnb_rune_volume on eth_rune_volume.date1=bnb_rune_volume.date2