UNIQUE_CLAIMERS | TOTAL_TOKEN_CLAIMED | TOTAL_CLAIMED_USD | AVG_CLAIM_PER_USER | AVG_CLAIM_USD | TOTAL_TRANSACTIONS | |
---|---|---|---|---|---|---|
1 | 44346 | 2785704.99380646 | 314098.29 | 1.598129883 | 0.180194911 | 270539 |
damidezPixel Reward claim
Updated 2025-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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
1
67B
3s