Your address | Your tx count | Your Ranking | You are higher than % of addresses | |
|---|---|---|---|---|
1 | FfbHGx4mHjLYSsUmZk1wfm8Gi8rWJoX2kZTi5S66jrtj | 2 | 704995 | 12.64 |
Mrftiusual-ivory
Updated 2025-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH wallet_rankings AS (
SELECT
s.value::string as wallet,
COUNT(DISTINCT tx_id) as tx_count,
RANK() OVER (ORDER BY COUNT(DISTINCT tx_id) DESC) as rank,
PERCENT_RANK() OVER (ORDER BY COUNT(DISTINCT tx_id) DESC) as percentile
FROM eclipse.core.fact_transactions,
LATERAL FLATTEN(input => signers) s
WHERE succeeded = TRUE
AND block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP)
GROUP BY 1
)
SELECT
wallet as "Your address",
tx_count as "Your tx count",
rank as "Your Ranking",
ROUND(percentile * 100, 2) as "You are higher than % of addresses"
FROM wallet_rankings
WHERE wallet = ('{{Address}}');
Last run: about 1 month ago
1
65B
125s