Tier | Total Addresses | |
|---|---|---|
1 | tier1: only 1 tx | 3231640 |
2 | tier2: 2-10 txs | 26189263 |
3 | tier3: 10-100 txs | 3430978 |
4 | tier4: 100-1000 txs | 1201604 |
5 | tier5: more then 1000 txs | 45859 |
Mrftisimilar-cyan copy
Updated 2025-03-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from similar-cyan @ https://flipsidecrypto.xyz/studio/queries/18a06027-f806-4600-a6eb-fdedf6f47270
with tbl AS
(
SELECT
from_address as "Address",
count (DISTINCT tx_hash) as "Total tx"
from berachain.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: 3 months ago
5
157B
256s