DATE | N_UNIQUE_NEW_WALLET | N_UNIQUE_WALLET | |
|---|---|---|---|
1 | 2024-02-04 00:00:00.000 | 7874 | 41405 |
2 | 2024-02-05 00:00:00.000 | 9474 | 44641 |
SocioCryptoNew users / active user per day - 24 difference
Updated 2024-02-06
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
›
⌄
SELECT a.date,
a.new_address as N_UNIQUE_NEW_WALLET,
b.address as N_UNIQUE_WALLET
FROM
(SELECT date_trunc('day', f_txn) as date,
COUNT (DISTINCT from_address) as new_address
FROM
(
SELECT from_address,
min(block_timestamp) as f_txn
FROM avalanche.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP by from_address
)
GROUP by date) a
LEFT JOIN (
SELECT date_Trunc('day', block_timestamp) as date,
count(DISTINCT from_address) as address
FROM avalanche.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP by date
)b
ON a.date = b.date
WHERE a.date between CURRENT_DATE-2 and CURRENT_DATE-1
ORDER BY a.date
Last run: over 1 year ago
2
79B
268s