tx_from AS address, tx_to,--, tx_id, block_timestamp,

SUM(amount) AS total_transferred_to_CEX

FROM

solana.core.fact_transfers t

LEFT JOIN

solana.core.dim_labels lf

ON lf.address = t.tx_from

WHERE

block_timestamp >= '2023-11-19'

AND mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND lf.label = 'bitget'

AND lf.label_type = 'cex'

GROUP BY

tx_from,tx_to --, tx_id, block_timestamp

ORDER BY

total_transferred_to_CEX DESC

LIMIT 100