peteerplayer
    Updated 2022-09-05
    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