minting_txhash as

select

a.block_timestamp as datetimes ,

a.tx_hash as txhashs ,

a.nft_from_address as from_address ,

a.nft_to_address as to_address ,

a.tokenid as token_id

from

avalanche.nft.ez_nft_transfers a

where

a.nft_address = '0xce4fee23ab35d0d9a4b6b644881ddd8adebeb300'

and a.event_type = 'mint'

group by 1 , 2 , 3 , 4 , 5

order by 1 desc

,

total_txhashs as

select

b.datetimes as datetimes ,

b.txhashs as txhashs ,

count( a.tx_hash ) as totaltxhashs

from

avalanche.core.fact_transactions a

inner join

minting_txhash b

on a.block_timestamp = b.datetimes

and a.tx_hash = b.txhashs

group by 1 , 2

order by 1 desc