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,
QueryRunArchived: QueryRun has been archived