MLDZMNnext10
Updated 2022-10-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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