Type | Date | New User Count | New User Growth Trends | |
---|---|---|---|---|
1 | Total New Users | 2022-08-01 00:00:00.000 | 61200 | 3347911 |
2 | New User for PlayEmber Project | 2023-08-01 00:00:00.000 | 238412 | 709301 |
3 | Total New Users | 2022-03-01 00:00:00.000 | 896188 | 3023456 |
4 | Total New Users | 2022-10-01 00:00:00.000 | 576762 | 4948932 |
5 | Total New Users | 2023-06-01 00:00:00.000 | 275209 | 7392685 |
6 | New User for PlayEmber Project | 2022-10-01 00:00:00.000 | 19784 | 19784 |
7 | Total New Users | 2021-03-01 00:00:00.000 | 12340 | 46557 |
8 | Total New Users | 2022-07-01 00:00:00.000 | 83967 | 3286711 |
9 | Total New Users | 2021-09-01 00:00:00.000 | 405104 | 964726 |
10 | New User for PlayEmber Project | 2023-05-01 00:00:00.000 | 18720 | 211997 |
11 | Total New Users | 2021-02-01 00:00:00.000 | 11572 | 34217 |
12 | Total New Users | 2021-04-01 00:00:00.000 | 84093 | 130650 |
13 | New User for PlayEmber Project | 2023-12-01 00:00:00.000 | 1289941 | 2539395 |
14 | Total New Users | 2020-10-01 00:00:00.000 | 3423 | 6903 |
15 | Total New Users | 2023-08-01 00:00:00.000 | 723401 | 8526759 |
16 | New User for PlayEmber Project | 2023-01-01 00:00:00.000 | 27321 | 111720 |
17 | Total New Users | 2021-05-01 00:00:00.000 | 55364 | 186014 |
18 | Total New Users | 2021-12-01 00:00:00.000 | 431592 | 1966583 |
19 | New User for PlayEmber Project | 2023-03-01 00:00:00.000 | 28884 | 162080 |
20 | Total New Users | 2021-07-01 00:00:00.000 | 61434 | 370392 |
Yousefi_1994Specific-Project - Weekly New User on Near and New User for Project
Updated 2024-01-29
999
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
›
⌄
--The near_project table is forked from 'Zanyar_98' to fix the project name
with near_project as (
select
address,
case
when project_name = 'sweat' or project_name = 'Sweat Economy' or project_name = 'SWEAT' then 'Sweat Еconomy'
when project_name = 'PlayEmber' or project_name = 'playember' then 'PlayEmber'
when project_name = 'Paras (PARAS)' or project_name = 'paras' then 'Paras'
when project_name = 'Ref Finance' or project_name = 'ref finance' then 'Ref Finance'
when project_name = 'Skyward' or project_name = 'skyward' or project_name ='SKYWARD' then 'Skyward'
when project_name = 'AURORA' or project_name = 'Aurora (AURORA)' then 'Aurora'
when project_name = 'jumbo' or project_name = 'Jumbo' or project_name ='jumbo exchange' then 'Jumbo'
when project_name = 'Spin' or project_name = 'SPIN' or project_name = 'spin' then 'Spin'
when project_name = 'cheddar' or project_name = 'Cheddar' then 'Cheddar'
when project_name = 'burrow' or project_name = 'Burrow' then 'Burrow'
when project_name = 'ZomLand' or project_name = 'zomland' then 'ZomLand'
when project_name = 'PixelDapps' or project_name = 'pixeldapps' then 'PixelDapps'
when project_name = 'open shards alliance' or project_name = 'Open Shards Alliance' then 'Open Shards Alliance'
when project_name = 'HAPI' or project_name = 'HAPI (HAPI)' then 'HAPI'
when project_name = 'Linear' or project_name = 'LINEAR' then 'LiNEAR'
when project_name = 'neko' or project_name = 'NEKO(OLD)' or project_name ='Neko' then 'Neko'
when project_name = 'mintbase' or project_name = 'Mintbase' then 'Mintbase'
when project_name = 'Playible' or project_name = 'playible' then 'playible'
when project_name = 'marmaj' or project_name = 'Marma J Foundation (MARMAJ)' then 'MARMAJ'
when project_name = 'Enleap' or project_name = 'enleap' then 'Enleap'
when project_name = 'Pembrock' or project_name = 'pembrock' then 'Pembrock'
when project_name = 'Tonic' or project_name = 'tonic' then 'Tonic'
when project_name = 'pem' or project_name = 'Pembrock' or project_name ='pembrock' then 'Pembrock'
when project_name = 'Fusotao Protocol (TAO)' or project_name = 'Fusotao' then 'Fusotao Protocol (TAO)'
when project_name = 'seat' or project_name = 'seatlab' then 'seat'
when project_name = 'Stader (NEARX)' or project_name = 'stader' then 'Stader (NEARX)'
when project_name = 'LazyFI' or project_name = 'LazyFi' then 'LazyFi'
when project_name = 'DOJO' or project_name = 'DOJO Finance' then 'DOJO Finance'
when project_name = 'PUMPOPOLY' or project_name = 'Pumpopoly' or project_name = 'pumpopoly' then 'Pumpopoly'
when project_name = 'Secret Skellies Society' or project_name = 'Secret Skellies Society (UTO)' then 'Secret Skellies Society'
Last run: over 1 year agoAuto-refreshes every 24 hours
59
4KB
645s