SELECT
t.FROM_ADDRESS AS Wallet,
SUM(t.AMOUNT) AS Total_Deposits_ETH,
l.label as CEX
FROM ethereum.core.ez_token_transfers t
JOIN ethereum.core.dim_labels l
ON t.FROM_ADDRESS = l.ADDRESS
WHERE l.LABEL_TYPE = 'cex'
AND t.block_timestamp >= DATEADD('day', -{{time_period_days}}, CURRENT_TIMESTAMP())
AND (t.symbol = 'ETH' OR t.symbol = 'eth')
GROUP BY t.FROM_ADDRESS, l.label, l.label_type
ORDER BY Total_Deposits_ETH DESC
LIMIT 100;