BlockTracker$KAITO claims
    Updated 2025-02-24
    select
    date_trunc('{{granularity}}', BLOCK_TIMESTAMP) as date,
    sum(amount) as T_drop,
    sum(T_drop) over (order by date) as total_t_drop,
    sum(amount_usd) as T_drop_usd,
    count(distinct origin_from_address) as wallet,
    count(distinct to_address) as n_wallet2,
    count(distinct tx_hash) as n_txns
    from base.core.ez_token_transfers
    where
    from_address = lower('0xeB7d383B0c77EA0Bed28b42D0C288F9071Bd8a7a')
    and contract_address = lower('0x98d0baa52b2D063E780DE12F615f963Fe8537553')
    group by 1
    order by 1 desc



    QueryRunArchived: QueryRun has been archived