ML67ava
    Updated 2023-04-16
    with cex_address_table as
    (
    select address,project_name from avalanche.core.dim_labels
    where label_type='cex'
    )

    , token_transfers_Cex_to_Avalanche_table as
    (
    select count(distinct FROM_ADDRESS) as users , sum(AMOUNT_USD) as volume_usd , project_name , trunc(block_timestamp, 'week') as date_time
    from avalanche.core.ez_token_transfers
    inner join cex_address_table
    on address=FROM_ADDRESS
    group by project_name , date_time
    )
    , token_transfers_Avalanche_to_Cex_table as
    (
    select count(distinct FROM_ADDRESS) as users , sum(AMOUNT_USD) as volume_usd , project_name , trunc(block_timestamp, 'week') as date_time
    from avalanche.core.ez_token_transfers
    inner join cex_address_table
    on address=TO_ADDRESS
    group by project_name , date_time
    )



    select users,volume_usd,project_name , date_time
    from token_transfers_Avalanche_to_Cex_table
    Run a query to Download Data