USER_TYPE | CREATORS | |
|---|---|---|
1 | c. 6 - 10 Tokens | 96233 |
2 | d. 11 - 25 Tokens | 48819 |
3 | f. > 50 Tokens | 7727 |
4 | a. 1 Tokens | 2996972 |
5 | e. 26 - 50 Tokens | 11900 |
6 | b. 2 - 5 Tokens | 634299 |
Afonso_DiazGrouping creators by number of txns
Updated 2025-02-26
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
32
33
34
35
36
›
⌄
with
main as (
select
tx_id,
signers[0] as creator,
decoded_instruction:args:symbol as symbol,
decoded_instruction:accounts[0]:pubkey as token_address
from
solana.core.fact_decoded_instructions
where
year(block_timestamp) >= 2024
and program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and event_type = 'create'
),
users as (
select
creator,
count(distinct token_address) as tokens_created
from
main
group by 1
)
select
case
when tokens_created = 1 then 'a. 1 Tokens'
when tokens_created <= 5 then 'b. 2 - 5 Tokens'
when tokens_created <= 10 then 'c. 6 - 10 Tokens'
when tokens_created <= 25 then 'd. 11 - 25 Tokens'
when tokens_created <= 50 then 'e. 26 - 50 Tokens'
else 'f. > 50 Tokens'
end as user_type,
count(distinct creator) as creators
from
Last run: 3 months ago
6
159B
21s