SpecterTop User
    Updated 2025-02-14
    WITH claims AS ( SELECT Block_timestamp, tx_hash, to_address AS user,
    name, amount, amount_usd
    FROM ronin.core.ez_token_transfers
    WHERE origin_to_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6'
    AND contract_address = '0x7eae20d11ef8c779433eb24503def900b9d28ad7'
    --AND TX_HASH = '0xa31ec41408566847076b0393943dd2e3888f465140e728a8ccca82cf69aaea65'
    AND amount > 0
    and amount_usd is not null
    )

    SELECT user, COUNT(DISTINCT tx_hash) AS claim_count,
    SUM(amount_USD) AS total_claimed
    FROM claims
    GROUP BY user
    ORDER BY total_claimed DESC
    LIMIT 50;




    QueryRunArchived: QueryRun has been archived