Updated 2023-04-14
    with binance_to_Avalanche as (select count(distinct TX_HASH) as transfer_count,count(distinct FROM_ADDRESS) as users , sum(RAW_AMOUNT/pow(10,decimals)) as volume , trunc(block_timestamp, 'MONTH') as days
    from avalanche.core.fact_token_transfers inner join avalanche.core.dim_labels
    on FROM_ADDRESS=address
    inner join avalanche.core.dim_contracts
    on contract_address=avalanche.core.dim_contracts.address
    where address_name like '%binance%' and RAW_AMOUNT/pow(10,decimals)< 999999999
    group by days )
    , Avalanche_to_binance as (select count(distinct TX_HASH) as transfer_count,count(distinct TO_ADDRESS) as users, sum(RAW_AMOUNT/pow(10,decimals)) as volume , trunc(block_timestamp, 'MONTH') as days
    from avalanche.core.fact_token_transfers inner join avalanche.core.dim_labels
    on TO_ADDRESS=address
    inner join avalanche.core.dim_contracts
    on contract_address=avalanche.core.dim_contracts.address
    where address_name like '%binance%' and RAW_AMOUNT/pow(10,decimals)< 999999999
    group by days)
    select 'Binance TO Avalanche' , * from binance_to_Avalanche
    UNION
    select 'Avalanche TO Binance' , * from Avalanche_to_binance
    Run a query to Download Data