with cex_address as (

select address

from crosschain.core.address_labels

where blockchain = 'avalanche'

and label_type = 'cex'

),

avax_price as (

select hour::date as price_date,

avg(price) as avax_price

from avalanche.core.fact_hourly_token_prices

where symbol = 'WAVAX'

group by 1

),

inflow as (

select *, eth_to_address as user_address from avalanche.core.ez_avax_transfers

where eth_from_address in (select address from cex_address)

),

outflow as (

select *, eth_from_address as user_address from avalanche.core.ez_avax_transfers

where eth_to_address in (select address from cex_address)

, base as (

select *, 'Inflow' as type from inflow

UNION

select *, 'Outflow' as type from outflow

select

type,

count(distinct user_address) as total_address,