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 like '%TopShot'

and tx_succeeded = 'TRUE'

--group by day order by day desc