Eman-Raz🏃‍♂️5 Users with the Highest Number of Reward Claim Transactions
    Updated 2024-03-20
    select origin_from_address as "👨‍💻Claimer", count(distinct tx_hash) as "🔗Claim TX Count", sum(amount) as "🎁Reward (PNG)", sum(amount_usd) as "💰Reward (USD)"
    from avalanche.core.ez_token_transfers
    where origin_to_address='0x1f806f7c8ded893fd3cae279191ad7aa3798e928'
    and contract_address='0x60781c2586d68229fde47564546784ab3faca982' AND
    block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'
    group by 1
    order by 2 desc
    limit 5

    QueryRunArchived: QueryRun has been archived