STATUS | N_CLAIMANTS | CLAIMED_AMT | |
|---|---|---|---|
1 | Paper Hands | 74933 | 24435896.2156967 |
2 | Partial Transferred or Sold | 10483 | 5041653.88763727 |
3 | Dimond Hands | 6725 | 1005512.11652956 |
4 | Accumulating | 763 | 707730.332097723 |
0xHaM-dUser Behavior After Claim
Updated 2025-03-02
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
30
31
32
33
34
35
36
›
⌄
with claim_txs as (
select
block_timestamp,
tx_hash,
to_address as claimant,
amount as claimed_amount,
from base.core.ez_token_transfers
where from_address = '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'
and contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and origin_function_signature = '0x69659658'
)
,
transfer_swap as (
SELECT
TO_ADDRESS as user,
AMOUNT as amount
FROM base.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and block_timestamp >= '2024-12-10 14:05:13.000'
UNION ALL
SELECT
FROM_ADDRESS as user,
-1*AMOUNT as amount
FROM base.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and block_timestamp >= '2024-12-10 14:05:13.000'
UNION ALL
SELECT
ORIGIN_FROM_ADDRESS as user,
AMOUNT_IN*-1 as amount
FROM base.defi.ez_dex_swaps
WHERE TOKEN_IN = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and block_timestamp >= '2024-12-10 14:05:13.000'
UNION ALL
SELECT
ORIGIN_FROM_ADDRESS as user,
Last run: about 2 months ago
4
172B
9s