headitmanagerYearly Numbers of each Action
Updated 2022-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with active_users_address as (select tx_from,count(distinct date_trunc('day', block_timestamp)) as activity_days
from osmosis.core.fact_transactions
group by tx_from
having activity_days >= 320),
active_users_tx as (select tx_id from osmosis.core.fact_transactions inner join active_users_address
on osmosis.core.fact_transactions.tx_from=active_users_address.tx_from) ,
transfer_tx as (select osmosis.core.fact_msgs.tx_id from osmosis.core.fact_msgs inner join active_users_tx
on osmosis.core.fact_msgs.tx_id = active_users_tx.tx_id
where MSG_TYPE='ibc_transfer')
select count(1) , MSG_TYPE ,date_trunc('year', block_timestamp) from osmosis.core.fact_msgs inner join active_users_tx
on osmosis.core.fact_msgs.tx_id = active_users_tx.tx_id
where MSG_TYPE in ('token_swapped','pool_joined','pool_exited','transfer','ibc_transfer')
group by 2 , 3
Run a query to Download Data