Tier | Total Addresses | |
|---|---|---|
1 | 2-5 tx | 961829 |
2 | only 1 tx | 584038 |
3 | 6-10 tx | 215618 |
4 | 11-50 tx | 85826 |
5 | 51-100 tx | 6201 |
6 | more than 100 tx | 3574 |
Mrftiharsh-apricot copy copy
Updated 8 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
›
⌄
-- forked from harsh-apricot copy @ https://flipsidecrypto.xyz/studio/queries/a3d49337-f7b9-4f9d-892c-efc3c854e31e
with tbl AS
(
SELECT
REGEXP_SUBSTR(fee_msg['transition']['outputs'][0]['value'], 'aleo[\\w]+') AS "Address",
count (DISTINCT tx_id) as "Total transactions"
FROM aleo.core.fact_transactions
WHERE tx_succeeded = TRUE
GROUP BY 1
order by 2 desc
)
SELECT
case
when "Total transactions" = 1 then 'only 1 tx'
when "Total transactions" >= 2 and "Total transactions" <= 5 then '2-5 tx'
when "Total transactions" > 5 and "Total transactions" <= 10 then '6-10 tx'
when "Total transactions" > 10 and "Total transactions" <= 50 then '11-50 tx'
when "Total transactions" > 50 and "Total transactions" <= 100 then '51-100 tx'
when "Total transactions" > 100 then 'more than 100 tx'
end as "Tier",
count (DISTINCT "Address") AS "Total Addresses"
from tbl
group by 1
order by 2 desc
Last run: about 8 hours agoAuto-refreshes every 12 hours
6
123B
25s