date(block_timestamp) as day,

count(distinct tx_id) as no_of_nfts_sold,

count(distinct buyer) as no_of_wallets,

sum(price) as total_sales_volume

from flow.core.fact_nft_sales

where marketplace in ('A.c1e4f4f4c4257510.Market', 'A.c1e4f4f4c4257510.TopShotMarketV3')

and nft_collection = 'A.0b2a3299cc857e29.TopShot'

and tx_succeeded = 'TRUE'

group by day order by day desc