MLDZMNnext10
    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 ('defi','dapp')
    and block_timestamp>='2022-01-01'
    group by 1
    order by 2 desc limit 10

    Run a query to Download Data