damidezPixel Reward claim
    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 amount != 0
    And amount_usd is not null
    )

    -- Final aggregation for insights
    SELECT
    --claim_date,
    COUNT(DISTINCT user) AS unique_claimers, -- Unique wallets claiming rewards
    SUM(amount) AS total_token_claimed, -- Total $PIXEL tokens claimed
    SUM(amount_usd) AS total_claimed_usd, -- Total USD value of claims
    AVG(amount) AS avg_claim_per_user, -- Average tokens claimed per user
    AVG(amount_usd) AS avg_claim_usd, -- Average USD claim per user
    COUNT(DISTINCT tx_hash) AS total_transactions -- Total number of transactions
    FROM claims
    --GROUP BY 1
    --ORDER BY claim_date DESC;

    Last run: about 1 month ago
    UNIQUE_CLAIMERS
    TOTAL_TOKEN_CLAIMED
    TOTAL_CLAIMED_USD
    AVG_CLAIM_PER_USER
    AVG_CLAIM_USD
    TOTAL_TRANSACTIONS
    1
    443462785704.99380646314098.291.5981298830.180194911270539
    1
    67B
    3s