date_trunc('day',block_timestamp) as DATE, count(tx_from_address) as number_from_tx, count(tx_to_address) as number_to_tx

solana.transactions

WHERE COLLATE(tx_from_address, 'lower') IN (

SELECT address

FROM crosschain.address_labels

WHERE blockchain = 'solana'

AND label_type = 'cex'

AND address_name is not null

)

AND block_timestamp BETWEEN '2021-12-01' AND '2021-12-30'

GROUP BY 1

ORDER BY DATE DESC