--NFT小时级别的mint数据(参与钱包数以及mint数)
--NFT Contract Address是NFT的合约地址
select
date_trunc('hour',evt_block_time+ '8 hour'::interval )  AS DAY
,count(distinct buy_wallet_address) as Mint钱包数
,count(*) as mint数
from
(
SELECT
evt_block_time
,"to" as buy_wallet_address
,row_number( ) over(partition by contract_address order by evt_block_time )  as num_rank
FROM  erc721."ERC721_evt_Transfer"
WHERE contract_address =  CONCAT('\\x', substring('{{NFT Contract Address}}' from 3))::bytea -- Token address
and "from" in ('\\x0000000000000000000000000000000000000000')
) a
group by 1
order by 1