User Address | METRIC | Value | STATUS | |
|---|---|---|---|---|
1 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Transaction Count | 417972 | Top 5% |
2 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Total Fee Spent | 1279.510974388 | Top 5% |
3 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Contract Interacted Count | 377 | Top 5% |
4 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Total Active Day | 45 | Top 5% |
5 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Total Active Week | 11 | Top 5% |
6 | 0x34fc28633b58c8bd023b8d51917e22f7afa1bacb | Total Active Month | 4 | Top 5% |
tkvresearchfair-emerald
Updated 2025-05-11
999
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 contract as
(select address,
symbol,
name
from monad.testnet.dim_contracts),
last_tab as
(select user_add as "User Address",
tx_cnt,
CASE
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.05 THEN 'Top 5%'
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.1 and PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) > 0.05 THEN 'Top 10%'
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.3 and PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) > 0.1 THEN 'Top 30%'
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.5 and PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) > 0.3 THEN 'Top 50%'
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.7 and PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) > 0.5 THEN 'Top 70%'
WHEN PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) <= 0.9 and PERCENT_RANK() OVER (ORDER BY TX_CNT DESC) > 0.7 THEN 'Top 90%'
ELSE 'Top >90%'
END AS "TX Status",
total_fee_spent,
CASE
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.05 THEN 'Top 5%'
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.1 and PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) > 0.05 THEN 'Top 10%'
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.3 and PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) > 0.1 THEN 'Top 30%'
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.5 and PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) > 0.3 THEN 'Top 50%'
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.7 and PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) > 0.5 THEN 'Top 70%'
WHEN PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) <= 0.9 and PERCENT_RANK() OVER (ORDER BY total_fee_spent DESC) > 0.7 THEN 'Top 90%'
ELSE 'Top >90%'
END AS "Fee Spent Status",
contract_cnt,
CASE
WHEN PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) <= 0.05 THEN 'Top 5%'
WHEN PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) <= 0.1 and PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) > 0.05 THEN 'Top 10%'
WHEN PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) <= 0.3 and PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) > 0.1 THEN 'Top 30%'
WHEN PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) <= 0.5 and PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) > 0.3 THEN 'Top 50%'
WHEN PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) <= 0.7 and PERCENT_RANK() OVER (ORDER BY contract_cnt DESC) > 0.5 THEN 'Top 70%'
Last run: 6 days ago
6
497B
508s