peteerplayer
Updated 2022-09-05
9
1
2
3
4
5
6
7
›
⌄
with sales as (select nft_id,price,buyer,seller,block_timestamp from flow.core.ez_nft_sales where nft_collection like '%AllDay%')
, metadata as (select nft_id,player,season,team,week,moment_stats_full:metadata:playerPosition as playerPosition from flow.core.dim_allday_metadata)
select player,count(sales.nft_id) , sum(price) , count(distinct buyer) , count(distinct seller)
from sales inner join metadata on sales.nft_id=metadata.nft_id
group by 1
Run a query to Download Data