sherwanxplyrsal
Updated 2022-10-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with metadata as (select nft_id as players, player from flow.core.dim_topshot_metadata)
select
player,
sum(price) as volume,
count(DISTINCT(TX_ID)) as sales_count
from flow.core.fact_nft_sales left join metadata on players=nft_id
where nft_collection='A.0b2a3299cc857e29.TopShot' and currency='A.ead892083b3e2c6c.DapperUtilityCoin' and tx_succeeded='TRUE' and player is not null
AND player!='N/A' and block_timestamp >='2022-07-01'
group by 1
order by 3 desc
limit 10
Run a query to Download Data