adambala$RUNE Upgrades
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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