(select ADDRESS from

solana.core.dim_labels

where

LABEL_TYPE='cex' and LABEL='ftx')

select SIGNERS[0] as user,

POST_TOKEN_BALANCES[0]['mint'] as mint1, POST_TOKEN_BALANCES[0]['uiTokenAmount']['amount']/pow(10, POST_TOKEN_BALANCES[0]['uiTokenAmount']['decimals']) as amount1 ,

POST_TOKEN_BALANCES[1]['mint'] as mint2, POST_TOKEN_BALANCES[1]['uiTokenAmount']['amount']/pow(10, POST_TOKEN_BALANCES[1]['uiTokenAmount']['decimals']) as amount2 ,

POST_TOKEN_BALANCES[2]['mint'] as mint3, POST_TOKEN_BALANCES[2]['uiTokenAmount']['amount']/pow(10, POST_TOKEN_BALANCES[2]['uiTokenAmount']['decimals']) as amount3 ,

POST_TOKEN_BALANCES[3]['mint'] as mint4, POST_TOKEN_BALANCES[3]['uiTokenAmount']['amount']/pow(10, POST_TOKEN_BALANCES[3]['uiTokenAmount']['decimals']) as amount4 ,

BLOCK_TIMESTAMP from solana.core.fact_transactions

where

SIGNERS[0] in (select ADDRESS from t1)

limit 10