sum(PRICE) as volume

,count(distinct BUYER) as buyer_count

,count(distinct SELLER) as seller_count

,count(distinct NFT_ID) as sold_token

,count(distinct TX_ID) as sale_count

,avg(PRICE) as avg_price

,max(PRICE) as ceiling_price

,min(PRICE) as floor_price

,median(PRICE) as trade_price

from flow.core.ez_nft_sales

where NFT_COLLECTION like '%Dimension%'

and TX_SUCCEEDED='true'