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