lagandispensertotal amountRUNE upgraded based asset
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
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