date_trunc('day', block_timestamp)::date as day,

count(distinct(tx_hash)) as tx_num,

count(distinct(nft_to_address)) as number_of_minters,

count(distinct(tokenid)) as number_of_tokens_minted,

sum(mint_price_usd) as mint_price_total_usd,

avg(mint_price_usd) as mint_price_usd_avg,

median(mint_price_usd) as mint_price_usd_median,

min(mint_price_usd) as mint_price_usd_min,

max(mint_price_usd) as mint_price_usd_max,

sum(tx_num) over (order by day asc) as comulative_tx_num

from ethereum.core.ez_nft_mints

where 1 = 1

and nft_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769'

group by day

order by day asc