DATE(BLOCK_TIMESTAMP) AS TransferDate,

COUNT(*) AS NumberOfTransfers

FROM (

SELECT BLOCK_TIMESTAMP

FROM ethereum.nft.ez_nft_transfers

WHERE nft_address = lower('0x4cd0ea8b1bdb5ab9249d96ccf3d8a0d3ada2bc76')

) AS BoonjiTransfers

GROUP BY DATE(BLOCK_TIMESTAMP)

ORDER BY TransferDate;