Pmisha-bmlMdxburn.1
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
date_trunc('week',s.BLOCK_TIMESTAMP) as dt,
count(distinct s.tx_id) as burns,
sum(s.amount/1e6) as burn_vol
from osmosis.core.FACT_TRANSFERS s left outer join osmosis.core.fact_msg_attributes b on s.tx_id=b.tx_id
where s.tx_id is not NULL
and TX_STATUS='SUCCEEDED'
and b.MSG_TYPE='burn'
group by 1
order by 3 desc
Run a query to Download Data