date(BLOCK_TIMESTAMP) as dt,

sum(price) as sale_vol,

count(tx_id) as sale_no,

count (distinct BUYER) as buyers,

count(distinct SELLER) as sellers,

buyers+sellers as trader

from flow.core.fact_nft_sales

where MARKETPLACE='A.c1e4f4f4c4257510.TopShotMarketV3'

and BLOCK_TIMESTAMP>='2022-05-09'

and TX_SUCCEEDED='TRUE'

group by 1

order by 1