Minimum tx to be among top 1% | |
|---|---|
1 | 45149 |
Mrftifierce-green
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH wallet_tx_counts AS (
SELECT
s.value::string as wallet,
COUNT(distinct tx_id) as tx_count
FROM eclipse.core.fact_transactions,
LATERAL FLATTEN(input => signers) s
WHERE succeeded = TRUE
GROUP BY 1
),
wallet_percentiles AS (
SELECT
wallet,
tx_count,
PERCENT_RANK() OVER (ORDER BY tx_count) as percentile
FROM wallet_tx_counts
)
SELECT
MIN(tx_count) as "Minimum tx to be among top 1%"
FROM wallet_percentiles
WHERE percentile >= 0.99;
Last run: about 1 month ago
1
9B
176s