MONTH | MONTH_NAME | Total Address | New Address | |
|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | January | 3049 | 3044 |
2 | 2025-02-01 00:00:00.000 | February | 4092467 | 4079454 |
3 | 2025-03-01 00:00:00.000 | March | 86953414 | 84518458 |
4 | 2025-04-01 00:00:00.000 | April | 82421222 | 76889919 |
hess10. New Address II
Updated 2025-04-13
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 basic AS (
SELECT
block_timestamp::date AS date,
tx_hash,
from_address AS user,
value,
tx_fee,
tx_succeeded
FROM
monad.testnet.fact_transactions
WHERE
block_timestamp::date >= '2025-01-07'
)
,
new as (select min(date::date) as date,
user
from basic
where tx_succeeded = 'TRUE'
group by 2)
,
total as ( select trunc(date,'month') as month,
month_name,
count(distinct user) as "Total Address"
from basic a join crosschain.core.dim_dates b on a.date = b.date_day
group by 1,2)
,
final_new as (select trunc(date,'month') as month,
month_name,
count(DISTINCT user) as "New Address"
from new a join crosschain.core.dim_dates b on a.date = b.date_day
where date >= '2024-05-27'
group by 1,2)
select a.month,
a.month_name,
"Total Address",
Last run: 12 days ago
4
212B
53s