PROJECT | N_NEW_USRS | % of All NEAR Users | SECTOR | |
|---|---|---|---|---|
1 | kaikai | 46230215 | 62.9922 | dapp |
2 | playember | 10031036 | 13.6681 | games |
3 | sweat | 5273629 | 7.1857 | games |
4 | here wallet | 1173443 | 1.5989 | dapp |
5 | uwon | 219585 | 0.2992 | defi |
6 | astro stakers | 108494 | 0.1478 | defi |
7 | mpdao | 77268 | 0.1053 | defi |
8 | learn near club | 46925 | 0.0639 | dapp |
9 | harvest moon | 32092 | 0.0437 | games |
10 | hot near wallet | 32083 | 0.0437 | dapp |
11 | usdc | 30169 | 0.0411 | defi |
12 | lonk | 24351 | 0.0332 | defi |
13 | lnr | 20477 | 0.0279 | defi |
14 | ledger | 19421 | 0.0265 | defi |
15 | aurora | 18066 | 0.0246 | bridge |
16 | linear protocol | 14998 | 0.0204 | defi |
17 | orderly network | 11324 | 0.0154 | defi |
18 | trust nodes | 9970 | 0.0136 | defi |
19 | neat | 9258 | 0.0126 | defi |
20 | lis | 6022 | 0.0082 | defi |
0xHaM-dOnboarding Users to Projects
Updated 2025-04-30
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 projectsTb as (
select
address,
project_name as project,
label_type as Sector
from
near.core.dim_address_labels
where
project_name is not null
and label_type not in ('chadmin', 'cex', 'token', 'fungible_token')
and project_name != 'Exchanges'
),
newr_new_users as (
select
tx_signer,
min(BLOCK_TIMESTAMP) as min_date
from
near.core.fact_transactions
where
tx_signer not in (
select
address
from
projectsTb
)
GROUP BY
1
),
all_newr_new_users as (
select
count(distinct tx_signer) as n_new_users
from
newr_new_users
),
new_usersTb as (
select
Last run: about 2 months ago
...
365
10KB
265s