minted_tokens AS

SELECT

a.tx_hash AS transaction

, count( distinct a.tokenid ) AS token

FROM

avalanche.nft.ez_nft_transfers a

WHERE

a.nft_address = '0xcdab7d987f0198edb440d014ed1e71256a0e3e7a'

AND a.event_type = 'mint'

GROUP BY 1

ORDER BY 2 DESC

,

minted_chart_1 AS

SELECT

a.block_timestamp AS date

, a.nft_to_address AS minter

, a.tx_hash AS transaction

, a.project_name AS project_name

, a.tokenid AS token_id

, b.amount_precise / c.token AS amount

, b.amount_usd / c.token AS usd_volume

FROM

avalanche.nft.ez_nft_transfers a

LEFT OUTER JOIN

avalanche.core.ez_avax_transfers b

ON a.block_timestamp = b.block_timestamp

AND a.tx_hash = b.tx_hash

AND a.nft_to_address = b.origin_from_address