tokenid,

count(DISTINCT nft_to_address) AS users,

count(tx_hash) AS animations,

count(tx_hash) * 2 AS nft_burned,

FROM base.nft.ez_nft_transfers

WHERE nft_address = '0xc59f475122e914afcf31c0a9e0a2274666135e4e'

AND block_timestamp::date >= '2024-08-29'

AND event_type = 'mint'

GROUP BY 1

ORDER BY 3 DESC