DATE(BLOCK_TIMESTAMP) AS transaction_date,

COUNT(*) AS total_transactions

FROM ronin.nft.ez_nft_transfers

WHERE BLOCK_TIMESTAMP BETWEEN '2025-01-01' AND '2025-03-31'

GROUP BY transaction_date

ORDER BY transaction_date;