0xHaM-dNew Users Mint Over Time
Updated 2025-03-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 avUSD_mint as (
select
min(BLOCK_TIMESTAMP) as min_date,
DECODED_LOG:beneficiary::string as user_add,
from avalanche.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0x1499cb3197427b78dc0e2d356a1e0e4149e0ed51'
and EVENT_NAME in ('Mint')
and TX_SUCCEEDED = TRUE
group by 2
)
, aUSD_mint as (
select
min(BLOCK_TIMESTAMP) as min_date,
ORIGIN_FROM_ADDRESS::string as user_add,
from avalanche.core.ez_token_transfers
where contract_address ='0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
and from_address = '0x0000000000000000000000000000000000000000'
group by 2
)
,
aUSD_final as (
select
trunc(min_date, 'week') as date,
count(DISTINCT user_add) as n_minters,
sum(n_minters) over (order by date) as new_users_growth
from aUSD_mint
group by 1
order by 1 desc
)
,
avUSD_final as (
select
trunc(min_date, 'week') as date,
count(DISTINCT user_add) as n_minters,
sum(n_minters) over (order by date) as new_users_growth
from avUSD_mint