zanglangRelayer DAO Active Wallets Count
    Updated 2024-06-18
    with grantees as (
    select
    distinct e.attribute_value
    from cosmos.core.fact_msg_attributes l, cosmos.core.fact_msg_attributes r, cosmos.core.fact_msg_attributes e
    where
    l.block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
    and r.block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
    and e.block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
    and l.msg_type = 'use_feegrant'
    and l.attribute_key = 'granter'
    and l.attribute_value = 'cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp'
    and r.attribute_key = 'action'
    and r.attribute_value like '/ibc.%'
    and e.msg_type = 'use_feegrant'
    and e.attribute_key = 'grantee'
    and l.tx_id = r.tx_id
    and l.tx_id = e.tx_id
    )
    select
    count(attribute_value)
    from grantees
    Auto-refreshes every 12 hours
    QueryRunArchived: QueryRun has been archived