adambala$RUNE Upgrades
    Updated 2022-06-28
    with
    updates as
    (SELECT
    burn_asset,count(distinct FROM_ADDRESS) as address ,case when FROM_ADDRESS ilike 'b%' then 'bnb' else 'ETH' end as ee,
    SUM(rune_amount) as rune_volume,
    SUM(rune_amount_usd) as rune_volume_usd,date_trunc('day',block_timestamp) as date
    FROM thorchain.upgrades WHERE block_timestamp::DATE >CURRENT_DATE-60
    GROUP BY 1,3,6)
    select * FROM
    updates

    Run a query to Download Data