CONTRACT_ADDRESS,

COUNT(*) AS TRANSACTION_COUNT

FROM ethereum.core.ez_token_transfers

WHERE

CONTRACT_ADDRESS IN

(

lower('0xdAC17F958D2ee523a2206206994597C13D831ec7'), -- USDT contract

lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'), -- USDC contract

lower('0x6B175474E89094C44Da98b954EedeAC495271d0F') -- DAI contract

)

AND

BLOCK_TIMESTAMP::DATE BETWEEN '2024-05-01' AND '2024-05-31'

GROUP BY

CONTRACT_ADDRESS

ORDER BY

TRANSACTION_COUNT DESC;