DATE | ADDRESS | TOKENS_SPENT | |
---|---|---|---|
1 | 2025-02-12 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 8.855906 |
2 | 2025-02-11 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 18.616557 |
3 | 2025-02-10 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 16.515849 |
4 | 2025-02-09 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 19.031016 |
5 | 2025-02-08 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 17.224617 |
6 | 2025-02-07 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 25.548656 |
7 | 2025-02-06 00:00:00.000 | cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp | 22.411565 |
zanglangRelayer DAO Daily Spend
Updated 13 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
›
⌄
with ibc_msgs as (
select
l.tx_id
from cosmos.core.fact_msg_attributes l, cosmos.core.fact_msg_attributes r
where
l.block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
and r.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 l.tx_id = r.tx_id
),
ibc_txs as (
select
tx_id,
tx_from,
block_timestamp,
fee / pow(10, 6) as fee_amount
from cosmos.core.fact_transactions
where
tx_id in (select tx_id from ibc_msgs)
and block_timestamp >= CURRENT_DATE - interval '{{ day }} day'
and fee_denom LIKE '%uatom'
)
select
date_trunc('dd', block_timestamp) as date,
tx_from as address,
sum(fee_amount) as tokens_spent
from ibc_txs
group by 1, 2
order by 1 desc, 3 desc
Last run: about 13 hours agoAuto-refreshes every 12 hours
7
602B
5s