USER_ADDRESS | CLAIM_AMOUNT | RANK | |
|---|---|---|---|
1 | 0x185d157237cde21c63831adfa1b0b3eedeeca92b | 1069240.46413788 | 24 |
freemartianSearch by user address
Updated 2025-05-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
with users as (
select
to_address as user_address,
SUM(amount) as claim_amount,
SUM(amount_usd) as claim_amount_usd,
rank() over(order by claim_amount desc) as rank
from base.core.ez_token_transfers
where contract_address = '0x1111111111166b7fe7bd91427724b487980afc69'
and from_address = lower('0x0000000002ba96C69b95E32CAAB8fc38bAB8B3F8')
and block_timestamp >= '2025-04-23 13:00:00.000'
and to_address <> '0x1111111111166b7fe7bd91427724b487980afc69'
and origin_function_signature in ('0x1e83409a','0xd7ff1a57')
group by 1
order by 3 desc
)
select
user_address,
claim_amount,
rank
from users
where user_address = lower ('{{Address}}')
Last run: 13 days agoAuto-refreshes every 1 hour
1
68B
17s