maybeyonasrune_burn_q4
Updated 2022-06-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
-- *
last_day(block_timestamp,'week') as date,
-- date(block_timestamp) as date,
split(burn_asset,'-')[0]::string as burn_asset,
-- year(block_timestamp) as year,
count(to_address) as txs,
count(distinct to_address) as users,
sum(rune_amount) as rune_burned,
sum(rune_amount_usd) as usd_burned
from thorchain.upgrades
-- where rune_amount <= 20000000
where block_timestamp > '2022-02-01'
group by 1,2
order by date DESC
-- order by rune_amount desc
Run a query to Download Data