select
blocktime,
burn_asset,
rune_amount,
100 * ratio_to_report(rune_amount) over (partition by blocktime) as percentage
from (
select
date_trunc('week', block_timestamp) as blocktime,
substr(burn_asset,1, position('-', burn_asset,1) - 1) as burn_asset,
sum(rune_amount) as rune_amount
from thorchain.upgrades
group by blocktime, burn_asset
)
where blocktime > getdate() - interval'90 days'