select

address,

Project_name as CEX_Name

from avalanche.core.dim_labels

where label_type = 'cex'

),

ez_transfer as (

select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

TO_ADDRESS,

SYMBOL,

AMOUNT_USD

from avalanche.core.ez_token_transfers

where 1=1

and BLOCK_TIMESTAMP >= current_date - 30

and amount_usd is not null

union all

select

BLOCK_TIMESTAMP,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ETH_TO_ADDRESS as TO_ADDRESS,

'AVAX' as SYMBOL,

AMOUNT_USD

from avalanche.core.ez_avax_transfers

where 1=1

and BLOCK_TIMESTAMP >= current_date - 30

and amount_usd is not null

),