zanglangRelayer DAO Active Wallets Count
Updated 2024-06-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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