ML68ava
Updated 2023-04-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with cex_address_table as
(
select address,project_name from avalanche.core.dim_labels
where label_type='cex'
)
, avax_transfers_most_active_users as
(
select count(*) as tx_count , ETH_FROM_ADDRESS as users , project_name
from avalanche.core.ez_avax_transfers
inner join cex_address_table
on address=ETH_FROM_ADDRESS
group by project_name , users
)
select count(*) as count , project_name from avax_transfers_most_active_users
where tx_count>10
group by project_name
Run a query to Download Data