with daily_Average as (

select

date_trunc('day',block_timestamp) date

,count(tx_hash) mints

,count(distinct nft_to_address) Users_minting

from bsc.nft.ez_nft_transfers

where block_timestamp > '2023-09-15'

and event_type = 'mint'

and nft_address = '0x9d2e6134af5b63498d15546f2701837f001c6043'

group by 1

)

select

avg(mints) avg_daily_mints

,avg(users_minting) avg_daily_minters

from daily_average