MONTH | ACTIVE_USERS | NEW_USERS | TOTAL_USERS | |
|---|---|---|---|---|
1 | 2025-04-21 00:00:00.000 | 121677 | 58740 | 38079558 |
2 | 2025-04-14 00:00:00.000 | 101260 | 22480 | 38020818 |
3 | 2025-04-07 00:00:00.000 | 82820 | 26526 | 37998338 |
4 | 2025-03-31 00:00:00.000 | 85433 | 24193 | 37971812 |
5 | 2025-03-24 00:00:00.000 | 105049 | 32212 | 37947619 |
6 | 2025-03-17 00:00:00.000 | 94716 | 15782 | 37915407 |
7 | 2025-03-10 00:00:00.000 | 522801 | 442244 | 37899625 |
8 | 2025-03-03 00:00:00.000 | 603359 | 514477 | 37457381 |
9 | 2025-02-24 00:00:00.000 | 175774 | 5366 | 36942904 |
10 | 2025-02-17 00:00:00.000 | 76357 | 8299 | 36937538 |
11 | 2025-02-10 00:00:00.000 | 857786 | 6300 | 36929239 |
12 | 2025-02-03 00:00:00.000 | 2362648 | 5194 | 36922939 |
13 | 2025-01-27 00:00:00.000 | 548912 | 5069 | 36917745 |
14 | 2025-01-20 00:00:00.000 | 413620 | 204289 | 36912676 |
15 | 2025-01-13 00:00:00.000 | 86412 | 5233 | 36708387 |
16 | 2025-01-06 00:00:00.000 | 73617 | 5875 | 36703154 |
17 | 2024-12-30 00:00:00.000 | 77805 | 6469 | 36697279 |
18 | 2024-12-23 00:00:00.000 | 153284 | 10778 | 36690810 |
19 | 2024-12-16 00:00:00.000 | 83935 | 11595 | 36680032 |
20 | 2024-12-09 00:00:00.000 | 244592 | 175424 | 36668437 |
adriaparcerisasflow new and active users
Updated 2025-05-02
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 news AS (
SELECT
DISTINCT CAST(value AS VARCHAR) AS users, -- Explicitly casting to VARCHAR
MIN(trunc(b.block_timestamp, 'week')) AS debut
FROM
flow.core.ez_transaction_actors AS b,
LATERAL FLATTEN(INPUT => b.actors) AS a -- Flattening the actors array
GROUP BY 1
UNION ALL
SELECT
DISTINCT from_address AS users,
MIN(trunc(block_timestamp, 'week')) AS debut
FROM
flow.core_evm.fact_transactions
GROUP BY 1
),
news2 AS (
SELECT
debut,
COUNT(DISTINCT users) AS new_users
FROM
news
GROUP BY debut
),
actives AS (
SELECT
trunc(b.block_timestamp, 'week') AS week,
COUNT(DISTINCT CAST(value AS VARCHAR)) AS active_users -- Explicitly casting to VARCHAR
FROM
flow.core.ez_transaction_actors AS b,
LATERAL FLATTEN(INPUT => b.actors) AS a -- Flattening the actors array
GROUP BY 1
UNION ALL
Last run: about 1 month ago
...
245
12KB
172s