SpecterTop User
Updated 2025-02-14Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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