select distinct ADDRESS

from crosschain.core.address_labels

where ADDRESS_NAME ilike '%ftx%' and LABEL_TYPE='cex'

),

withdraw as

(select BLOCK_TIMESTAMP, TO_ADDRESS, TX_HASH

from ethereum.core.ez_token_transfers

where BLOCK_TIMESTAMP>='2022-11-01' and BLOCK_TIMESTAMP<='2022-11-14' and ORIGIN_FROM_ADDRESS in (select * from ftx_addresses)

),

txs as (

select BLOCK_TIMESTAMP, TRANSFER_TYPE, SENDER, RECEIVER, CURRENCY, AMOUNT as RAW_AMOUNT, DECIMAL, RAW_AMOUNT/pow(10,DECIMAL) as amount,

case

when SENDER ilike 'agoric%' then 'Agoric'

when SENDER ilike 'axelar%' then 'Axelar'

when SENDER ilike 'bcna%' then 'BitCanna'

when SENDER ilike 'comdex%' then 'Comdex'

when SENDER ilike 'cosmos%' then 'Cosmos'

when SENDER ilike 'cre%' then 'Crescent'

when SENDER ilike 'emoney%' then 'e-Money'

when SENDER ilike 'evmos%' then 'Evmos'

when SENDER ilike 'inj%' then 'Injective'

when SENDER ilike 'juno%' then 'Juno'

when SENDER ilike 'ki%' then 'Ki'

when SENDER ilike 'kujir%' then 'Kujir'

when SENDER ilike 'mantl%' then 'AssetMantle'

when SENDER ilike 'osmo%' then 'Osmosis'

when SENDER ilike 'persi%' then 'Persistence'

when SENDER ilike 'regen%' then 'Regen'

when SENDER ilike 'rizon%' then 'Rizon'

when SENDER ilike 'secre%' then 'Secret'

when SENDER ilike 'stars%' then 'Stargaze'

when SENDER ilike 'swth1%' then 'Carbon'