Top 1% Users | Min fee to be among top 1% | |
|---|---|---|
1 | 341847 | 1.03758064 |
Mrftiraw-turquoise copy copy
Updated 2025-01-31
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
›
⌄
-- forked from raw-turquoise copy @ https://flipsidecrypto.xyz/studio/queries/563372e6-4e8c-4d9c-9513-e036926fbdae
WITH user_fee AS (
SELECT
from_address AS "Addresses",
sum (TX_FEE_PRECISE) AS "Total fee"
FROM
berachain.testnet.fact_transactions
GROUP BY 1
),
user_ranks AS (
SELECT
"Addresses",
"Total fee",
NTILE(100) OVER (ORDER BY "Total fee" DESC) AS percentile
FROM
user_fee
)
SELECT
COUNT(*) AS "Top 1% Users",
MIN("Total fee") AS "Min fee to be among top 1%"
FROM
user_ranks
WHERE
percentile = 1;
Last run: 14 days ago
1
21B
53s