select *

from ethereum.core.dim_labels

where label_type ilike 'cex'),

opcextable as (

select *

from optimism.core.dim_labels

where label_type ilike 'cex'),

solcextable as (

select *

from solana.core.dim_labels

where label_type ilike 'cex'),

ethOutflowt as (

select block_timestamp,

to_address as receiver

from ethereum.core.ez_token_transfers

where from_address in (select distinct address from ethcextable)

and to_address not in (select distinct address from ethcextable)

and block_timestamp >= '2022-10-25'

union ALL

select block_timestamp,

eth_to_address as receiver

from ethereum.core.ez_eth_transfers

where eth_from_address in (select distinct address from ethcextable)

and Eth_to_address not in (select distinct address from ethcextable)

and block_timestamp >= '2022-10-25'),

opOutflowt as (

select block_timestamp,

to_address as receiver

from optimism.core.fact_token_transfers