date_trunc('month', block_timestamp) as month,

count(distinct(tx_id)) as number_of_mint,

sum(mint_price) as mint_amount,

count(distinct (purchaser)) as purchaser_num,

(number_of_mint / purchaser_num) as avg_mint_of_buyer,

(number_of_mint / datediff(day, current_date - interval '{{ months }} month', current_date)) as avg_number_of_mint,

(mint_amount / datediff(day, current_date - interval '{{ months }} month', current_date)) as avg_mint_amount

from solana.core.ez_nft_mints

where block_timestamp::date >= current_date - interval '{{ months }} month'

and succeeded = 1

group by month

order by month asc