block_timestamp::date as date,

count(distinct tx_id) as "Number Sell",

count(distinct buyer) as "Unique Buyers",

count(distinct seller) as "Unique Seller"

from flow.core.fact_nft_sales

where block_timestamp>= CURRENT_DATE-30

and NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'

and tx_succeeded = 'TRUE'

group by 1

order by date