superflyUntitled Query
Updated 2022-07-12
9
1
2
3
4
5
6
7
8
9
›
⌄
select M.team , count (S.seller) as Count_of_sells ,sum (s.Price ) as volume
from flow.core.dim_topshot_metadata M
join flow.core.fact_nft_sales S on M.nft_id= S.nft_id
and S.tx_succeeded = 'TRUE'
and M.NFT_COLLECTION like '%TopShot'
and S.block_timestamp between '2022-05-17' and '2022-05-30'
group by 1
order by 3 DESC
Run a query to Download Data