feyikemiAxelar User Interaction
Updated 2024-04-18
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
›
⌄
with new_users AS
(SELECT
tx_from,
min(block_timestamp) as first_tx_timestamp
FROM
axelar.core.fact_transactions
GROUP by tx_from
)
SELECT
date_trunc('week', first_tx_timestamp) as week,
'New Users' as type,
count(tx_from) as users_Count
FROM
new_users
GROUP BY week, type
UNION ALL
SELECT
date_trunc('week', block_timestamp) as week,
'Returning Users' as type,
count(DISTINCT tx_from) as users_Count
FROM
axelar.core.fact_transactions
GROUP BY week
QueryRunArchived: QueryRun has been archived