count(distinct buyer_address) as active_users,

count(distinct tx_hash) as sales,

sum(price_usd) as volume

from near.nft.ez_nft_sales

where block_timestamp>=current_date-interval '1 MONTH' and block_timestamp<current_date