with daily_activity as (select block_timestamp::date as dt, count(distinct tx_id) as num_txs, count(distinct purchaser) as num_buyers, sum(sales_amount) as NFT_sales_volume
from solana.core.fact_nft_sales a
join solana.core.dim_nft_metadata b
on a.mint = b.mint
where contract_name = 'Solana Monkey Business' and block_timestamp::date > current_date - 30 and succeeded = 'TRUE'
group by 1)
select sum(num_txs) as total_num_txs, sum(num_buyers) as total_num_buyers, sum(NFT_sales_volume) as total_NFT_sales_volume,
avg(num_txs) as avg_num_txs, avg(num_buyers) as avg_num_buyers, avg(NFT_sales_volume) as avg_NFT_sales_volume
from daily_activity