cexs as (

select

address,

case project_name

when 'binance' then 'Binance'

when 'bitfinex' then 'Bitfinex'

when 'bitstamp' then 'Bitstamp'

when 'bybit' then 'Bybit'

when 'coinbase' then 'Coinbase'

when 'gate.io' then 'Gate.io'

when 'gemini' then 'Gemini'

when 'huobi' then 'Huobi'

when 'kraken' then 'Kraken'

when 'kucoin' then 'KuCoin'

when 'okex' then 'OKX'

when 'okx' then 'OKX'

when 'mexc' then 'MEXC'

when 'mxc' then 'MEXC'

end as exchange

from

arbitrum.core.dim_labels

where

label_type = 'cex'

),

transfers_raw as (

select

block_timestamp,

tx_hash,

eth_from_address as sender,

eth_to_address as receiver,

amount_usd

from

arbitrum.core.ez_eth_transfers

where

block_timestamp::date >= (current_date - 10)