yasmin-n-d-r-hNEW USER
Updated 2024-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH user_first_transaction AS (
SELECT
from_address,
MIN(BLOCK_TIMESTAMP) AS first_transaction_time
FROM
avalanche.core.fact_transactions
WHERE
LOWER(to_address) IN (
LOWER('0xDef9ee39FD82ee57a1b789Bc877E2Cbd88fd5caE'),
LOWER('0xC009a670E2B02e21E7e75AE98e254F467f7ae257'),
LOWER('0x19C0FC4562A4b76F27f86c676eF5a7e38D12a20d')
)
AND STATUS = 'SUCCESS'
GROUP BY
from_address
)
SELECT
DATE_TRUNC('week', first_transaction_time) AS date,
COUNT(*) AS new_users
FROM
user_first_transaction
GROUP BY
date;
QueryRunArchived: QueryRun has been archived