ML68ava
    Updated 2023-04-16
    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