tx_from,

tx_to AS address,

tx_id,

amount

FROM

solana.core.fact_transfers

WHERE

block_timestamp >= '2023-09-01'

AND mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND tx_to IN ('43DbAvKxhXh1oSxkJSqGosNw3HpBnmsWiak6tB5wpecN', 'BbHG9GvPActFGogv3iNrpDAj4qpXr8t3jF16uGxXcKci')

ORDER BY amount DESC

LIMIT 10

SELECT

tx_to,

tx_from,

amount,

tx_id

FROM

solana.core.fact_transfers

WHERE

block_timestamp >= '2023-09-01'

AND mint = 'HZ1JovNiVvGrGNiiYvEozEVgZ58xaU3RKwX8eACQBCt3'

AND tx_from IN ('9Mb26cH5A1c9YaJ95A95HNZwPD3WxLEnucG446umE8bc')

ORDER BY amount DESC

LIMIT 100

select distinct label

from solana.core.dim_labels

where label_type = 'cex'

and label = 'bitget'