TYPE | ADDRESS | TXNS | |
|---|---|---|---|
1 | Active Addresses | 2348409 | 243250964 |
2 | New Addresses | 160238202 | 331878834 |
hess12. Share of Activity
Updated 9 days ago
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 new as (select min(block_timestamp::date) as date,
(from_address) as users
from monad.testnet.fact_transactions
where tx_succeeded = 'TRUE'
group by 2)
,
final as (select DISTINCT users
from new
where date >= current_date - 40
)
select
case when from_address in (select users from final) then 'New Addresses' else 'Active Addresses' end as type,
count(DISTINCT from_address) as address,
count(DISTINCT tx_hash) as txns
from monad.testnet.fact_transactions
where block_timestamp::date >= current_date - 30
group by 1
Last run: 9 days ago
2
78B
689s