MLDZMNaave8
Updated 2022-07-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
block_timestamp::date as day,
PROJECT_NAME,
count(FROM_ADDRESS) as no_holders,
sum(no_holders) over (partition by PROJECT_NAME order by day) as grow_rate
from avalanche.core.fact_transactions x join avalanche.core.dim_labels y on x.TO_ADDRESS= y.address
where label_subtype != 'token_contract'
and LABEL_TYPE ='layer2'
and STATUS = 'SUCCESS'
group by 1,2
Run a query to Download Data