PLATFORM_NAME,

count(DISTINCT SELLER_ADDRESS) as "unique seller count",

count(1) as "sell count",

sum(PRICE_USD) as "volume"

from optimism.core.ez_nft_sales

where date_trunc('day', block_timestamp) >= '2022-07-01' and date_trunc('day', block_timestamp) < '2022-08-01'

group by PLATFORM_NAME