select 'SORARE'as coll--,BLOCK_TIMESTAMP::date as date

,count(distinct BUYER_ADDRESS)as "Total Buyer Count"

,count(distinct NFT_ADDRESS)as "Total Collection Count"

,count(distinct SELLER_ADDRESS)as "Total Seller count"

,sum(PRICE_USD)as "Total USD Sales Volume"

,count(distinct TOKENID)as "Total Token Count"

,count(distinct TX_HASH) as "Total Sale Count"

,avg(PRICE_USD) as "Avg Sales Price"

,max(PRICE_USD) as "Max sales Price"

,min(PRICE_USD) as "Min sales Price"

,median(PRICE_USD) as "Median sales Price"

from ethereum.core.ez_nft_sales

where NFT_ADDRESS='0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'

and PLATFORM_NAME='opensea'

and PRICE_USD>0

group by 1