DATE_TRUNC('day', transfer.block_timestamp) AS transfer_day,

SUM(transfer.raw_amount_precise / POWER(10, 18)) AS total_amount_to_cex

FROM

ethereum.core.fact_token_transfers AS transfer

JOIN

ethereum.core.dim_labels AS label

ON LOWER(transfer.to_address) = LOWER(label.address)

WHERE

LOWER(transfer.contract_address) = LOWER('0xec53bF9167f50cDEB3Ae105f56099aaaB9061F83')

AND label.label_type = 'cex'

AND transfer.block_timestamp > '2024-10-01'

GROUP BY

transfer_day

ORDER BY

transfer_day;