MIN_TX_FOR_TOP_1_PERCENT | |
|---|---|
1 | 45149 |
Mrfticostly-silver
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(*) 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 min_tx_for_top_1_percent
FROM wallet_percentiles
WHERE percentile >= 0.99;
Last run: about 1 month ago
1
9B
523s