select tx_id, count(tx_id) as sale_count, nft_id, buyer, seller,

date_trunc('day', block_timestamp::date) as TIME, sum(price) as price2

from flow.core.fact_nft_sales

where nft_collection = 'A.0b2a3299cc857e29.TopShot'

and currency = 'A.ead892083b3e2c6c.DapperUtilityCoin'

and block_timestamp > '2022-01-01'

group by nft_id, TIME, tx_id, buyer, seller

order by sale_count DESC

)

play_type,

count(*) as number_of_sales,

TIME,

sum(price2) as volume,

count(distinct buyer) as buyers,

count(distinct seller) as sellers

from flow.core.dim_topshot_metadata m

inner join sales s on s.nft_id = m.nft_id

group by play_type, TIME

order by number_of_sales desc