DATE | # of New Users | Cumulative # of Users | |
|---|---|---|---|
1 | 2024-11-30 00:00:00.000 | 78 | 8966 |
2 | 2025-01-19 00:00:00.000 | 50 | 11467 |
3 | 2024-09-07 00:00:00.000 | 76 | 1023 |
4 | 2024-09-10 00:00:00.000 | 94 | 1333 |
5 | 2024-10-04 00:00:00.000 | 40 | 2006 |
6 | 2024-11-27 00:00:00.000 | 84 | 8691 |
7 | 2025-02-17 00:00:00.000 | 2 | 11757 |
8 | 2025-02-13 00:00:00.000 | 2 | 11750 |
9 | 2024-08-15 00:00:00.000 | 32 | 47 |
10 | 2024-11-23 00:00:00.000 | 111 | 8100 |
11 | 2024-09-30 00:00:00.000 | 17 | 1899 |
12 | 2025-01-10 00:00:00.000 | 68 | 10753 |
13 | 2024-10-18 00:00:00.000 | 12 | 2462 |
14 | 2025-02-16 00:00:00.000 | 2 | 11755 |
15 | 2024-12-27 00:00:00.000 | 29 | 10264 |
16 | 2024-10-06 00:00:00.000 | 42 | 2094 |
17 | 2024-09-12 00:00:00.000 | 48 | 1446 |
18 | 2025-01-27 00:00:00.000 | 2 | 11712 |
19 | 2024-10-01 00:00:00.000 | 23 | 1922 |
20 | 2024-10-03 00:00:00.000 | 22 | 1966 |
rezarwzNew users
Updated 2025-02-26
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 all_wallets as (
SELECT
block_timestamp,
tx_hash,
to_address AS created_contract_address,
from_address AS creator_address,
from
blast.core.fact_traces
WHERE
TYPE ILIKE 'create%'
AND to_address IS NOT NULL
AND input IS NOT NULL
AND input != '0x'
AND tx_status = 'SUCCESS'
AND trace_status = 'SUCCESS'
and tx_hash in (
SELECT
tx_hash
FROM
blast.core.fact_transactions
where
to_address = lower('0x0000000071727De22E5E9d8BAf0edAc6f37da032')
)
)
SELECT
date_Trunc('{{time_frame}}', block_Timestamp) as date,
count(created_contract_address) as "# of New Users",
sum(count(created_contract_address)) over(
order by
date_Trunc('{{time_frame}}', block_Timestamp) asc
) as "Cumulative # of Users"
FROM
all_wallets
where
block_timestamp :: date >= '2024-07-20'
group by
Last run: about 2 months ago
...
187
7KB
164s