MLDZMNcex_name_sent
    Updated 2023-04-16
    with tb1 as(SELECT
    *
    from avalanche.core.dim_labels
    where label_type='cex'
    )


    select
    date_trunc('week',BLOCK_TIMESTAMP) as date,
    Project_name as CEXs,
    count(distinct tx_hash) as no_transfer,
    count(distinct ETH_FROM_ADDRESS) as no_sender,
    sum(AMOUNT_USD) as total_volume,
    avg(AMOUNT_USD) as avg_volume,
    median(AMOUNT_USD) as median_volume
    from avalanche.core.ez_avax_transfers s left join avalanche.core.dim_labels a on s.ETH_to_address=a.address
    where ETH_to_address in (select ADDRESS from tb1)
    and ETH_FROM_ADDRESS not in (select ADDRESS from tb1)
    and BLOCK_TIMESTAMP>='2022-03-01'
    and label_type='cex'
    group by 1,2
    union all
    select
    date_trunc('week',BLOCK_TIMESTAMP) as date,
    Project_name as CEXs,
    count(distinct tx_hash) as no_transfer,
    count(distinct FROM_ADDRESS) as no_sender,
    sum(AMOUNT_USD) as total_volume,
    avg(AMOUNT_USD) as avg_volume,
    median(AMOUNT_USD) as median_volume
    from avalanche.core.ez_token_transfers s left join avalanche.core.dim_labels a on s.to_address=a.address
    where TO_ADDRESS in (select ADDRESS from tb1)
    and FROM_ADDRESS not in (select ADDRESS from tb1)
    and BLOCK_TIMESTAMP>='2022-03-01'
    and label_type='cex'
    group by 1,2
    Run a query to Download Data