Afonso_Diaz2023-04-21 08:24 PM
    Updated 2023-10-16
    with
    t2 as (
    select
    'Flow' as chain,
    count(distinct node_id) as validators
    from flow.gov.ez_staking_actions
    where tx_succeeded = 1
    and action in ('TokensCommitted', 'DelegatorTokensCommitted')
    group by 1

    union all

    select
    'Axelar' as chain,
    count(distinct b.attribute_value) as validators
    from axelar.core.fact_transactions c
    join axelar.core.fact_msg_attributes a
    using(tx_id)
    join axelar.core.fact_msg_attributes b
    using(tx_id)
    where tx_succeeded = 1
    and a.attribute_key = 'amount'
    and a.msg_type = 'delegate'
    and b.attribute_key = 'validator'
    and b.msg_type = 'delegate'
    group by 1

    union all

    select
    'Osmosis' as chain,
    count(distinct b.attribute_value) as validators
    from osmosis.core.fact_transactions c
    join osmosis.core.fact_msg_attributes a
    using(tx_id)
    join osmosis.core.fact_msg_attributes b
    Run a query to Download Data