nft_address as contract,

CURRENCY_SYMBOL,

count(distinct BUYER_ADDRESS) as buyers,

count(distinct SELLER_ADDRESS) as sellers,

sum(price) as volume,

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

PLATFORM_ADDRESS

from optimism.core.ez_nft_sales

where TIME != '2022-07-01'

group by contract, CURRENCY_SYMBOL, TIME,PLATFORM_ADDRESS