Updated 2022-11-23
    with cextable as (select * from ethereum.core.dim_labels where label_type ilike 'cex'),
    Inflowt as (
    select sum (amount) as Inflow_Volume
    from ethereum.core.ez_eth_transfers
    where eth_to_address in (select distinct address from cextable)
    and eth_from_address not in (select distinct address from cextable)
    and block_timestamp >= '2022-11-01'),

    Outflowt as (
    select sum (amount) as Outflow_Volume
    from ethereum.core.ez_eth_transfers
    where eth_from_address in (select distinct address from cextable)
    and eth_to_address not in (select distinct address from cextable)
    and block_timestamp >= '2022-11-01')


    select inflow_volume as Inflow,
    outflow_volume*-1 as Outflow,
    inflow_volume - outflow_volume as Net_Flow
    from Inflowt t1 join Outflowt t2
    Run a query to Download Data