MLDZMNava usdc 4 copy
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
›
⌄
select
date_trunc('month', BLOCK_TIMESTAMP)::date AS month,
PROJECT_NAME as platform,
count(distinct TX_hash) as txns,
count(distinct from_address) as users,
txns/users as txns_per_user,
row_number()over(partition by month order by txns_per_user desc) as rnk
from avalanche.core.ez_token_transfers
join avalanche.core.dim_labels on TO_ADDRESS = address
where block_timestamp::date >= CURRENT_DATE - {{days_back}}
and SYMBOL ilike 'usdc'
and LABEL_TYPE not in ('chadmin','token')
group by 1 ,2
qualify rnk <= 5
Run a query to Download Data