MLDZMNnext8
Updated 2022-10-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('month',block_timestamp) as month,
count(tx_hash) as no_wallets,
sum(no_wallets) over (order by month) 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
Run a query to Download Data