zanglangRelayer DAO Daily Spend
    Updated 13 hours ago
    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
    DATE
    ADDRESS
    TOKENS_SPENT
    1
    2025-02-12 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp8.855906
    2
    2025-02-11 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp18.616557
    3
    2025-02-10 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp16.515849
    4
    2025-02-09 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp19.031016
    5
    2025-02-08 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp17.224617
    6
    2025-02-07 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp25.548656
    7
    2025-02-06 00:00:00.000cosmos14r8ff03jkyac2fukjtfrfgaj8ehjlhds5ec2zp22.411565
    7
    602B
    5s