select

sum (price_usd) as volume_usd,

count (distinct tx_hash) as Sales_Count,

count (distinct NFT_Address) as NFTs_Projects_Count,

count (distinct tokenid) as NFTs_Count,

count (distinct seller_address) as Sellers,

count (distinct buyer_address) as Buyers

from optimism.core.ez_nft_sales

where block_timestamp >= '2022-07-01'