SniperTop Dexs by New Users copy
Updated 2025-02-22
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 users as (
SELECT
t1.block_timestamp,
project_name,
FROM_ADDRESS as user
FROM
kaia.core.fact_transactions t1
LEFT OUTER JOIN kaia.core.dim_labels t2 on t1.to_address = t2.address
WHERE
TX_SUCCEEDED= 'TRUE'
and label_type in ('dex')
)
,
new_user as ( select min(block_timestamp::date) as date,
project_name,
user
from users
group by 2,3
HAVING date >= current_date - 30)
select trunc(date,'day') as daily,
project_name,
count(DISTINCT user) as new_Users,
sum(new_Users) over (partition by project_name ORDER by daily asc ) as Cumulative_New_Users
from new_user
group by 1,2
HAVING new_Users >0
order by 1 asc
QueryRunArchived: QueryRun has been archived