initial_transfers AS (

SELECT tx_id,

tx_from AS initial_address

FROM solana.core.fact_transfers

WHERE

block_timestamp >= '2023-11-19'

AND mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND tx_to = '8LhbqukdwDM26wbMzoZ3mxZtYd6yNxrHyJpaGXjkzpVA'

),

cex_addresses AS (

SELECT address

FROM solana.core.dim_labels

WHERE label_type = 'cex'

),

subsequent_transfers AS (

SELECT

ft.tx_id,

ft.tx_from,

ft.tx_to

FROM solana.core.fact_transfers ft

JOIN initial_transfers it

ON ft.tx_from = it.initial_address

WHERE

ft.block_timestamp >= '2023-11-19'

AND ft.mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND ft.tx_to != '8LhbqukdwDM26wbMzoZ3mxZtYd6yNxrHyJpaGXjkzpVA'

),

target_transfers AS (

SELECT

tt.tx_id,

st.tx_to AS subsequent_address,

tt.tx_to AS target_address

FROM subsequent_transfers st

LEFT JOIN solana.core.fact_transfers tt

ON tt.tx_from = st.tx_to