headitmanagerYearly Numbers of each Action
    Updated 2022-10-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