SELECT address FROM solana.core.dim_labels WHERE label_type = 'cex'

UNION

SELECT 'A77HErqtfN1hLLpvZ9pCtu66FEtM8BveoaKbbMoZ4RiR' --Bitget

UNION

SELECT '43DbAvKxhXh1oSxkJSqGosNw3HpBnmsWiak6tB5wpecN' --Backpack

UNION

SELECT 'BbHG9GvPActFGogv3iNrpDAj4qpXr8t3jF16uGxXcKci' --Backpack

union

select '9un5wqE3q4oCjyrDkwsdD48KteCJitQX5978Vh7KKxHo' -- OKX

)

,first_layer as (

select *

from solana.core.fact_transfers

where block_timestamp > current_date - interval '60 days'

and mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

and tx_from = 'FksUysV88RHA5YLnbqBfzt5DwJjsY11mWfEY7mhuSpkS'

, second_layer as (

select t2.*

from first_layer t1 join

solana.core.fact_transfers t2 on t1.tx_to = t2.tx_from

where t2.block_timestamp > current_date - interval '60 days'

and t2.tx_from != '9Mb26cH5A1c9YaJ95A95HNZwPD3WxLEnucG446umE8bc' --exclude airdrop address

and t2.mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

, third_layer as (

select t2.*

from second_layer t1 join

solana.core.fact_transfers t2 on t1.tx_to = t2.tx_from

where t2.block_timestamp > current_date - interval '60 days'

and t2.tx_from != '9Mb26cH5A1c9YaJ95A95HNZwPD3WxLEnucG446umE8bc'

and t2.mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

, summ as(

select tx_to