BREAKDOWN | TRANSACTIONS | |
|---|---|---|
1 | a. < 10 $ | 37815 |
2 | b. 10 - 50 $ | 2054 |
3 | c. 50 - 100 $ | 249 |
4 | d. 100 - 500 $ | 266 |
5 | e. 500 - 1K $ | 42 |
6 | f. 1K - 5K $ | 40 |
7 | g. 5K - 10K $ | 4 |
8 | h. 10K - 100K $ | 2 |
0xHaM-dUser Breakdown
Updated 2025-03-08
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 eventTb as (
select
BLOCK_TIMESTAMP,
TX_HASH,
FROM_ADDRESS,
TO_ADDRESS,
ORIGIN_FROM_ADDRESS,
case when ORIGIN_FUNCTION_SIGNATURE in ('0xe0e50bfb','0x0efe6a8b') Then 'deposit' else 'withdraw' end as action_type,
AMOUNT,
AMOUNT_USD,
from ink.core.ez_native_transfers
where ORIGIN_TO_ADDRESS = '0xcab283e4bb527aa9b157bae7180fef19e2aaa71a'
and TRACE_ADDRESS = 'ORIGIN'
and ORIGIN_FUNCTION_SIGNATURE in ('0xe0e50bfb','0x0efe6a8b', '0xf37e8d38')
)
,
priceTb as (
select
hour,
avg(price) as price
from
crosschain.price.ez_prices_hourly
where
blockchain = 'ethereum'
and token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'
group by 1
)
,
transafer as (
select
t1.BLOCK_TIMESTAMP,
t1.TX_HASH,
t1.FROM_ADDRESS,
t1.TO_ADDRESS,
t1.ORIGIN_FROM_ADDRESS,
'withdraw' as action_type,
Last run: about 2 months ago
8
171B
21s