lagandispensertotal amountRUNE upgraded based asset
    Updated 2022-06-28
    select
    date_trunc(day,BLOCK_TIMESTAMP) as date ,
    case when BURN_ASSET ilike '%BNB%' then 'BNB.RUNE'
    when BURN_ASSET ilike '%ETH%' then 'ETH.RUNE'
    end as old_asset,
    sum (RUNE_AMOUNT) as sum_amount , sum (sum_amount) over (partition by old_asset order by date ) as cum_amount ,
    count (DISTINCT from_address) as num_old_addresess,
    count (DISTINCT to_address) as num_new_addresses,
    sum (RUNE_AMOUNT_USD) as sum_USD_amount, sum (sum_USD_amount) over (partition by old_asset order by date ) AS cum_amount_USD
    from flipside_prod_db.thorchain.upgrades
    where BLOCK_TIMESTAMP >= CURRENT_DATE -30
    group by 1,2

    Run a query to Download Data