Top 1% Users | Min tx to be among top 1% | |
|---|---|---|
1 | 180486 | 214 |
Mrftitx count
Updated 16 hours ago
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
31
›
⌄
-- forked from raw-turquoise copy @ https://flipsidecrypto.xyz/studio/queries/f7def9bc-6def-4ec2-9c85-d145fc096fe0
WITH user_tx_counts AS (
SELECT
from_address AS "Addresses",
COUNT(DISTINCT tx_hash) AS "Total_tx"
FROM
monad.testnet.fact_transactions
GROUP BY
from_address
),
user_ranks AS (
SELECT
"Addresses",
"Total_tx",
NTILE(100) OVER (ORDER BY "Total_tx" DESC) AS percentile
FROM
user_tx_counts
)
SELECT
COUNT(*) AS "Top 1% Users",
MIN("Total_tx") AS "Min tx to be among top 1%"
FROM
user_ranks
WHERE
percentile = 1;
Last run: about 16 hours ago
1
14B
36s