DATE(BLOCK_TIMESTAMP) AS transfer_date,

COUNT(*) AS daily_transfers

FROM ronin.nft.ez_nft_transfers

WHERE BLOCK_TIMESTAMP >= '2025-01-01' AND BLOCK_TIMESTAMP < '2025-04-01'

GROUP BY transfer_date

ORDER BY transfer_date;