select

block_timestamp,

from_asset,

to_amount

from thorchain.swaps

where from_asset like '%/%'

),

rune_price as (

select

date_trunc('week', block_timestamp) as time,

sum(to_amount)/sum(from_amount) as avg_price

from thorchain.swaps

where from_asset = 'THOR.RUNE'

and to_asset = 'BNB/BUSD-BD1'

group by 1

),

burn_amount as (

select

date_trunc('week', block_timestamp) as time,

from_asset,

sum(to_amount) as burn_amount

from burning_transaction

group by 1, 2

select

burn_amount.*,

avg_price * burn_amount as burn_amount_usd

from burn_amount

left join rune_price on (burn_amount.time = rune_price.time)