MLDZMNnext7
    Updated 2022-10-03
    select
    date_trunc('week',block_timestamp) as week,
    Label,
    count(tx_hash) as no_wallets,
    sum(no_wallets) over (partition by Label order by week) as grow_rate
    from ethereum.core.fact_token_transfers x join ethereum.core.dim_labels y on x.TO_ADDRESS= y.address
    where label_subtype != 'token_contract'
    and LABEL_TYPE in ('layer2')
    and block_timestamp>='2022-01-01'
    group by 1,2

    Run a query to Download Data