banbannardBurn the House Down 2
Updated 2022-06-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with base as (select *
from osmosis.core.fact_msg_attributes
where msg_type = 'burn')
--and attribute_key = 'amount'
--and attribute_value like '%osmo'
select
date_trunc('week', block_timestamp) as week,
label,
decimal,
count(distinct(tx_id))
--sum(amount)/pow(10,decimal) as token_amount
from osmosis.core.fact_transfers a
join osmosis.core.dim_labels b
on a.currency = b.address
where tx_id in (select tx_id from base)
--and label in ('Juno', 'Secret Network', 'Cosmos')
group by 1,2,3
order by 4 desc
Run a query to Download Data