binhachon39. ETH.RUNE upgrades vs BNB.RUNE upgrades - Daily stats
    Updated 2022-01-09
    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'

    Run a query to Download Data