Tier | Total Addresses | |
|---|---|---|
1 | tier1: only 1 tx | 8246537 |
2 | tier2: 2-10 txs | 4843142 |
3 | tier3: 10-100 txs | 2152809 |
4 | tier4: 100-1000 txs | 393562 |
5 | tier5: more then 1000 txs | 32731 |
Mrftiusers tx count
Updated 2 days 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
›
⌄
-- forked from similar-cyan copy @ https://flipsidecrypto.xyz/studio/queries/23dc79b6-2bbb-4727-9bd8-c0093ce8e9e6
with tbl AS
(
SELECT
from_address as "Address",
count (DISTINCT tx_hash) as "Total tx"
from monad.testnet.fact_transactions
GROUP by 1
order by 2 DESC
)
SELECT case when "Total tx" = 1 then 'tier1: only 1 tx'
when "Total tx" > 1 and "Total tx" <= 10 then 'tier2: 2-10 txs'
when "Total tx" > 10 and "Total tx" <= 100 then 'tier3: 10-100 txs'
when "Total tx" > 100 and "Total tx" <= 1000 then 'tier4: 100-1000 txs'
when "Total tx" > 1000 then 'tier5: more then 1000 txs'end as "Tier",
count (DISTINCT "Address") AS "Total Addresses"
from tbl
group by 1
order by 1 asc
Last run: 1 day ago
5
155B
65s