MLDZMNaave8
    Updated 2022-07-22
    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