niloUntitled Query
Updated 2022-10-14
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
sum(price) as volume,
count(tx_id) as sales,
count(distinct buyer) as buyers,
count(distinct seller) as sellers
from flow.core.fact_nft_sales sales
join flow.core.dim_topshot_metadata meta on meta.nft_id=sales.nft_id
where sales.nft_collection='A.0b2a3299cc857e29.TopShot'
and TX_SUCCEEDED='TRUE'
and currency='A.ead892083b3e2c6c.DapperUtilityCoin'
Run a query to Download Data